Using display values in runtime IQA filters

By default, runtime IQA filters that use a multi-select property display the stored code rather than the display value. For example, if a contact has selected Monday and Wednesday for their availability, that is stored as 0,2. To show display values in a runtime filter dropdown, the business object property must be configured on the Properties tab of the Business Object Designer.

Do the following to configure a business object property so that runtime IQA filters show display values instead of stored codes when using the DistinctUserDefinedMultiSelectProperties business object.

Setting up the business object property

Do the following:

1. Go to RiSE > Business Object Designer.

2. Create a new business object or copy and paste the DayOfTheWeekRef business object. See Working with Business Object Designer.

3. Create a new business object or copy and paste the DayOfTheWeekRef business object. See Working with Business Object Designer.

4. On the Properties tab, select the property to configure. In this case, it is DayOfTheWeekCode.

   

5. Click the Values tab.

6. Select Value list.

7. Enter the Data Value and Display Value for each value that will be available in the filter dropdown.

8. Click Save, then Publish.

Using the configured property in a runtime IQA filter

Once the business object property has a value list defined, it can be used as a runtime filter in an IQA query. When the query is run, the filter displays a dropdown of display values rather than stored codes.

Do the following:

1. Go to RiSE > Intelligent Query Architect > New > Query.

2. Give the query a Name, such as Availability.

3. (Sources tab) Add the following sources:

   • DistinctUserDefinedSelectProperties

   • NetContactData

   • DayOfTheWeek
     Add the following joins:

   • DistinctUserDefinedMultiSelectProperties.Uniform Key = NetContactData.Id

   • DistinctUserDefinedMultiSelectProperties.Property Value = DayOfTheWeek.Day Of The Week Code

     

4. (Filters tab) Add the following filters:

   • [DistinctUserDefinedMultiSelectProperties] Data Source Name
     • Value - Day
     • In Search? - No
   • [DistinctUserDefinedMultiSelectProperties] Property Name
     • Value - Day of the Week
     • In Search? - No
   • [DayOfTheWeek] Day Of The Week Code

     • In Search? - Optional

     • Search Label - Day of the Week

       

5. (Display tab) Add the following properties:

   • [NetContactData] Full Name
   • [DayOfTheWeek] Day Name
   • [DistinctUserDefinedMultiSelectProperties] Data Source Name
   • [DistinctUserDefinedMultiSelectProperties] Property Name
   • [DistinctUserDefinedMultiSelectProperties] Property Value

6. Click Run. A drop-down listing the weekdays is displayed.