Solved

IFS FSM Lobby Element Dynamically Changing Results

  • 21 June 2021
  • 3 replies
  • 119 views

Userlevel 2
Badge +5

Lobby Element changing values dynamically based on Filter selection.

 

For Example, we have a lobby element created with list of open Work Orders (requests)

By Default it should should all requests, however as soon as you select country, the same lobby element should filter the values based on Country selected and after state is selected, it should show the workorders associated to the selected state.

 

We can definitely create three different lobby elements with First one without condition, second one as request.user_def1 = “$COUNTRY$” (Just as an example)

And third one as

request.user_def1 = “$COUNTRY$”

request.user_def2 = “$STATE_PROV$”

 

But is it possible that the 1lobby element behaves in three different ways.

I tried with Just the third one and unless you select the values, it will show Zero results (and expectation is it should show the entire list)

icon

Best answer by Kalana Surendra 22 June 2021, 00:19

View original

This topic has been closed for comments

3 replies

Userlevel 4
Badge +9

Hi @RAQVVAIDYA ,

Did you try defining a SQL data source and define a condition statement according to you requirement. 

A condition containing  “OR” operator might do the job.

request.user_def1 = “$COUNTRY$” OR request.user_def2 = “$STATE_PROV$”

Regards,

Kalana.

Userlevel 4
Badge +9

If you need to populate the complete list of data when the filters are not defined, try using acase statement in the condition.

Userlevel 2
Badge +5

@Kalana Surendra : Thank you for the reply. Is there anyway you can give me an example of case statement on Condition in Datasource designer please.