I'm working on a custom Sage Intacct application/object via Platform Services and I have the Workflow attribute enabled:
Objects with the Workflow attribute can be routed through workflows defined by a set of workflow processes, statuses, and actions. Fields called Workflow process, Workflow status, and Workflow actions will be added when this attribute is enabled.
I have 3 statuses defined: Pending, Approved, Declined
When I try to query the status field via SI.XQUERY or SI.QUERY I only get an object/value id - eg 10015,10016
Ideally I'd like to see the text instead "Pending", "Approved", "Declined"
In my custom object, Triggers have the following additional merge field options:
"{!MY_OBJECT.status#code!}" == "APPROVED" (This is the Integration name)
"{!MY_OBJECT.status#value!}" == "Approved" (This is the status name)
So it seems it accessible in some form, but annoyingly I can't see a relationship or even a status object to query separately so I'm not sure if this is something you can implement, but I'm hoping you have some inside information I don't :)
The only other solution I have is to use a trigger to copy the status value/code into another user defined field purely so I can query in via Velixo.
Cheers Ben
0 Votes
2 Comments
Sorted by
B
Ben Perryposted
about 10 hours ago
Thanks for the quick reply Damien.
Glad to know it's not me missing something obvious - I'll go with the field update trigger, and also raise it as a feature request with the Sage Intacct.
Cheers Ben
0 Votes
Damien Zwillingerposted
about 11 hours ago
Hi Ben
This is correct the STATUS system object cannot be queried by SI.QUERY or SI.XQUERY.
You could work out which RecordNo correspond to the which Statuses and hardcode that mapping in an Excel calculation. That's the easiest way, but bear in mind the RecordNo vary across objects (that would only apply to that custom object).
I think the Field Update Trigger populating a text field is indeed the best option.
0 Votes
I'm working on a custom Sage Intacct application/object via Platform Services and I have the Workflow attribute enabled:
Objects with the Workflow attribute can be routed through workflows defined by a set of workflow processes, statuses, and actions. Fields called Workflow process, Workflow status, and Workflow actions will be added when this attribute is enabled.
I have 3 statuses defined: Pending, Approved, Declined
When I try to query the status field via SI.XQUERY or SI.QUERY I only get an object/value id - eg 10015,10016
Ideally I'd like to see the text instead "Pending", "Approved", "Declined"
In my custom object, Triggers have the following additional merge field options:
"{!MY_OBJECT.status#code!}" == "APPROVED" (This is the Integration name)
"{!MY_OBJECT.status#value!}" == "Approved" (This is the status name)
So it seems it accessible in some form, but annoyingly I can't see a relationship or even a status object to query separately so I'm not sure if this is something you can implement, but I'm hoping you have some inside information I don't :)
The only other solution I have is to use a trigger to copy the status value/code into another user defined field purely so I can query in via Velixo.
Cheers
Ben
0 Votes
2 Comments
Ben Perry posted about 10 hours ago
Thanks for the quick reply Damien.
Glad to know it's not me missing something obvious - I'll go with the field update trigger, and also raise it as a feature request with the Sage Intacct.
Cheers
Ben
0 Votes
Damien Zwillinger posted about 11 hours ago
Hi Ben
This is correct the STATUS system object cannot be queried by SI.QUERY or SI.XQUERY.
You could work out which RecordNo correspond to the which Statuses and hardcode that mapping in an Excel calculation. That's the easiest way, but bear in mind the RecordNo vary across objects (that would only apply to that custom object).
I think the Field Update Trigger populating a text field is indeed the best option.
Regards
Damien
1 Votes
Login or Sign up to post a comment