Allowing 'contains' as an operator for table fields in a query

We have thousands of courses / degrees listed on RE, as students can combine subjects. At the moment if I want to run a query on students that have studied Law, or any subject 'with Law' I have to go through and manually select them all using the operator 'one of' - which considering you are unable to expand the operator box - takes a great deal of time to go through. I would like to be able to use contains as the operator so I can create a query of anyone who studied a degree that contains Law. Saving lots of time! The best work around I've been given by support is exporting all the education fields, and then filtering in excel to exclude all the other courses...not ideal as I feel there is more room for human error.

  • Guest
  • Feb 15 2018
  • Attach files