07-25-2024 12:57 PM
Hi,
I have a question regarding custom SQL queries.
Currently, I have the following query:
From Clause:
hsi.itemdata, hsi.keyitem243
Where Clause:
hsi.itemdata.itemnum=hsi.keyitem243.itemnum and hsi.keyitem243.keyvaluechar like '1058'
I need to retrieve all documents where hsi.keyitem243.keyvaluechar
matches a value provided by the user during the search. In other words, I need to replace the hardcoded value '1058' with a user-provided value and have something like this:
I tried using a parameter like @nNecesidad
instead of '1058', but it didn't work. Is there a way to use a placeholder or keyword for dynamic values in custom SQL queries?
Thank you for your assistance.
07-25-2024 01:15 PM
Hi
SQL Custom Queries do not support parameters. This is by design and functioning to spec. If you feel there is a need for this functionality, I would recommend you submit a Feedback request.
Best wishes.
07-25-2024 01:15 PM
Hi
SQL Custom Queries do not support parameters. This is by design and functioning to spec. If you feel there is a need for this functionality, I would recommend you submit a Feedback request.
Best wishes.
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.