Returns a list of membership subcategories for a membership category.

View-Specific Information

Select

The driver uses the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following columns and operators.

• MembershipCategoryId supports the = operator.
• SubcategoryName supports the =, LIKE, CONTAINS operators.

For example:

	SELECT * FROM MembershipSubcategories WHERE MembershipCategoryId = '1'

	SELECT * FROM MembershipSubcategories WHERE MembershipCategoryId = '1' AND SubcategoryName LIKE '%Gold%'

	SELECT * FROM MembershipSubcategories WHERE MembershipCategoryId = '1' AND CONTAINS(SubcategoryName,'Gold');

The rest of the filter is executed client-side within the driver.

Columns

Name	Type	References	Description
Id [KEY]	String		The immutable system record ID of the membership subcategory.
MembershipCategoryId	Integer	MembershipCategories.Id	The immutable system record ID of the membership category associated with the subcategory.
Sequence	Integer		The placement of the subcategory in the order of subcategory table values.
SubcategoryName	String		The name of the membership subcategory.