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.
We are aiming to include this change in DataMiner 10.6.4, which is scheduled for release on March 20th.
I can confirm this will be part of 10.6.4. Small sidenote though: the GQI DxM will be required for this.
Thank you Wout, do you have a timeframe when this will be available for us. We need to prioritize it and is worth know how long is the wait. I appreciate it.