Hello,

We are trying to make subscriber routing filtering work without success. we are sure we are just missing out an obvious aspect

We publish a salesforce CDC (capture data change) to a topic as object (not string)

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/67d946e44400921fb8fb9a2c0c7f940cb3735c50.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/67d946e44400921fb8fb9a2c0c7f940cb3735c50.png 2x" data-dominant-color="F9F9FA">

image969×594 33.5 KB

Seen in the log, this is the structure we got out of it

> {
>   "JMSMessage": {
>     "properties": {
>       "JMSXDeliveryCount": 1
>     },
>     "header": {
>       "JMSCorrelationID": null,
>       "JMSDeliveryMode": 2,
>       "..." : "..."
>     },
>     "body": {
>       "object": {
>         "payload": {
>           "LastModifiedDate": "2023-05-25T15:17:40.000Z",
>           "FRO_VI_ACCOUNTTYPE__c": "Cust"
>           }
>         }
>       }
>     }
>   }
> }

We would like to trigger a workflow only if JMSMessage.body.payload.FRO_VI_ACCOUNTTYPE__c = “Cust”

All our attempts failed so far, we saved + skip + save all the time. How it’s triggered

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/b0b71cd5563c9b8c467ac632995c76ae11dbbc28.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/b0b71cd5563c9b8c467ac632995c76ae11dbbc28.png 2x" data-dominant-color="FAFAFB">

image932×719 27.2 KB

we tried

• %JMSMessage/body/object/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust”
• %JMSMessage/body/object/payload/FRO_VI_ACCOUNTTYPE__c%=“Cust”
• %body/object/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust”
• %body/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust”
• %body/data/payload/FRO_VI_ACCOUNTTYPE__c%==“Cust” (documentation points to data rather object)

any help would be appreciated

Hi Fabien,

can you try L_EQUALS as comparison operator instead of “==”?

Regards,
Holger

finally succeed to make it works with

• %body/object/payload/FRO_VI_ACCOUNTTYPE__c%=“Cust”

data => object (coming from standard push block)
== => =

tooltip help seems to have 2 wrong infos …