Help prefilter, join and group

[frankpto]

Hello,
I would do this:

WHERE
( sectores_organizacion = $sector AND ambito_act = 0 ) OR
( sectores_organizacion = $sector AND comunidad_org = $comunidad AND ambito_act = 1 ) OR
( sectores_organizacion = $sector AND ciudad_org = $ciudad AND ambito_act = 2 ) OR
( sectores_organizacion = $sector AND localidad_org = $localidad AND ambito_act = 3 )


I tried to do so, but it seems that is not the way to do it. I am completely confused with the [join] and [group_to_previous]

Can someone help me and tell me how you can translate the above query WHERE to a prefilter.

I've read the example:
http://fabrikar.com/forums/index.php?wiki/filtering-lists-tables/

But I do not get it right.

This is what I have written but not working.

index.php?option=com_fabrik&view=list&listid=8&Itemid=313
&resetfilters=1

&kfadr_jd_campaigns___sectores_organizacion[value][]=<?php echo $sector;?>
&kfadr_jd_campaigns___ambito_act[value][]=0
&kfadr_jd_campaigns___ambito_act[join][]=OR
&kfadr_jd_campaigns___sectores_organizacion[join][]=AND
&kfadr_jd_campaigns___sectores_organizacion[grouped_to_previous][]=0
&kfadr_jd_campaigns___ambito_act[grouped_to_previous][]=1

&kfadr_jd_campaigns___sectores_organizacion[value][]=<?php echo $sector;?>
&kfadr_jd_campaigns___comunidad_org[value]=<?php echo $comunidad;?>
&kfadr_jd_campaigns___ambito_act[value][]=1
&kfadr_jd_campaigns___sectores_organizacion[join][]=OR
&kfadr_jd_campaigns___ambito_act[join][]=AND
&kfadr_jd_campaigns___ambito_act[grouped_to_previous][]=0
&kfadr_jd_campaigns___sectores_organizacion[grouped_to_previous][]=1

&kfadr_jd_campaigns___sectores_organizacion[value][]=<?php echo $sector;?>
&kfadr_jd_campaigns___comunidad_autonoma_org[value]=<?php echo $ciudad;?>
&kfadr_jd_campaigns___ambito_act[value][]=2
&kfadr_jd_campaigns___sectores_organizacion[join][]=OR
&kfadr_jd_campaigns___sectores_organizacion[join][]=AND
&kfadr_jd_campaigns___sectores_organizacion[grouped_to_previous][]=0
&kfadr_jd_campaigns___sectores_organizacion[grouped_to_previous][]=1

&kfadr_jd_campaigns___sectores_organizacion[value][]=<?php echo $sector;?>
&kfadr_jd_campaigns___comunidad_autonoma_org[value]=<?php echo $localidad;?>
&kfadr_jd_campaigns___ambito_act[value][]=3
&kfadr_jd_campaigns___sectores_organizacion[join][]=OR
&kfadr_jd_campaigns___sectores_organizacion[join][]=AND
&kfadr_jd_campaigns___sectores_organizacion[grouped_to_previous][]=0
&kfadr_jd_campaigns___sectores_organizacion[grouped_to_previous][]=1

 

[rackem]

Agreed, the syntax is confusing.

First of all, I think you'll want to use placeholders to get values (not echo).
http://fabrikar.com/forums/index.php?wiki/placeholders/

You can turn on Fabrik debug to see what query is being generated.
http://fabrikar.com/forums/index.php?wiki/url-structure/#debugging

 

[rackem]

I've had a recent breakthrough in my application with this. You may find the last post in this thread helpful.
http://fabrikar.com/forums/index.php?threads/list-filter-via-url-issue.39457/page-4#post-213269

 

[frankpto]

ok,

Thanks