How to get latest modified support cases
I found a problem how to filter SupportCases by its lastModifiedDateTime attribute. It’s exposed by SOAP or RESTlet schemas, but it can not be directly queried on SupportCase table by SuiteQL query.
Does any one would have a prompt how to build such SuiteQL query to get SupportCases modified since datetime param? What table I should join and query on it ?
Thanks in advance for help with this issue.