Sort External Autofill Keywords

[Cory_McFarlane]

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

[Mike_Saville]

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

[Legborsi_Bete]

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

[Cory_McFarlane]

Thank you so much LB............ works like a charm. I love the OnBase Community