Hi everyone Using NetSuite N/query module in a scheduled script Using this query

var searchQuery = `SELECT id,status FROM transaction WHERE id = 30301354"`;

Returns a result with the value 'A' for the status But using the same value as part of the query returns zero results

var searchQuery = `SELECT id,status FROM transaction WHERE id = 30301354 AND status IN ('A')"`;

Same thing using

status = 'A'

Whats going on with this? Any hint would be appreciated.