is there a ".recordtype" attribute equivalent you ...
# suitescriptt
The Usual Suspect
05/30/2024, 6:13 PMis there a ".recordtype" attribute equivalent you can do for analytics / suiteql result values like you can with a saved search?
e
erictgrubaugh
05/30/2024, 7:15 PMShort answer: nope
👍 1
t
The Usual Suspect
05/30/2024, 7:20 PMI'm seeing that if you compare the raw JSON stringification they just didn't put that info into the dataset / sql
The Usual Suspect
05/30/2024, 7:21 PMThis is infuriating. They have so many types, subtypes, generic types I need the result to tell me what the hell it is. Knowing somehting is an entity or transaction isn't enough
The Usual Suspect
05/30/2024, 7:24 PMAnd a record type is of course not available on a lot of records or just named something else on other records. I can't just depend on being able to add my own type column in every time because an invalid column will break the query / sql
z
Zoran R-DATAGRAM
06/12/2024, 9:56 AMWhen creating an SQL command, the record type property makes no sense. “FROM table1 JOIN table2 JOIN table3” and what do you expect?