CONTACT USBack to MinistryPlatform Site
Your Knowledge Base has moved to the new Help Center.  Check out the release notes for details. And don't forget to update your bookmarks and in-house documentation before May 28.

Series Tables

 

The following tables store Series. The tables cannot be accessed directly in the platform, but you can use them in your Views.

Series records use a soft join because they can refer to multiple tables. The Table_Name column will match the name of the table and Record_ID will match the primary key for the sequence. For example, the following sql would return the sequence for the Event 1783:

SELECT SR.Sequence_ID 
FROM dp_Sequence_Records SR 
WHERE SR.Table_Name = 'Events' AND SR.Record_ID = 1783

More Information

See the Events In Series View Example for an example of this in action.