if this is a question then answer is yes or fetch arsystem report and then filter it out.
What would be the advance search query
1 of 1 people found this helpful
In the advanced search, you can look on the right, there should be a fields dropdown. If the field is on the view but hidden you’ll see the name of the field if you have permissions, if the field is not on the view you’ll need to have the field ID to use it in an advanced query, again you must have permissions.
the query will be like:
’field_your_querying’ LIKE “my data%” (or whatever operator or search you need)
if if you need further assistance please let us know what the field is and what data you are looking for in plain English and we can help you format the query.
What Marie Johnson has suggested is the only way you can search records based on the field ID which is out of view. One other option is you write an api program and fetch your records based on the field value qualification.