In text_api.cfg field I added below parameter in CHANGE section
"CHANGE.FLAG2=flag2.INTEGER" -> flag2 is the "chg" table field
mail-eater read this "%FLAG2=1" and mail-eater engine set to flag2 field to "1"
I don't releated any table for this field. If you can keep approval infos in another table you add custom field in request table with SREL to this custom table and also added custom approval status field which may type integer or bool
custom approval table like simple
id INTEGER
persistent_id STRING
approval_status INTEGER -> default "0"
releated_request_object SREL cr
when new request create this approval records is create via SPEL trigger metot or CA PAM process which you may chose
Example for mail-eater actions
Request Table -> zapproval_id SREL <customapprovaltablereleated id or persistent_id fields>
Request Table -> zapproval_status INTEGER
In text_api.cfg, you can define this field
REQUEST.ZAPPROVAL_ID=zapproval_id.INTEGER.lookup_customapprovaltable_by_id
REQUEST.ZAPPROVAL_STATUS=zapproval_status.INTEGER
when you send to approval mail approval reply mail body like this
%REQUEST_ID=@{call_req_id.ref_num}
%ZAPPROVAL_ID=<approval record id> which is pending approval -> approval_status = 0
%ZAPPROVAL_STATUS=1
then when mail eater update your request you may trigger some spel code like below algoritihm
1. query zapproval_id value in customapprovaltable and get the record
2. get approval_status value of record
3. if approval_status = 0 and zapproval_status = 1 then set approval_status "1"
4 else no take action
for rejection
3. if approval_status = 0 and zapproval_status = 2 then set approval_status "2"
4 else no take action
If CA SDM version 14.1 with cummaltive patch 2 you can desing approvals on Classic Workflow for Request
I hope, I can define what you need.
regards,
Türker