This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Shot in the dark here, but has anyone ever experienced `runSuiteQLPaged` returning duplicate records?  Changing the `pageSize`  causes the duplicate rows to go away, but this seems like a fragile solution without knowing the root cause.

```        SELECT
            txn.id as id,
        FROM transaction AS txn
        JOIN transactionline txn_line
        ON (txn_line.transaction = txn.id)
        JOIN transactionaccountingline as txn_acc_line
        ON (
          txn_acc_line.transactionline = txn_line.id
          and txn_acc_line.transaction = txn.id
          )
        JOIN account
        ON (txn_acc_line.account = account.id)
    WHERE
      txn.trandate &gt;= TO_DATE('2022-01-01', 'YYYY-MM-DD')
      and txn.trandate &lt;= TO_DATE('2024-05-01', 'YYYY-MM-DD')
      and account.accttype = 'CredCard'
      and MOD(txn.id, 2) = 0```
Here's the query that's returning duplicates for what it's worth

Try adding an `ORDER BY txn.id` and see if it helps.

Best practice is to paginate by the last result, e.g. if the last ID was 12345, you'd add `WHERE txn.id > 12345 ORDER BY txn.id` to get the next page.

we have seen duplicate bugs in standard N/search runPaged() and recently switched to using getRange() and paging manually to work around the problem.