How to Filter an Attribute Fixed Values in eQL


       
       
  Product(s): Assetwise ALIM  
  Version(s): ALIM 16,7.60 and higher  
  Area:  eQL Reports  
  Subarea:  N/A  
  Original Author: Bentley Technical Support Group  
       

 

 

 

 

 

 

 

 

 

Problem

Some Fixed value attributes might be marked as Obsolete/Inactive and user wants them to be excluded from being selected in eQL Search/Report.

Solution

Cause for this issue is that Using Default eQL for search lookup value list does not filter inactive values.

The following example is for a Fixed Value attribute named "DIVISION". You may use the same steps below and replace "DIVISION" with the attribute name you chose. Yo can also add additional filtering as allowed by valid eQL WHERE clauses.

 

 1. In the Define Parameters step, under the Available Values Tab for the desired attribute, select the option "Get Value from a Search":

 

 

2.Replace the default search shown in eQL editor section with the following. You can replace "DIVISION" with your desired attribute:

START WITH Class

SELECT

   Attributes.AttributeDef.AttributeValueList.Value col1,

   Attributes.AttributeDef.AttributeValueList.Value col2

WHERE

   Attributes.AttributeDef.Name = 'DIVISION'

   AND Attributes.AttributeDef.AttributeValueList.IsObsolete = 'N'

 

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!