Multiple primary keyword in Auto Fill

[Manikanadanbe]

Hello,

Is it possible to do a lookup on a auto-fill keyword set using more than one keyword?

Otherwise is it possible to get the other keyword values  from Autofill using unity script or script hook?

[Scott_McLean · Accepted solution]

Hi,

You may be able to do this using an autofill Unity script where you would retrieve based on one primary keyword and then only add the result row(s) where the second primary value is also a match.

Kind regards,

-Scott

[Scott_McLean · Accepted solution]

Hi,

You may be able to do this using an autofill Unity script where you would retrieve based on one primary keyword and then only add the result row(s) where the second primary value is also a match.

Kind regards,

-Scott

[Manikanadanbe]

Thanks for your reply.

As per my knowledge, autofill unity script using one primary keyword I can fill other secondary keywords.
But my concern is based on two primary keywords I want to fill other secondary keywords. Please let me know is there any way to achieve this?

[Nevin_Steindam]

There is a Workflow action named "Set Keyword Value from AutoFill Value", which lets you search an AutoFill by two values and copy one keyword from it. This may not be flexible enough to do what you're looking for, but it will be more convenient than a scripting solution if it does work for you.

[Marcus_Christi2]

You're referring to a composite primary key.  I haven't tested this, but I believe you'd need a stored procedure (which would then build and receive the composite from the two primaries).

Your challenge is the fact that autofill is triggered from a single keyword, where the other one may not exist yet.  Because of that, I would generally send it to workflow, build the composite with expression, store it to a throwaway keyword, perform the autofill needed, then drop the throwaway key.

If you're indexing with Unity Client you could in theory build a Unity Script, composite the two primaries and call the autofill off the composite.  Build a custom index panel where a custom action is set to call the script only when both keys are present.  That should be fairly simple to do.

This is one situation where I'd really love to have "Autofill Keyword Set to Properties".