Skip to main content
Declined

Set prefilter query to NULL when switching to 'prefilter columns'

Related products:Software Factory
Jeroen van den Belt
Leroy Witteveen
Mark Jongeling
Arie V
Rafal Zaluski
+11
  • Jeroen van den Belt
    Jeroen van den Belt
  • Leroy Witteveen
    Leroy Witteveen
  • Mark Jongeling
    Mark Jongeling
  • Arie V
    Arie V
  • Rafal Zaluski
    Rafal Zaluski
  • mperrott
    mperrott
  • antonn_a
  • dcharalampous
  • phpetrou
  • FrankS
    FrankS
  • Shawn Adrian Diño
  • WarrenM
  • Jason Philip A Mortera
  • Spyros.Neofytou
  • Maarten
  • Xavier de Bondt

Kevin Rosink

When validating prefilters that are changed from query to prefilters column it returns errors because the prefilter contains a query and a ‘prefilter column’.

My idea is a simple solution by setting the query to NULL when choosing ‘prefilter columns’

Did this topic help you find an answer to your question?

2 replies

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

​Hi @Kevin Rosink,

Implementing this idea would require the use of triggers (since the query and columns are not in the same table, so it cannot be done with default functionality). For technical reasons within our platform, this is not possible. Using triggers would have a negative impact on our branching and merging mechanism; you don't want these kind of triggers to be activated during a merge.

For this reason, we do not use triggers for these kind of situations but provide validations to notify the developer:

 


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
NewDeclined

Reply


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