Skip to main content

Created a data source not want to add filter into the data source but issue is when i am adding filter:

user_def24 = IIF(ISNULL('$user_def24$', '') = '', user_def24, '$user_def24$')

then it`s not taking the data from table where user_def24 is null into consideration.

When i am adding filter:

(user_def24 = IIF(ISNULL('$user_def24$', '') = '', user_def24, '$user_def24$') or user_def24 is null)

then selecting one data from table it`s shows relevant data but with all rows which has user_def24 value null.

 

EEXPECTED BEHAVIOUR

 

When we are using filter then if a value is selected then data shows should be of that value and if nothing is selected on the parameter all values should be shown into table including null values.

 

 

Hi @sujoin, 

 

I hope this answers your question!

 

https://community.ifs.com/ifs-field-service-management-fsm-employees-partners-only-103/fsm-lobby-input-parameters-3351

Hi @Danuja,

 

could you please share the post of that link here?  (As that post is only for IFS employees/partners. )

 

Thank you and best regards,

~Juni

Reply


Terms & ConditionsCookie settings