double filter in table list

Hi Max , focused again to migrate all my CF6 forms  to CF8

1st question how get switch submit button1(page1)  & button2(page1) on submit page for different action

2nd question how  to implement double filter in read data as optional

{data.quote:filtro1_sel}={data.quote:valor1}

{data.quote:filtro2_sel}={data.quote:valor2}

I had in CF6:

if(!empty($this->data['filtro1_sel']) && !empty($this->data['valor1'])){$where1=[];$where1[]=$this->data['filtro1_sel'];$where1[]="%".$this->data['valor1']."%";$where1[]="LIKE";if(!empty($this->data['filtro2_sel']) && !empty($this->data['valor2'])){$where2=[];$where2[]=$this->data['filtro2_sel'];$where2[]="%".$this->data['valor2']."%";$where2[]="LIKE";return [$where1,"AND",$where2];}else{return [$where1];}}

Hi Carlos

The filters should work similar to the search setup explained here:

https://www.chronoengine.com/faqs/chronoforms/chronoforms8/how-to-search-a-data-list-created-in-chronoforms8

You just need to use the List Filter behavior instead:

Does this solve your problem ? :)

Hi Max

I don't see it possible because in this double filte implementation you have data_filter1+Value1  and data_filter2+Value2, this means field1(dropdown) and value1(text) are variables, on this example filter field is fixed

I see very powerful behaviors in the read_data operation. I'm not sure whether introducing sql_code is the right approach, but it might be more appropriate to implement this within the read_data action itself in order to preserve existing constraints such as limits, rules, paging, and sorting.

I need your help addressing this limitation. Also, I’d like to ask how a selector column should be implemented to support group actions.