Forums

Where Conditions Box deprecated

Admiral 17 Jun, 2023
In the original v6 of Chronoconnectivity in the Functions tab (under the database -> "read data" option) there was a Box for "where conditions" and you could enter something like: Article.id:{data:article_id}
However in the new version of v6 the box is missing and instead you need to enter the function separately into four boxes: TABLE FIELD NAME; CONDITION; VALUE; NULL VALUE I am not a coder and am really struggling with this. Could someone please breakdown Article.id:{data:article_id} into the appropriate boxes for me? I have tried multiple different combinations but cannot get it to work!

Thanks so much!

Admiral
Max_admin 03 Jul, 2023
Answer
I think you should add "Article.id" in the "Table Field name" and "{data:article_id}" in the "Value" box, the condition should be "="
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Admiral 13 Jul, 2023
That worked, thank you!

Admiral
Zubairsk 19 Jul, 2023
In the new version of Chronoconnectivity v6, you need to enter the "where conditions" separately into four boxes: TABLE FIELD NAME, CONDITION, VALUE, and NULL VALUE. Let's break down the expression "Article.id:{data:article_id}" and map it to the appropriate boxes:

TABLE FIELD NAME: This refers to the field in the database table you want to apply the condition to. In this case, the field is "Article.id." So, enter "Article.id" in this box.

CONDITION: This specifies the condition you want to apply to the field. In the given expression, the condition is equality. Therefore, choose the appropriate equality operator
You need to login to be able to post a reply.