Discussions
System Notes : Set by - Search Formula
I am trying to add a formula to a (Sales Order) transaction search that displays the user name captured within the Set by column in System Notes:
CASE WHEN {systemnotes.type}='Set' AND {systemnotes.field}='xxxxx' THEN {systemnotes.setby} END
The results returned are 'ERROR: Field Not Found'. I am guessing this is due to {systemnotes.setby} based on the fact that I cannot find any posts within the User Group that provides a solution referencing this field.
Any assistance is appreciated.