Applies To
	Product(s):	eB Core; eB Server;eQL;Reports
	Version(s):	ALIM 16,7.60 and higher
	Environment:	N/A
	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

 

Cause

Using Default eQL for search lookup value list does not filter inactive values

Solution

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!