Single Select Pick Lists 'Like' Filter?

Jan 19, 2024 9:41PM

Summary:

Trying to correctly add a single select picklist filter specifying a 'like' filter (or equivalent), but I'm unable to successfully do so.

Content (please ensure you mask any confidential information):

I'm attempting to set picklist values based on a filter against two columns in my domain table - "FAMILY_ID" and "ATTRIBUTE_VAR_NAME".

My single select picklist has the following MongoDB query filter which does not work. I'm attempting to use regex per the MongoDB query specifications:

{$and:[{FAMILY_ID:{$regex:'/|modelFamilyID|,/'}},{ATTRIBUTE_VAR_NAME:"bodyMaterial"}]}

I want any data table row that contains the text "|modelFamilyID|," for FAMILY_ID and has an ATTRIBUTE_VAR_NAME equal to "bodyMaterial", where the modelFamilyID is a configuration attribute (example value would be "402,").

Single Select Pick Lists 'Like' Filter?

Howdy, Stranger!