I need a SuiteQL query to bring information from Sales Order lines, but exclude the lines that have a Purchase Order attached

AI generated answer (using internal Slack threads):

To create a SuiteQL query that brings information from Sales Order lines, but excludes the lines that have a Purchase Order attached, you can use the

transactionlines

table and the

previouslinks

field. This field can be used to identify the lines that have a Purchase Order attached. Here is a sample SuiteQL query:

sql
SELECT 
    transactionlines.*
FROM 
    transactionlines
LEFT JOIN 
    transactionlines.previouslinks
ON 
    transactionlines.id = transactionlines.previouslinks.previousline
WHERE 
    transactionlines.type = 'Sales Order'
AND 
    transactionlines.previouslinks.type IS NULL

This query selects all fields from the

transactionlines

table where the type is 'Sales Order' and there is no linked Purchase Order. The

LEFT JOIN

with

transactionlines.previouslinks

allows us to check if there is a linked Purchase Order for each Sales Order line. If

transactionlines.previouslinks.type

is NULL, it means there is no linked Purchase Order. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******