Customer Manager Views

You can view the queries that SBCM business rules are based on. Business rules queries are stored in the Import Wizard table tblBusinessRules, in the columns BRPass1SQLString and BRPass2SQLString.

The Import Wizard runs the query in BRPass1SQLString and creates a temporary table for the results. (This query cannot be a GROUP BY query because of the manner in which the Import Wizard modifies this query for implementing filters.) Next, it runs the query in BRPass2SQLString by using the results to create another temporary table for display purposes. There are no structural limits on this query. Some columns are hidden in the final result set. These columns include KeyField (the value of the key field in tblBusinessRules in the file Sbcm.mdb) and SelectedContactIndex (used for selecting contacts during automation).