Advanced Search: When searching requests, filter by Activity/Requirement custom fields

Custom fields from most tables are available for filtering in the Request Advanced Search. However, Activities_Ext and Requirements_Ext fields are not accessible. Also, the SQL parser does not allow you to reference these fields in the query (eg, Requirements_Ext.REQCFTestField). This makes some Request queries impossible. For example, we need to get a list of all Requests where the grantee has chosen "Yes" in a Requirement custom field placed in an on-line Requirement form.

  • Justin Finighan
  • Jul 9 2021
  • Reviewed: Voting Open
  • Attach files