Creating a custom query to search for committee members

If you want to review members in a committee from a single page, rather than clicking individual committees from Community >Committees, you can create a custom committee member search. This involves creating a query, adding the query to a content record, and then adding that content record to the Committee sitemap navigation.

Do the following to create a search by committee option:

Creating the query

  1. Go to RiSE > Intelligent Query Architect.
  2. Choose a folder for the query.
  3. Click New > Query and name the query Search by Committee.
  4. (Sources tab) Add the following sources:
    • CsCommitteeMember
    • CsCommitteeCode
  5. Create the following join between the sources: CsCommitteeMember.Committee Product Code = CsCommitteeCode.Product Code.

  6. (Filters tab) Add the following filter:
    • Where CsCommitteeMember.Committee Name equals any value.
    • Set the In Search? drop-down to Required.

  7. (Display tab) Add display columns, such as Email, Full Name, and Committee Name.
  8. Save the query, then click Run to view the results.

Adding the query to the content

  1. Go to RiSE > Page Builder > Manager content.
  2. Go to the Shared Content folder and click New > Website Content.
  3. Enter a page Title, such as Search by Committee.
  4. Select Add content, then choose the Utility folder.
  5. Double-click the Query Menu content item.

  6. From the Source query or folder field, select the query created in the steps above.

  7. Click OK, then click Save & Publish.

Adding the content to the sitemap

  1. Go to RiSE > Site Builder > Manage sitemaps.
  2. Choose the Staff site from the drop-down.
  3. Go to Community > Committees.

  4. Click New > Website Navigation Item.
  5. Enter a Navigation link text, such as Search by Committee.
  6. From the Content or URL to link to field, select the content record you created in the steps above.

  7. Click OK, then Save.
  8. Click Publish.

Go to the new navigation item you just created and confirm the query is correctly displaying.