Pre-Filter Queries

[peterk900]

I cannot find an example of a list pre-filter query. I want to filter the list so that only specific values for an element appear. The full element name is tblServicesList2___Location and I want just those records where this field has a value of "Hull". I have tried
tblServicesList2___Location = 'Hull'
WHERE tblServicesList2___Location = 'Hull'
tblServicesList2___Location = "Hull"
but none of these filter the data. What am I going wrong ? Thanks.

 

[troester]

Where do you want to use this, in an URL? content plugin?
Don't use spaces, don't use quotes.
URL: &tblServicesList2___Location=Hull
content plugin: {fabrik view=list id=x tblServicesList2___Location=Hull}

http://fabrikar.com/forums/index.php?wiki/filtering-lists-tables/
http://fabrikar.com/forums/index.php?wiki/content-plugin/#embedding-lists

 

[peterk900]

Thanks very much for the explanation, the correct string and the links. I was using it in the content plugin.
Just before getting your reply I 'cheated' with the + symbol and a nice set of boxes popped up which worked immediately. But knowing how to hand code it is better. Thanks for your help on this.

 

[cheesegrits]

Just for completeness, if you need to use a space in a filter value in query string or plugin, use %20, like list___location=New%20York

-- hugh

 

[peterk900]

Thanks hugh - saves another gotcha !