How to get latest modified support cases

Hi,

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.

Kind regards,

Lukas

Rookie Asked on March 23, 2021 in SuiteApps.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor