Skip to main content
  • EN

Hi Folks,

I have successfully done a Cross Join In one InlineQuerier where the contents of a field called Query_Filter - is the WHERE Statement I want to apply in another InlineQuerier. I can get the statement to work fine when I paste it in to the second querier - EG

Select * FROM "Detected"
WHERE (ChemCode ='7440-38-2' AND Concentration > 160 )

However when I Write SELECT * FROM "Detected" WHERE Query_Filter It doesnt work.

(Query_Filter just containing the text string above.)

Im missing something.

Any thoughts ?

Maybe try the following:

SELECT * FROM "Detected" WHERE @Value(Query_Filter)

Hi @pilgrimjake, I think your second query is equivalent to this one if the Query_Filter stores the text string "(ChemCode ='7440-38-2' AND Concentration > 160 )".

SELECT * FROM "Detected" WHERE '(ChemCode =''7440-38-2'' AND Concentration > 160 )'

A string literal won't be evaluated as an expression when the query is executing, so this query would not work as expected.

Also, the @Value function seems not to be available in a query for the InilineQuerier.

Probably you will have to think of another approach depending on the requirement.

 

Reply


Community Stats

30,186
Posts
114,578
Replies
37,853
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.