I cannot query on the relation only constituency

You may want to see which constituent records have the relation only constituency, but when you query on the constituency there are no results in your query. You do see that you are able to query on other constituencies.
This field is not available for query. If you would like a list of Constituent names and Lookup Id's that have the Relation Only Constituency, please chat with support and reference this article. 

Steps to Duplicate

  1. From Analysis > Information Library > Add an ad-hoc query, Choose the source view of Constituent
  2. In the middle select Constituent Record > move to include records where and set equal to the affected constitiuent
  3. On the left, select constiuency > In the middle select Name > Move to Results fields to display
  4. Preview results > See that the relation only constituency is not listed in the query


 Altru Arts & Cultural

Was this article helpful?