This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey, How can I add a condition to SQL that will pull only transactions that were last modified in the last week,

```SELECT
  tranid,
  trandate,
  custbody_cl_risk,
  custbody_cl_so_first_payment_date,
  custbody_sf_opp_id,
  lastModifiedDate,
FROM
  Transaction
WHERE
  Transaction.Type='SalesOrd' AND custbody_sf_opp_id is not null```


```AND lastmodifieddate &gt; SYSDATE - 7```

<@UHF2QGCUX> If I would like to have an SQL of the system notes of 3 specific fields from the sales order transaction, how should the SQL structure be? :thinking_face:

typically you'd reach for something like `and sn.field in ('field1', 'field2', 'field3')` but the field names in the `systemnote` table are weird so you would probably need to examine which fields have the values that you see in the UI.