06-26-2019 07:19 AM
Hello all,
I have a need to get all the records from a specific Autofill Keyword Set (AFKWS) in a script. I am familiar with how to retrieve all the records that match a certain primary key, but I cannot seem to find a way to get everything back. I tried searching for a primary key value of * to see if that would work. Unfortunately, it did not. Any ideas?
06-27-2019 07:48 AM
Hi Alexander --
The Unity API doesn't have a method for this, unfortunately; you would need to know all of the valid values for the PrimaryKeyword in order to get an exhaustive list back using GetKeysetData(List<Keyword>). Your best bet would be to query the database directly if you need the entire autofill data set.
06-27-2019 07:48 AM
Hi Alexander --
The Unity API doesn't have a method for this, unfortunately; you would need to know all of the valid values for the PrimaryKeyword in order to get an exhaustive list back using GetKeysetData(List<Keyword>). Your best bet would be to query the database directly if you need the entire autofill data set.
06-27-2019 01:44 PM
Thanks, Adam. Is there documentation somewhere of what the database looks like? I haven't gone into that side at all, but it could solve my issue here no question.
06-28-2019 01:16 AM
The OnBase database reporting guide should be a good start for you:
https://community.hyland.com/en/blog/posts/35989-onbase-database-reporting-guide
Good luck. 🙂
06-28-2019 08:40 AM
Lood, YES, THANK YOU! Another noob question. Is there somewhere I can test queries? I'm in a hosted environment so I'm not really sure how to access the database directly. I can write a query for the dataset, of course, but it would be useful to be able to poke around a bit before I do that.
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.