Where Conditions

Use a database field value as a condition in ChronoForms.

Overview

The issue occurred when trying to use a value from one database table as a condition in another table, but the field reference was incorrectly structured.
Ensure the database field reference uses the correct syntax and index to match the required records, adjusting the condition setup in the CF form action.

ra rafaelscouto 12 Apr, 2019

How do I make the [cod_sec] value of the [read_users] database appear in the `cod_sec`

Where Conditions image 1

of the [read_manifestos]

he healyhatman 12 Apr, 2019

Answer

1 Likes

{var:read_users.0.Ouv.cod_sec}

The 0 is because you have it set to All matching instead of first matching.

ra rafaelscouto 12 Apr, 2019

Yes, because I need to load all items that have this value.

It worked, thank you!

This topic is locked and no more replies can be posted.