Jake
01/24/2022, 6:00 PMMatt Carter
01/25/2022, 3:44 PMburkybang
01/26/2022, 3:18 PMSELECT * FROM transaction UNION SELECT * FROM transaction
SELECT TOP 1 id FROM transaction UNION SELECT TOP 1 id FROM transaction
Cory Weiner
01/26/2022, 9:33 PMburkybang
01/27/2022, 4:13 PMIf your SuiteApp uses SuiteQL, are any of your queries use both SQL-92 and Oracle SQL?(Yes, the question has that weird wording) How can I tell if my SuiteQL is using both SQL-92 and Oracle SQL or not? I wasn't aware there's a difference.
BullgillRunner
01/27/2022, 4:53 PMAlli Deacon
02/02/2022, 7:27 PMselect ExternalID as Validation FROM item where itemid='1-1624-8-89' or DisplayName ='1-1624-8-89' or UPCCode = '1-1624-8-89'
However, it returns NULL. When I look up the item in the NetSuite UI I see that it is Item ID 590557. When I run the following query it still returns NULL, select ExternalID as Validation FROM item where id = '590557'
. The item url is app/common/item/item.nl?id=590557
. I am at a loss here why it's returning a NULL, when by all angles it should be returning the correct item. Any assistance is appreciated! TIA 🙂XochisSketches
02/02/2022, 8:02 PMCASE WHEN {custrecord_customcheckbox} = 'F' THEN 'Create' ELSE 'Update' END
.
The checkbox in question is unchecked, but this column keeps returning 'Update' in the results.....anyone have any ideas?Michael Lim
02/03/2022, 9:20 AMSELECT * from customers
I received this error:
{"type":"<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.2>","title":"Unauthorized","status":401,"o:errorDetails":[{"detail":"Invalid login attempt. For more details, see the Login Audit Trail in the NetSuite UI at Setup > Users/Roles > User Management > View Login Audit Trail.","o:errorCode":"INVALID_LOGIN"}]
In the Login Audit Trail, there’s this error InsufficientPermissions in the Details column (IP addresses and other details redacted). At a loss figuring out what’s wrong. Any help is very much appreciated, thank you!Budy Sutjijati
02/03/2022, 1:59 PMSELECT
type,
tranid,
id,
BUILTIN.DF(custbody_rfi_trm_temp_shipstatus) as tempstatus,
TO_CHAR(createddate, 'DD/MM/YYYY HH24:MM:SS') AS createddatetime,
TO_CHAR(lastmodifieddate, 'DD/MM/YYYY HH24:MM:SS') AS lastmodifieddatetime,
TO_CHAR(current_date, 'DD/MM/YYYY HH24:MM:SS') AS currentdate
FROM
transaction
WHERE
transaction.type
LIKE '%ItemShip%'
AND
BUILTIN.DF(transaction.custbody_rfi_trm_temp_shipstatus) = 'PROCESSING'
ORDER BY lastmodifieddate desc
suiteExperimenter
02/04/2022, 10:14 AMinventoryNumberQuery.condition = inventoryNumberQuery.createCondition({
fieldId: 'isonhand',
operator: <http://query.Operator.IS|query.Operator.IS>,
values: [true]
});
Is there an alternative way on how can I filter serial numbers that is on hand?Selcuk Dogru
02/08/2022, 1:31 PMburkybang
02/08/2022, 6:45 PMDavid B
02/08/2022, 10:45 PMrecord.load
or record.submitFields
?
For example with an item I have "itemtype" as a query column, which results in "_InvtPart_". However the corresponding type is actually "_serializedinventoryitem_" (from record.Type.SERIALIZED_INVENTORY_ITEM
)
Looking at the record, "baserecordtype" has what I want ("_serializedinventoryitem_"), but isn't a field in the records catalogue.darrenhillconsulting
02/10/2022, 8:50 PMdarrenhillconsulting
02/11/2022, 1:19 AMburkybang
02/11/2022, 2:23 PMSELECT TO_CHAR(sysdate, 'DS TS') FROM DUAL
Diogo
02/15/2022, 2:11 AMmichoel
02/16/2022, 4:30 AMBUILTIN.HIERARCHY
?Mitch Herndon
02/16/2022, 10:03 PMSimon
02/17/2022, 10:26 PMMattias Uppström
02/18/2022, 1:52 PMChris Deakin
02/18/2022, 6:03 PMdarrenhillconsulting
02/20/2022, 2:47 AMMatt Bernstein
02/22/2022, 4:10 PMscottvonduhn
02/22/2022, 4:27 PMAlan Fitch
02/22/2022, 5:03 PMcreece
02/22/2022, 7:39 PMAlan Fitch
02/22/2022, 9:38 PMAlan Fitch
02/22/2022, 9:41 PM