Flexible flter when laoding app

Scriptcase 9
#1

Hi,

I’m filtering my app in the SQL part with

PROGRESS<100 AND Responsibility = ‘[usr_group]’

This working just fine. The {user_group} is passed on correctly.

Is there a way to do this with wildcards when the {user_group} is empty? So the filtering on the field PROGRESS is the only one left?

Regards.

Erwin

#2

Something like

PROGRESS < 100 AND Responsibility = (IF(’[usr_group]’ IS NULL or ‘[usr_group]’ = ‘’, Responsibility, ‘[usr_group’]))

should do the work

#3

hi,
I do so

SELECT * WHERE PROGRESS<100 [for_where_dynamic]

and add in this variable what you need or else you leave it blank.