Filter connection results with form

Question

Hi,

I am trying to get to grips with CCV6 and I have a very basic question.
I have a connection which shows me a list of details in table view.

I would like to add a form above the table which allows me for example, to search for a name and age then after submit only show me the matching results.

I have added a form view and field view successfully above my table but I don't know whether this is the correct thing to do and how to make that form perform the search/filter on submit?

A link to a tutorial or any advice would be much appreciated.

Thanks in advance.
Regards

Max_admin · Accepted Answer

Hi ctrlmedia,

Your code is not correct ({data.age} should be {data:age} assuming the field name is "age"), and you can't use PHP in this format, but what you need to do can be done this way:


<?php
$return = [["Assessments.name", $this->data("name")]];
if($this->data("age")){
$return[] = "OR";
$return[] = ["Assessments.age", $this->data("age")];
}
return $return;
?>

Best regards,
Max

Forums

Filter connection results with form