Populating a MIKG as Autofill(external) from a Standard Keyword in a Unity Form

[Doug_Latch]

Here is my scenario -

We have a unity form where a user enters a customer name and an autofill external script then pulls a number of key values (based on that name) from an Oracle database via a web service.  This populates a keyword called Vendor ID.

From the Vendor ID, we need to make another call to the Oracle database to bring back a list of open invoices.  The user will then select the desired invoice(s) and the result will populate a MIKG in a table.  So far, the only way that I can get the table to populate is to include the Vendor ID in the MIKG but then the first autofill script doesn't have access to the keyword.

This must be a fairly common occurrence in AR and AP scenarios, where you need to bring back a list of invoices based on a value that is outside of the MIKG.  Any suggestions?

[Fabian_Serna]

Good Morning.


I had this same problem a customer and the solution was raised at the end:


Store all normal keyword in the unity form and eventually fill the KTG with a script unity. I expect a solution in the future.



Fabian Serna.


Regards!!!

[Tyler_Sorber]

Hi DLatch

As Fabian mentioned, Unity Forms are able to utilize this cascading functionality within the args.SearchParameters.RelatedKeywordRecords within an External Dataset Script.  This will require a checkbox to be enabled to pass the Related KeywordRecords to the Unity Form.  

Currently, there are multiple SCRs within the Development backlog to allow a wider use this functionality within standard Document.  I would recommend contacting your first line of support with your specific business case to be attached to an existing SCR.

[Doug_Latch]

Can you be more explicit regarding what check box needs to be set?

[Tyler_Sorber]

API Support has been contacted in regards to this issue. If a possible solution is found, it will be posted for the rest of Community.