'Does not contain' filter

  • 9 September 2021
  • 2 replies
  • 94 views

Hi,

 

Anyone has a workaround for the known issue:

  • There is no 'Does not contain' operator available on the View runtime filter.

 

Thanks,

 

Sreeja


2 replies

Have many "Not Equal to" filters (this may not work depending on what you are trying to filter out)

Hi,


 


Well there are multiple workaround for this and it will depend on how many conditions do you have


 


Like for example if you want to filter out based on status and you have in total 5 status, then you can use "Not equals to" as suggested previously but if the number of conditions are more then this will not be the perfect solution.


 


What I always recommend is, if you have some complex filter logic then its better to write a stored procedure (if you are using SQL) to have all the different kind of data manipulation and filtration which will also be good for the performance.


 


Thanks

Reply