https://netsuiteprofessionals.com logo
u

Umi

05/10/2022, 11:39 AM
Is there a table or columns in any suiteql table that would show that a transaction or change has been made by an automated user? I am trying to find this, but had no luck so far (i.e. an "Automated" boolean column, or something similar)
a

Alan Fitch

05/10/2022, 1:32 PM
Copy code
Select transaction.tranid, systemnote.field from transaction inner join systemnote on transaction.record = {id} where BUILTIN.DF(systemnote.name) = '-System-'
u

Umi

05/10/2022, 2:01 PM
Ah that seems like a great solution. Is the BUILTIN.DF function in this instance drawing from the entity table? User table? I ask because we are using an extraction tool named CData that doesn't allow builtin functions
a

Alan Fitch

05/10/2022, 2:09 PM
Entity
1
s

Shawn Talbert

05/11/2022, 1:49 PM
Alan Fitch has been resurrected?
a

Alan Fitch

05/11/2022, 1:51 PM
Honestly I've fluctuated between using this name and my given name depending on who I'm hanging out with or where I'm working.
I respond to Alan and Eli.
s

Shawn Talbert

05/11/2022, 2:04 PM
jolly good
a

Alan Fitch

05/11/2022, 2:08 PM
Well if you could pick any names of the billions of possible names would you pick "Shawn Talbert"? It's a nice name but do really think it's the top name of all the possibilities?
s

Shawn Talbert

05/11/2022, 2:43 PM
I'd probably pick Raymond Reddington over Alan Fitch 🙂