List Criteria: Attributes without value selection

Trying to create a list criteria that pulls on an attribute agnostic of attribute value. I want to be able to pull everyone with an attribute regardless of value, in part, because selecting all values causes errors, but I'd also like to be able to select multiple attributes at once (use case, constituents with the marketing partner community partner attribute, regardless of specific value).

I made an entry in T_KEYWORD that makes sense to me, but the resulting SQL pulls like this:

SELECT DISTINCT a.customer_no
FROM V_CUSTOMER_WITH_PRIMARY_GROUP AS a WITH (NOLOCK)
WHERE a.inactive = 1
AND EXISTS (SELECT *
FROM TX_CUST_KEYWORD WITH (NOLOCK)
WHERE TX_CUST_KEYWORD.customer_no IN (SELECT customer_no
FROM V_CUSTOMER_WITH_PRIMARY_GROUP
WHERE customer_no = a.customer_no)
AND TX_CUST_KEYWORD.keyword_no IN ('775', '792')
AND TX_CUST_KEYWORD.keyword_no = 798)

In which 798 is the ID of the criteria I created, which of course doesn't exist in TX_CUST_KEYWORD. I can't sort out why this last line is being added. 

Keyword No: 798
Description: Attribute Group
Data Type: String (although number made more sense to me, but neither seems to matter here)
Detail Tbl: TX_CUST_KEYWORD
Detail Col: !.keyword_no
Ref Tbl: T_KEYWORD
Ref Idcol: keyword_no
ref Descol: description
Ref Where: use_for_list = 'K'
Ref Sort: description
Category: Attributes
Use For List: List Only
Multiple Values: Y
etc

  • Hello Chaz! This is Kelsey with Tessitura Network Support. We’re happy to assist you with this. I’ve created a Support ticket where we’ll work with you to find a resolution to this. We’ll also relay our findings from that ticket in this forum post, but if you have any other questions or concerns in the meanwhile please let us know.