how to get all items from an opportunity using suitesql?

AI generated answer (using internal Slack threads):

To get all items from an opportunity using SuiteQL, you would need to join the

transaction

table with the

transactionline

table. The

transaction

table contains the opportunity data, and the

transactionline

table contains the items associated with each transaction. Here is a sample SuiteQL query:

sql
SELECT T.id AS opportunity_id, T.tranid AS opportunity_number, TL.item AS item_id
FROM transaction T
JOIN transactionline TL ON T.id = TL.transaction
WHERE T.type = 'Opprtnty'

This query will return the opportunity ID, opportunity number, and item ID for each item associated with an opportunity. You can modify the fields in the SELECT clause to retrieve additional information as needed. Please note that the account you're using will need to have permissions on: Transactions > Opportunity. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******