You may encounter an issue where SuiteQL script returns duplicate data in your Popdock list. This occurs because an Order By clause isn’t using a unique key and NetSuite’s API limits each response to 1,000 records. This issue occurs when follow-up requests are treated as new, prompting NetSuite to re-execute the original query. This can cause the same record to appear multiple times, often in different positions.
SuiteQL Script Returns Duplicate Data
Here is an example of a script that may return duplicate data:
select distinct
uniquekey
, id
, class
, department
, documentnumber
, entity
, linelastmodifieddate
, linesequencenumber
, location
, memo
, netamount
, subsidiary
, transaction
from transactionline
where linelastmodifieddate >= (SYSDATE - 7)
order by linelastmodifieddate
Duplicate Data Resolution
To resolve this issue, add an ORDER BY clause that references a unique field in your query. This ensures record positioning across result sets and prevents duplicates.
The following example includes a unique field in the ORDER BY clause, which helps prevent duplicate records across result sets.
select distinct
uniquekey
, id
, class
, department
, documentnumber
, entity
, linelastmodifieddate
, linesequencenumber
, location
, memo
, netamount
, subsidiary
, transaction
from transactionline
where linelastmodifieddate >= (SYSDATE - 7)
order by uniquekey ASC
Having trouble with your SuiteQL script? Contact us here or email support at support@eonesolutions.com.
