10-13-2021 03:49 PM
Looking for example Unity API code to use as IExternalKeywordDataSetScript set, now that SQL Select String is no longer available.
I have 1 SQL table with Employee Information that used to be a very simple query. (Select ID, FName, LName From Employees Where ID = 'at- primary')
With that no longer an option, I am hoping people can share their code for this in Unity Scripts. When I look at the API, the sample does not complete the picture of how to query, build a results list, and then provide that back to the user within the Indexing screen, just:
args.Results.AddKeyword( KeywordResult );
https://sdk.onbase.com/unitySDK/html/7f924cd4-f368-463d-8093-536d89ec9861.htm
I have scripts that make a connection string, and select/insert to other tables. How does the IExternalKeywordDataSetScript know it is an array of multiple keyword values? etc.
Thanks in advance.
10-18-2021 01:37 PM
I cannot find this restriction in the EP3 MRG. What Page is it on?
10-18-2021 03:13 PM
Curtis, can you please elaborate on what you mean by "now that SQL Select String is no longer available."? What OnBase build are you working in? Also as
10-18-2021 04:26 PM
It's not that this functionality is no longer available but it seems likely this functionality will be removed in the future.
Page 605 of the EP5 SysAdmin MRG (Global Client Settings > Keyword tab) lists a new setting: "Enable SQL Select option for External AutoFill Keyword Sets and Data Sets". Everyone can read it for themselves but it comes with a warning: "Caution: SQL Select String functionality is being maintained for backwards compatibility, but it is no longer recommended and may be removed in a future release. Consider adopting Unity Scripts instead." I found no such reference in EP3 MRG.
10-18-2021 05:09 PM
Thanks
10-19-2021 01:55 PM
What is the reasoning behind removing SQL Select? Sometimes that's the most direct and easiest way to implement. Not every customer has a programmer to write a unity script to write a SQL query.
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.