var sql = "SELECT custrecord_inn_subsidiary, recor...
# suiteqlx
XochisSketches
10/19/2021, 9:31 PMvar sql = "SELECT custrecord_inn_subsidiary, recordid FROM customrecord_property_inn_codes WHERE custrecord_inn_code = " + 'Some String'
var results = query.runSuiteQL({ query: sql }).results[0].values
c
CD
10/19/2021, 9:33 PMTry this, I think it's the quotes:
CD
10/19/2021, 9:33 PMvar sql = "SELECT custrecord_inn_subsidiary, recordid FROM customrecord_property_inn_codes WHERE custrecord_inn_code = '" + 'Some String' + "'";x
XochisSketches
10/19/2021, 9:35 PMThat worked. Thanks!
s
stalbert
10/20/2021, 2:26 PMmight I suggest using modern template strings and you'd avoid this problem in the first place.
c
CD
10/20/2021, 2:27 PMShould be using parameters.
3 Views