Hi all.
I am trying to run an installed query, but I am getting empty results in return, as one of the parameters I use is a STRING which is compared in a WHERE clause for a SELECT statement. When printing the STRING parameter out at the end of the query, the space in between is converted to a “+” symbol, presumably when the API is called. What are the current workarounds for this?
Thanks in advance.
Update: The normal same parameters passed into the query from GraphStudio work, but when passing through from pyTG it does not work.
Query with parameters in GraphStudio.
Result through pyTG.
Result in GraphStudio.