Reference variable for Catalog Item does not show all fields when expanding Content Item

[Winnie P]

Hello there,
We have a Reference variable that is using the sc_cat_item table - this variable will show the list of Catalogue Items. However, I also need to add a condition to show 'Content Items' list using the same variable. From the Reference qual condition, I can expand 'Content Item'  (pic 1), but it is not showing all Content Item fields, I can only see a few options (pic 2) but I would like to add Active and Catalog fields? Am I missing a configuration? Is this possible to do?  If so, what is the best/easiest method please? Thank you.

pic 1

pic 2

[Allen Andreas · Accepted solution]

Hi,

Those content items show on the sc_cat_item table, so you can filter for class = content item and then simply use the normal fields like: active = true, etc. So basically, you're still on the sc_cat_item table all throughout the filtering. No dot-walking anywhere else. The content item table is an extension of the catalog item table...so with you filtering at the parent level (sc_cat_item), you see all records there.

[Winnie P]

Perfect, good to know. I have my conditions working now for Content Item. Appreciate your reply Allen. Regards Winnie.