Hi everyone!
I'm currently attempting to set up a dynamic list to capture constituents flagged inactive, but the relevant criteria is not cooperating as I'd hoped! All records have been inactivated with the same reason: False Account Info.
The list is incredibly simple, only working off these two criteria:
- Inactive Flag is/has Inactive
- Inactive Reason is/has False Account Info
but the list is not pulling any of the constituent records that are marked as such. I've confirmed that inactive records can still be pulled into lists using unrelated criteria so there is no global setting keeping them out as a rule, but otherwise I'm stumped on what could be interfering.
Any and all suggestions very welcome! Thanks,
Nick
Hi Nick,
There is a T_DEFAULTS setting called "Inactive in Lists" that takes a Yes or No (defaults to No). Changes to this setting do not impact existing lists until someone edits the list to view the Criteria and clicks Save and then generates the list.
On your List Criteria, hit Show Query and see if at the end of the code is says WHERE a.inactive = 1 (suppress inactives), or if it says WHERE 1 = 1 (include inactives). Then hit Graphical Edit to return to the usual Criteria view of your list.
Ah, thank you Chris! Show Query is displaying as you've described for suppressed inactives--however, our T_DEFAULTS System Table does not seem to have an Inactive in Lists field. I'll speak to our Operations staff members to follow up on this, though.
Thanks for your help, I appreciate it!