79528615

Date: 2025-03-23 07:54:08
Score: 0.5
Natty:
Report link

Finally, this query worked to get tokens created 2800 days ago:

 const sqlStr = `SELECT *
                FROM OAuthToken
                WHERE OAuthToken.bInactive = 'F'
                AND OAuthToken.dCreated < CURRENT_DATE - 2800`;
                
              const tokens = query.runSuiteQL({
                query: sqlStr,
                }).asMappedResults();
                
Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Maira S