dynamicnode and where clause with array filters - Razor

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Francisco 21 posts 72 karma points

Mar 12, 2013 @ 03:46
0

DynamicNode and Where Clause with array filters.
I had a look at the DynamicNode Documentation particularly on the Where clause.

.Where("condition"[, valueIfTrue, valueIfFalse] )

Returns all items matching the given condition. For more details on queries and conditions, see the section below
```
@var ancestors = Model.Where("UmbracoNaviHide != @0", "True");

@var HomePage = Model.Where("NodeTypeAlias == @0 && Level == @1 || Name = @2", "HomePage", 0, "Home").First();
```
I have a razor view where I get a parameter from query string and then apply a filter using .Where. This parameter can be a single value, or can be a array. Ex: (?eventType=189 or ?eventType=188,189).

For a single value, the code is straight forward and works fine:
```
var types = HttpUtility.UrlDecode(Request.GetParameterOrDefault("eventType", ""));
var events = Model.Where("eventType.Equals(@0)", types);
```
However, when it is a array, I couldn't figure out how to solve this. The final result should something like:
```
var events = Model.Where("eventType.Equals(@0) || eventType.Equals(@1)", type1, type2);
```
But I don't have a type1, type 2. What I have is "types" which is an string like "188,189" that could be transformed in a string[] of {"188", "189"} using string.Split, but even though the arguments should be placed separetely as the example above.

Any ideas?

Thanks.
Copy Link
Brett Hadley 16 posts 36 karma points

Mar 12, 2013 @ 14:42
0
Just a suggestion... :)

Can't you check if types is an array or if it's .Length > 1?
```
(if types is an array or more than one)
{
events =Model.Where("eventType.Equals(@0) || eventType.Equals(@1)", type1, type2);
} 
else
{
events =Model.Where("eventType.Equals(@0)", types);
}
```
It's an idea :)
Copy Link
Francisco 21 posts 72 karma points

Mar 12, 2013 @ 22:13
0
Thank you for your suggestion Brett, but I don't have type1, type2, etc. I have only a array of type.

I noticed I'm interacting with DynamicNodeList instead of DynamicNode.

DynamicNodeList has a method ".Where" with this signature:
```
public IQueryable Where(string predicate, params object[] values)
```
If I use the code below, it works fine (returns 2 results):
```
events = events.Where("eventType == @0 || eventType == @1", 188, 189)
```
But if I use the following code, it does not work (returns no results).
```
events = events.Where("eventType == @0 || eventType == @1", new[] { 188, 189 });
```
However, it should work in the same way, according to C# documentation about params:

http://msdn.microsoft.com/en-us/library/w5zay9db(v=vs.71).aspx
Copy Link
Francisco 21 posts 72 karma points

Mar 13, 2013 @ 03:37
100
I ended up using this code:
```
events = events.Where("eventType == 188 || eventType == 189");
```
But I would prefer using placeholders.
Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?

DynamicNode and Where Clause with array filters.

.Where("condition"[, valueIfTrue, valueIfFalse] )