exclude element list

[csantof]

HI,

I have a list with name (field) and one option (radiobutton)
this list is linked by the plugin cascading dropdown in another list.

I need to exclude to the frontal view the elements to the list who have the radiobutton on.

thanks

 

[startpoint]

You can manipulate list view from every element List view settings.
- Show in list
- Include in list query

 

[csantof]

Hi, I used pre-filter in my list

where radiobutton1 is null not quote access all

this pre filter works well in the list i don't see the element but I see this element in my cascading dropdown. The prefilter does'nt work.

How can I solved this problem

 

[startpoint]

Sorry, but i can't understand your description.

 

[troester]

Use the "Where query" in the "Advanced" tab.
http://fabrikar.com/forums/index.php?wiki/cascading-dropdown-element/

 

[Maud67]

Use the "Where query" in the "Advanced" tab.
http://fabrikar.com/forums/index.php?wiki/cascading-dropdown-element/

I run into exactly the same problem right now.
When I have no WHERE query in the ccd, the filters in the list are working.
Using a pre-filter works.

But not for the form (new add).
In the ccd I get the complete list.

But when I put in the WHERE query "active = 1" in the ccd it is not working .
It even blocks the list filter (ccd).
I don't get a selection.

I tried several notations of "active = 1" but no luck.

Is this recognizable for anyone?
Can somebody help me please?
Thanks in advance.

 

[troester]

Cascading dropdown is tricky.
You can try to use a dbjoin element with "Data - where" and "Ajax update" enabled.

 

[Maud67]

Hi Troester,

I already found out that it worked with db join.

Thanks for the info and warning

 

[csantof]

I don't find how does it works
Each time I have an error.
In my ccd element / details /data where

SELECT FROM {Mytable} WHERE myelement = 'mycondition';

Update ajax YES

but nothing works

 

[troester]

I assume you mean database join element, not ccd element?

Please read WIKI http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where

and tooltips

i.e use only a WHERE part
(BTW: also your SELECT is no valid syntax)

 

[Maud67]

Hi csantof,

I needed these filters for two different lists.

For the first list I used the db join and a status element with WHERE {thistable}.active ='0'.
The filter status of the status element is "none".

For the second list I used the ccd element but without WHERE.
I had filters on several elements.
I connected the element "Week" to the other elements.
A ccd watching "Week" for every filter.
So the filters only work if users select the week number or "All".

For me it is good enough for now.

I hope it helps

 

[csantof]

I' m sorry but each time It doesn't work. I'm really bad with SQL

So I resume:

first table :
field 1 : name (plugin field)
field 2 : ok (plug in radiobutton with 2 choice choice 1: yes (default) choice 2: no)

second table
field 1 : name (plugin dbjoin -> join with first table -> view list
field 2 :
field 3 : etc

on the second table in data-Where

WHERE {first table}.field 2 = yes -> for having only the list of the name ok

 

[troester]

WHERE {thistable}.field2='1'

Literally {thistable}, it's replaced by Fabrik with the table alias which is not fixed, depending on other joins or elements you are using
=1 because you are working on MySQL level, i.e. with the raw database table/column values (yes/no are the labels, not stored in the database).

 

[csantof]

Ok I suppose It's work but my field is on a repeat group and my list is empty.