Hi, cracking my head with a problem. Any idea why ...
# suiteql
s
Hi, cracking my head with a problem. Any idea why users in China sees 0 results while running query below in a Suitelet or Client Script where other users around the world, using the same role have results returned?
Copy code
const transQuery = `SELECT transaction.entity,line.uniqueKey,line.expectedReceiptDate,line.item,line.quantity
                                            FROM transaction
                                            JOIN transactionLine AS line ON transaction.id = line.transaction
                                            WHERE transaction.id = 2822663 AND line.id = 1`;
            const resultQuery = query.runSuiteQL({ query: transQuery }).results;
b
Different classifications on China employees such that they dont have access to the transaction being queried
1
s
They can find the PO on Global Search and view
j
different subsidiaries? Check the role they are using to see what you have for
Subsidiary Restrictions
and also check under the
Restrictions
tab
s
There are no restrictions, Allow Cross-Subsidiary Record Viewing is marked. I created a new employee with same. subsidiary & role and I can run the query without any problems. Unfortunately, will go for Support Case