Hi, I am wondering if anyone knows how to add the constituent notes to the list of queriable items (criteria) in List Manager? I was able to add it to the dropdown menu as an available option in List Criteria, but when I run List Manager I get the error: "Syntax Error in Query: Invalid object name 'vs_cust_notes.' (List Sql)
Based on the error I'm assuming I'm using the wrong identifier in the table to point to a constituent's notes (I don't know anything about SQL, unfortunately). Does anyone know what I should use or what might be wrong? Has anyone tried to do this too?
I believe the object should be 'vxs_cust_notes'. This should get rid of your error but using 'vs_elements_notes' may be better as it has note type as well as the actual notes.
Thanks Thomas! I must be doing something wrong, because in the TR_Query_Element table, in the "Deprecated From" column I tried the vxs_cust_notes and vs_elements_notes text you mentioned and when I run the query it still says "Invalid object name 'vs_cust_notes' ". Am I missing a table somewhere or forgetting something? It sounds like it's not pulling data from where I think it's pulling data...
The deprecated from columns are no longer used. The Group Id column references a different system table which is where the object is defined.
You'll need to make the update in TR_QUERY_ELEMENT_GROUP either by modifying the existing entry or adding a new row.