03-22-2016 03:01 PM
I'm trying to create a custom query that will bring up documents where the date in a keyword is on or after 10/1/2015. The caveat is that the keyword type for whatever reason was setup as alpha instead of date so I need to convert it to date in the query.
I can run this in SQL and get the results I want but I haven't been able to get the custom query to work correctly in OnBase (note I am not using aliases in the custom query).
select id.itemnum [Document ID], convert(varchar,hd.keyvaluechar,101) [Hire Date]
from hsi.itemdata id
inner join hsi.keyxitem112 k112
on k112.itemnum = id.itemnum
inner join hsi.keytable112 hd
on hd.keywordnum = k112.keywordnum
where id.itemtypenum = '750' and hd.keyvaluechar > '2015-10-01'
03-22-2016 03:06 PM
It looks like you are most likely hitting the character limit in the from field. There is more information here and a workaround as well: www.onbase.com/.../31546
Josh's answer is the best workaround in my opinion.
Hope that helps.
03-22-2016 03:06 PM
It looks like you are most likely hitting the character limit in the from field. There is more information here and a workaround as well: www.onbase.com/.../31546
Josh's answer is the best workaround in my opinion.
Hope that helps.
03-23-2016 06:57 AM
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.