eQL Limit Fixed Value attributes

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.

Parents
  • 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 Suite
    100 | San Diego | CA | 92121 | USA



Reply
  • 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 Suite
    100 | San Diego | CA | 92121 | USA



Children
No Data