admin管理员组

文章数量:1402791

I am trying to get access tokens with below condisions,

  1. inactive is false,
  2. token creation date is before 2800 days using suiteQL.

I tried writiing this query but it doesn't work. Please advice thank you!

            // Calculate the date 2800 days ago
            let today = new Date();
            today.setDate(today.getDate() - 2800);
            const pastDate = today.toISOString().split('T')[0]; // "YYYY-MM-DD"
            let formattedDate = format.parse({value:pastDate, type: format.Type.DATE})

 const sqlStr = `SELECT
                OAuthToken.tba_token_name AS tokenName,
                OAuthToken.dCreated AS createdDate
            FROM
                OAuthToken
                WHERE OAuthToken.bInactive = 'F'
                AND CAST(OAuthToken.dCreated AS DATE) < ?
           
    
            const tokens = query.runSuiteQL({
                query: sqlStr,
                params: [formattedDate]
            }).asMappedResults();

本文标签： sqlNetsuite SuiteQL query to get access token created before 2800 days agoStack Overflow

版权声明：本文标题：sql - Netsuite SuiteQL query to get access token created before 2800 days ago - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744319216a2600413.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。