Is there a table or columns in any suiteql table t...
# suiteqlu
Umi
05/10/2022, 11:39 AMIs 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 PMAh 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 PMEntity
✅ 1
s
Shawn Talbert
05/11/2022, 1:49 PMAlan Fitch has been resurrected?
a
Alan Fitch
05/11/2022, 1:51 PMHonestly I've fluctuated between using this name and my given name depending on who I'm hanging out with or where I'm working.
Alan Fitch
05/11/2022, 1:51 PMI respond to Alan and Eli.
s
Shawn Talbert
05/11/2022, 2:04 PMjolly good
a
Alan Fitch
05/11/2022, 2:08 PMWell 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 PMI'd probably pick Raymond Reddington over Alan Fitch 🙂
2 Views