How do I create a new EpiFilter in the Kinetic form using Application Studio the same way it is done below in Classic? I would like to add an additional filter to a standard drop down field selection list to only filter by condition.
I was going to add the filter to the PO Detail Part Rev but can’t find the selection to add the filters for these standard fields in the Application Studio Properties you provided.
Your original screenshot was of a combo box.
Now you’re showing a text field with a search option.
Are you trying to filter the search…?
The Part Rev is a combo box with a drop down. I’m trying to filter the Part Rev to only approved in PO Details.
I don’t believe you can filter those multi-part combos.
It would probably be easier to add a BPM to PartRevSearch.GetList and add the filter to the whereClause there.
Which widget do I use to set the filter to the whereClause in the workflow designer?
None.
I said BPM.
You would use the Set Argument/Variable widget, and set the WhereClause argument.
Remember that you probably should add to the existing WhereClause argument, not replace it completely. (Depending on what you’re trying to do)
1 Like
I tried adding the expression below but getting the error when setting the Arguement/Variable. I’ve tried setting it to True, 1, Yes and all of them are still getting an error.
You need to set the whereClause variable to be
whereClause += " AND Approved = true"
2 Likes
Thanks, that worked.