01-04-2018 07:32 AM
I've recently created a custom SQL query and am running into issues with getting multiple keyword types to show as display columns. In my select statement I was thinking I could use kt1.keyvaluechar, kt2.keyvaluechar etc....
I can use the first keyvaluechar but when I add the second I get an error saying "There is already a display column with the same id"
I'm assuming this can be done so I've got to be missing something.
Here's my select statement
select i.itemnum, bt.keyvaluechar, dt.itemtypename, i.datestored, ct.keyvaluechar
01-04-2018 07:58 AM
You'll want to Alias the keywords so they display. Basically its trying to display 2 columns as "Keyvaluechar" the prefix is only telling what table it's calling on. Here's an example I'm working on. Aliasing the keywords should solve your problem.
select distinct itemdata.itemnum, itemdata.itemdate,itemtypename,
RTrim(keyitem***.keyvaluechar) as ____ ,
RTrim(keyitem***.keyvaluechar) as ____ ,
~Jason
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.