I have a requirement to pull out of CRM all BPs who have a particular marketing attribute assigned to them. I am hoping to use segment builder to do this, however as the value of the marketing attribute is not a set value, it is a free text field that has data entered into it, I am finding it difficult to building the correct attribute list - tx CRMD_MKTDS. The ony filter options available are equal to or contains pattern. I essentially want to pull out all BPs who have this attribute assigned regardless of what the actual value of the attribute is.
Is there another way I can pull this information out? My next step is to write a query in SQ01, but I am also not sure of all the tables I need to get the linking of the marketing attributes to connect to give me the BP IDs of those who have been assigned it.
Any help would be gratefully received!