In Confiforms, I want to create a filter (in the TableView macro) to show all records where two text fields (text1 and text2) do not match. I've tried * !text1:text2 * !text1:[text2] * !text1:[entry.text2] This works when comparing numbers and dates ... but not strings.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confiforms filter compare two text fields

fbunting

In Confiforms, I want to create a filter (in the TableView macro) to show all records where two text fields (text1 and text2) do not match.

I've tried

!text1:text2
!text1:[text2]
!text1:[entry.text2]

This works when comparing numbers and dates ... but not strings.

Accepted answers

Alex Medved _ConfiForms_

The filtering expression would need to be something like this

!text1:[entry._func.asEntryRef(entry.text2)]

All comments

Katerina Rudkovskaya _Stiltsoft_

Hi @fbunting

You can filter rows not equal to selected values with the help of the Table Filter macro of the Table Filter and Charts for Confluence app.

Wrap your table with Table Filter, switch to the Filters tab, select the dropdown filter column and add values (text1, text2) to it, then switch to the Filtration tab, click Select reversed filters, define the filter to operate in the reverse mode.

Best regards,
Katerina

Katerina Rudkovskaya _Stiltsoft_

@fbunting,

I think I've got what you need, please try our Table Transformer macro in your case.

Wrap you rable with it and use the SQL query like this:

SELECT * FROM T1
WHERE T1.'COLUMN 1' <> T1.'COLUMN 2'

Best regards,
Katerina

Alex Medved _ConfiForms_

The filtering expression would need to be something like this

!text1:[entry._func.asEntryRef(entry.text2)]

fbunting

Wow. I never would have found that ... but it works!

Thanks Alex!

fbunting

Thank you Katerina for your detailed answer! I was about to try the Table Filter macro ... because we have it, and it's great. (I use it constantly.)

But in this case, I knew there was some magic filter incantation that I could throw right in the Confiforms TableView macro.

But I didn't know about the Table Transformer macro. I'll have to check it out!

fbunting

Side note: I notice that this comparison is case-independent. If text1 is Foobar, and text2 is FooBar, it apparently sees them as the same.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms