Skip to main content
Solved

Variables in prefilter


Forum|alt.badge.img+1

Hi,

i am trying to make a process-flow that contains a variable to use in a prefilter. I can't find anything in the docs or on the community about this.

Is this possible to do? And if not, what is an other option i can try?

Best answer by Freddy

Dylan.hagmolen wrote:

Hi,

i am trying to make a process-flow that contains a variable to use in a prefilter. I can't find anything in the docs or on the community about this.

Is this possible to do? And if not, what is an other option i can try?

You can create a table with user_ID, timestamp and ‘variable’ and make a query pre-filter that uses the table to steer the results..  in the flow you can set the variable. 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Renée Evertzen
Moderator
Forum|alt.badge.img+3

Hey Dylan,

Unfortunately this is not possible. A prefilter is not designed to be modified or influenced by a parameter value. It is a predefined filter, which means that the conditions it filters on are determined in the application's model and read by the GUI.

The only possible thing you can modify by using a process flow is whether a prefilter should be turned on or off in a certain situation or based on a specific process flow parameter value. This can be done by using the Change prefilters process action type.

If you want to apply a regular filter using the parameter value, it is possible to use the Change filters process action type instead. This allows you to filter column A based on parameter A value, column B based on parameter B value, etc. etc.

Hopefully this answers your question and helps you think of a different solution for what you’re trying to achieve 😃

Kind regards,

Renée


Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • 511 replies
  • Answer
  • May 31, 2023
Dylan.hagmolen wrote:

Hi,

i am trying to make a process-flow that contains a variable to use in a prefilter. I can't find anything in the docs or on the community about this.

Is this possible to do? And if not, what is an other option i can try?

You can create a table with user_ID, timestamp and ‘variable’ and make a query pre-filter that uses the table to steer the results..  in the flow you can set the variable. 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings