I have symply query that get data from table Contact and Case ( lookup Contact). Result squery from Case is object with field CaseNumber and Subject(Like [{"CaseNumber":"00001000","Subject":"Starting generator after electrical failure"}].)
How I can refer to this field to filter the recording result? For example WHERE CaseNumber = '00001000' OR Subject LIKE '%generator%'
If I put this checking in (SELECT CaseNumber, Subject FROM Cases ) it only leave blank value in field Cases but don't filtred record as I need.