[SOLVED] Using an IF statement within a Query Display Row on a [column_ value

I have a query field with a 'multiple' display.

The query returns [column_state] that I need to use to show/hide different content based on the value in [column_state].

I've tried a few different options with [cb:if
but nothing related to that seems to work.

I've also tried to insert inline php code with an if clause, but that doesn't seem to work either.

Is there any way within a Display's "Row" to create an if clause based on the value of a [column_value]?

You should be able to use IF substitutions on it like you would any field value. Example as follows.

[cb:if column_value="123"]Pass[/cb:if]

The Template output usage also gives access to PHP as it's output by a template file where the query data is passed.

Thanks. I had brackets around the column_name as well. Removed them and it works perfectly.

Could you tell me where to find the template output file (or any docs/other posts that give any details about using that method)?

Could you tell me where to find the template output file (or any docs/other posts that give any details about using that method)?

The template file can be found in the plugins templates folder below.

/components/com_comprofiler/plugin/user/plug_cbqueryfield/templates

Copy the default template, rename it, then select it as your template within your Query field and start editing the display.php file within your template.

More cool ways to customize!

Thanks!