I have an issue with SuiteQL. I contacted support ...
# suitescript
s
I have an issue with SuiteQL. I contacted support but they don't understand.... The working select is : SELECT transaction_lines.transaction_id FROM TRANSACTION_LINES WHERE LIST_ID = 1410290178 And it return the value right away but when I add the link to transaction, like this SELECT transaction_lines.transaction_id, transactions.DATE_LAST_MODIFIED FROM TRANSACTION_LINES INNER JOIN TRANSACTIONS ON TRANSACTIONS.transaction_id = TRANSACTION_LINES.transaction_id WHERE LIST_ID = 1410290178 I get the answer back after 60 seconds !!! I tried it with 2 of former customers and I get the answer back right away. Do we have to set something in Netsuite ?'