If I add a regex formula to the query, it does the filtering as usual as you can see from this image:
But when I use a table Variable to use on a dropdown, it automatically adds backslash characters (or scape characters) to the string and results in the system not filtering:
anymore. Any ideas of what is happening here? were these variables left behind on a new upgrade change?
is there a way to disable this?
please help! thank you!
Versions
10.6.1 (CU0) - WEB
10.5.12.0-16623 - Server
10.6.2547.2004 - API
10.6.2547.3044 - APP
1.0.100.22910 - GQI
Hi Miguel,
You have found a limitation in the current way values are linked to a regex filter in a query. At the moment, the filter node escapes the value when it is linked to other data. In your case this would be the link to the variable. This was done because of a technical limitation in GQI that is now resolved.
We are currently working on changing this so that regex filters can be easily linked to other data in your LCA, without escaping the values. We will let you know once a fix has been implemented.