Custom Query SQL

[ANA_MARIA_SOLAN]

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.

[AdamShaneHyland · Accepted solution]

Hi @ANA MARIA SOLANO PACHON ,

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.