Compare two fields from the same table - Universal Connector

Hi,

I have a sql database and want to query this with JR:

ID | Header          | Text
1  | Doc - XYZ000001 | Invoice: balblabla - Text: blablabla - Code: XYZ0000001 - blablabla
2  | Doc - XYZ000002 | Invoice: balblabla - blablabla - Text: blablabla - Code: XYZ0000001 - blablabla
3  | Doc - XYZ000003 | blablabla - Code: XYZ0000003 - Text: blablabla - blablabla

For SQL I would do this:

SELECT ID
FROM Table
WHERE Text NOT LIKE '%' + REPLACE(Header, 'Doc - ', '') + '%'

I was searching for an example and found this:

How do I compare two fields from the same table – Support Topics (jetglobal.com)

So following the article I tried this:

=NL("Rows";"Table";"ID";"Text";"=CONCATENATE(""<>*"";SUBSTITUTE(NF(;""Header"");""Doc - "";""Code: "");""*"")")

But I can't get it to work. So as the entry is very old I wondered if anything changed and someone did something similar?

Compare two fields from the same table - Universal Connector

0 comments