You can query netFORUM Enterprise to locate subscriber preferences (the subscriber information written back by Higher Logic Thrive Marketing Professional. This information, accessed via IPM, is stored in the MK_Mailing_list table in netFORUM Enterprise. To perform queries on that table, you must first link to it.

Steps

1. Navigate to Modules > CRM > Individuals > Find Individual.
2. Enter any necessary criteria to retrieve a list of individuals.
3. Click the Arrow Icon to access an individual record. Scroll down the page and click the More tab. Select Correspondence from the list.

4. Select Mailing Lists. Click the Edit icon on the right side of the page.
5. Go to Mailing Lists – on right hand side > click edit.
6. Copy and Save the listed SQL (to a notepad file, etc.). This SQL contains the join information that you need later (e.g., mld_mls_key = mls_key).

7. Click Cancel to close the window.
8. Click Query Individual on the left side of the interface.
9. Click the Load an Existing Query menu and select any query that produces more than one result.
10. Click Run Query at the bottom of the results screen.
11. Click Edit table list setup.
12. Click the Plus Icon (+) in the from Tables area to expand the section.
13. Enter the following data:

1. From Table Name - mk_mailing_list
2. From Order - Any Number
3. Join Type - Left Join
4. Join Expression - The join information copied/saved from the above SQL (mld_mls_key = mls_key)
5. From Table Alias - (Leave Blank)

14. Click Save and close the resulting window.

Set the Query and Link to the Mailing List Table

Now that everything has been prepared, you can set up the necessary query and link to the mailing list table.

1. Navigate to Modules > CRM > Individuals > Query Individual.
2. In the Query Conditions tab, set the conditions needed for your report.

Below is a sample report to show how conditions are retrieved.

Add the following data to Column to Query:

• Mailing List Detail (entry one):
• Set the Start Date.
• Set Greater Than or Equal to.
• Click Ask at Run-Time?.
• Click Add to Query.
• Mailing List Detail (entry two):
• Enter the End Date.
• Set Less than or Equal to.
• Click Ask at Run-Time?.
• Click Add to Query.

Click the Query Columns tab and add the following columns:

• Individual: First Name
• Individual: Last Name
• Mailing List: Mailing List Name
• Mailing List: Mailing List Description
• Mailing List: Mailing List Type Code

Click Run Query.

In the results, click the Individual record, and then click Comm. Preferences. The mailing lists display here.