09-24-2013 10:02 AM
Is there anyway to sort external keywords alphabetically? I have tried a SQL script but it doesn't seem to sort and just displays in the order of the primary key on the database we pull the keyword from. My users are driving me crazy so any suggestion would be much appreciated.
Thanks in advance
09-24-2013 11:18 AM
I've done this before with no problems. Below is the SQL statement I've used when doing an external autofill against another existing table within OnBase and I can sort it.
select distinct ks529, ks531, ks530, ks532
from hsi.keysetdata187
where ks529 = '@primary'
order by ks532 desc
09-24-2013 11:18 AM
Hello Cory,
Are you referring to the ability to sort items returned in an External Keyword Data Set? If so you'll need the SQL "Order By" keyword to sort the results, for example:
Select EmployeeNameFrom EmployeesWhere Department Like 'SALES'Order By EmployeeName asc
09-24-2013 06:19 PM
Thank you so much LB............ works like a charm. I love the OnBase Community
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.