Inactive Records Not Excluded from Saved Search and Report Results
Published on
July 31, 2023 at 10:09:52 AM PDT July 31, 2023 at 10:09:52 AM PDTst, July 31, 2023 at 10:09:52 AM PDT
Scenario
User has marked several Customer records as Inactive. When creating Saved Searches and Reports, the user wants all these Inactive Customers and their related records automatically excluded from the Results.
Solution
This can only be achieved by explicitly adding theInactive = Falsecriterion on the Report or Saved Search. However, these inactive records do not show up when viewing the List page (e.g.Lists > Relationships > Customers) unless theShow Inactivesfilter is enabled.
Go toLists > Relationships > Customers
Show Inactives:EnterCheckmark
Similarly, inactive records do not show up on Quick Searches or Global Searches unless the user manually enables the preference to include them.
Go toHome > Set Preferences
ClickAnalytics
Include Inactives in Global & Quick Search:EnterCheckmark
ClickSave