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 ?'