I am trying to write eql that uses a Fixed value list as a paramerter.
For One parameter I want to list only the Active values in the list. "Active Treatment Plant"
For another parameter, I want to list only the Inactive values in the list. "Inactive Treatment Plant"
This is what is supplied when I click on Get Value from a Search.
START WITH Document SELECT Attributes["Global", "TREATMENT PLANT"].Value col1, Attributes["Global", "TREATMENT PLANT"].Value col2 WHERE Attributes["Global", "TREATMENT PLANT"].Value LIKE @StringValue ORDER BY Attributes["Global", "TREATMENT PLANT"].Value
Thanks for any support in advance.
To get the active lookup entries for TREATMENT PLANT please replace the eQL for that field with the following:
START WITH AttributeValueList
SELECT
Value col1,
Value col2
WHERE
AttributeDef.Name = 'TREATMENT PLANT'
AND Value LIKE @StringValue
AND IsObsolete <> 'Y'
Address: Bentley | 10052 Mesa Ridge Court Suite100 | San Diego | CA | 92121 | USA