I need to determine if a record is an entity, a cu...
# suitescripta
Anthony OConnor
09/13/2023, 5:54 PMI need to determine if a record is an entity, a custom record or a transaction... without loading the record... I have the record type and id.
so far I've got custom records if the record.Type startswith
"custom"entityidc
Clay Roper
09/13/2023, 5:55 PMWhen you say you have the record type, how does that differ from what you're trying to determine?
a
Anthony OConnor
09/13/2023, 5:56 PMI don't have a list of all the transaction types and/or entity types
c
Clay Roper
09/13/2023, 5:56 PMAre you needing to map the type you have to one of those 3 categories?
👍 1
Clay Roper
09/13/2023, 5:56 PMAh got it
Clay Roper
09/13/2023, 5:57 PMSince internal IDs are shared across all entities and all transactions, you could consider querying those tables to compare to the record id you're given
Clay Roper
09/13/2023, 5:58 PMFor example, if I'm given a type and an ID, I can run this query
SELECT id, recordtype FROM transaction WHERE id = ${id}Clay Roper
09/13/2023, 5:59 PMMaaaaybe even like
SELECT COUNT(id) FROM transaction WHERE id = ${id} AND recordtype = ${type}Clay Roper
09/13/2023, 5:59 PMsame for entity
a
Anthony OConnor
09/13/2023, 5:59 PMneat, that seems pretty solid, thank you
🌟 1
c
Clay Roper
09/13/2023, 5:59 PMLet me know how it goes!
Clay Roper
09/13/2023, 6:00 PMDepending on the kind of script you're running, you could always build a map using
SELECT DISTINCT recordtype FROM transactionClay Roper
09/13/2023, 6:01 PMhmm,
recordtypea
Anthony OConnor
09/13/2023, 9:36 PMWorks great thanks again... this is also to hopefully explain "why the hell do you even want this???" 🙂
🎉 1
Anthony OConnor
09/13/2023, 9:38 PMrender.mergeEmail👍 1