Does anyone know if there’s a table that includes ...
# suiteqlj
jen
04/28/2022, 3:34 PMDoes anyone know if there’s a table that includes the system notes details for changes to Workflows? The regular System Notes just shows the revision number, but not what actually changed. I’m looking for something closer to what you can see in the UI:
m
Matt Bernstein
04/28/2022, 10:39 PMThere is a table called systemNoteContextType where the key for workflow is WFFW and it looks like it connects to SystemNote via SystemNote.context
SELECT
SystemNote.context,
SystemNote.oldvalue,
SystemNote.newvalue
FROM
SystemNote
WHERE
SystemNote.context IN ('WFFW')
j
jen
04/29/2022, 2:59 PMooooh
jen
04/29/2022, 3:24 PMwait, that’s just the SystemNote table. And I don’t see anything with WFFW recently, though I edited my WF yesterday. Still no details. There are only entries for when the WF “revision” changes, and then it’s just old value = 72, new = 73 or whatever
jen
04/29/2022, 3:28 PMmessage has been deleted
m
Matt Bernstein
05/02/2022, 4:29 PMI misunderstood. I was able to pull everything but the component.
SELECT
s.date,
s.record,
s.recordid,
s.oldvalue as previous_revision,
s.newvalue as new_revision,
BUILTIN.DF(s.field),
BUILTIN.DF(s.name) as employee,
BUILTIN.DF(s.role),
s.type,
s.recordtypeid,
s.context
FROM
SystemNote as s
WHERE recordtypeid IN (-129)
j
jen
05/02/2022, 4:34 PMStill does not have the info that shows in the ‘ID’ column of my screenshot
jen
05/02/2022, 4:34 PMthe problem I am trying to solve is knowing what actually changed on the WF
jen
05/02/2022, 4:35 PMyour SQL only shows me that the revision number changed
m
Matt Bernstein
05/02/2022, 5:51 PMso you're wanting an audit log of every change of the workflow? they have it for workflow scripts but I guess they don't have it for workflows themselves which is odd. You might be able to log an enhancement request
j
jen
05/02/2022, 6:33 PMI just want to get the same info you can see in System Notes
jen
05/02/2022, 6:34 PMwondering if it is stored in a different database table
m
Matt Bernstein
05/02/2022, 6:36 PMright. the system notes are only showing the workflow changed as you mentioned but not what is actually changing which means there probably would have to be a join but i'm not seeing any other to join to
3 Views