Home > Forum > Forms > Data table field with Dynamic filter

Data table field with Dynamic filter

0

06.07.2023

12:42

Hello all,

Is there any way to use the same data table field but having different filters in each step?

For example, on the start, I want the info to show request's open for the requester
In the approval step, I want to check the request's for the project code belonging to the approver

Is there any way to do this without having three different fields to achieve this?
Thank you!

06.07.2023

13:51

Hi Andreia,

you could do something like this

where
((StartStepID = CURRENTSTEPID) and (Filter1))
or
((SecondStepId = CURRENTSTEPID) and (Filter2))

This way only the filter for the current step would be applied.

Best regards,
Daniel

Solution (0)

Helpful (0)

Wrong answer (0)

06.07.2023

15:53

In reply to: Daniel Krüger (Cosmo Consult)

But using the BPS view as the source, if I filter by the step, I only see the request that is in the start step for the requester chosen.

Solution (0)

Helpful (0)

Wrong answer (0)

06.07.2023

21:52

In reply to: Andreia Correia

But using the BPS view as the source, if I filter by the step, I only see the request that is in the start step for the requester chosen.

Hi Andreia,

first of all, why are you entering ids? This will break as soon as you transport the workflow.

Take a look at the screenshot what I had in mind. You can either do it with the normal filter or in advanced mode. In either case this would be the generated filter in my case.
Depending on the current step, either the first or the second condition will be used. The example with 1=1 is just a simplification you could enter actual filter here.

((''1219'' = ''1219'') AND (1 = 1))
OR ((''1220'' = ''1219'') AND (2 = 2)))

Best regards,
Daniel

Solution (1)

Helpful (0)

Wrong answer (0)

10.07.2023

16:59

In reply to: Daniel Krüger (Cosmo Consult)

It worked!
Thank you for your kind help :)

Solution (0)

Helpful (0)

Wrong answer (0)