02-12-2015 07:29 AM
We have an external auto fill keyword set that may--depending upon the value of the primary keyword--return multiple records from the external database. When we test this in Config it works as expected, showing all of the records returned from the external database. However, when we upload a doccument, enter a value for the primary keyword, and press the Tab key, the autofill only uses the first record, the Select Keyset dialogue box does not open.
Any ideas?
Steve Beck
02-12-2015 12:51 PM
How are you wanting it to be sorted, and what is the SQL you're currently using? Based on that I think I could give an example.
02-12-2015 12:55 PM
02-12-2015 12:59 PM
02-12-2015 04:08 PM
02-13-2015 05:19 AM
Hi Steve,
Thanks for the screenshot.
From the screenshot I see that the list is sorted by the TaskNumber within Config as you mentioned. I tested again with my External AutoFill Keyword Set and the Thick Client is respecting the ORDER BY clause. One thing to keep in mind is that if you make changes to your SQL you will have to click SAVE and come back into the External AutoFill Keyword Set Configuration screen before testing for the changes to be applied. Also, make sure that you relauch the client (or recycle/cache refresh on the Application Pool) for it to take affect.
If this does not work then I would recommend working with your first line of support to further troubleshoot the issue.
Take care.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.