Hey there, that is why some filter inputs (like the date filter field for example) have 2 fields with the same name, that way they get submitted as an array and you have access to both values in the addXXXColumnQuery method.
Please look at the auto-generated forms. It's all there. Daniel On May 4, 1:42 am, fRAnKEnSTEin <shirkav...@gmail.com> wrote: > Hi, > > As i see..i think i can not add few addXXXColumnQuery methods and > create a query in parts. I tell you why. I have 2 "custom inputs", so > if i create 2 addXXXColumnQuery methods, ill end with something like > this: > > public function addMyCustomInput1ColumnQuery($query, $field, $value) > { > > } > > public function addMyCustomInput2ColumnQuery($query, $field, $value) > { > > } > > Now the query i need to create is this one: > > $auery = Select * table > where > (initial_date <= myCustomInput1 and final_date >= > myCustomInput1 ) (*) > or > (final_date >= myCustomInput2 and initial_date <= > myCustomInput2 ) (**) > or > (initial_date >= myCustomInput1 and final_date <= > myCustomInput2) (***) > > First of all, as you see i need to create 3 conditions(marked with > (*), (**) and (***) ) and following your approach i only got 2 > methods(one for each field that i am using, these are:myCustomInput1 > and myCustomInput2), > > Second each condition uses both fields for creating the query, so if i > use the method as you suggest: > > public function addMyCustomInput1ColumnQuery($query, $field, $value) > { > //HERE I GET THE MyCustomInput1 value > $field = $this->getFieldName($field); > > //HERE I USE THE $field VARIABLE TO MAKE THE FIRST > CONDITION..BUT ALSO NEED TO GET THE myCustomInput1 VALUE TOO...AND > INSIDE THIS METHOD I DONT KNOW HOW, I > //NEED SOMTHING LIKE > $query->andWhere(initial_date <= $fieldName and final_date >= > myCustomInput1 ) > > } > > and as you can see even i i create the first condition comehow, even i > have to separece eachone (*),(**) and (***) with OR. So, please note > the query i need to create, i have 2 OR and 3 ANDS, each AND uses > myCustomInput1 and myCustomInput1 for creating the differents > conditions... > > This is why i can not use just the addXXXColumnQuery and create the > query by parts... > > Am i right? > > Cheers > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to symfony-users@googlegroups.com > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com > For more options, visit this group > athttp://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en