eQL Limit Fixed Value attributes

Question

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.

Roberto Garcia · Answer

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'