Data Rows - Filter - comparing rows within a node

1

I am trying to see if there is a way to do this.

I have a series of nodes with 3 fields in each, RECORDKEY, PAYMENTKEY, STATE.

I want to filter out any node where RECORDKEY = PAYMENTKEY…like so

image
image.png876×308 12 KB

Clearly this doesnt work. I am assuming the module treats the second field as text literal. Is there a way to compare two fields like that in the filter?

2

Hi Brent,

Sorry, the module cannot currently do that. Has been something I’ve been aware of, but the need for it rarely arises enough for me to implement that capability.

Currently the right side of the evaluation is always just a text string.

You will have to do that filtering via Java code.

3

Ok. that is what I thought i might need to do. Just wanted to make sure.

thanks