General

Re: Filter a drop-down with more than 5 conditions (Xpath)

shniggens — Thu, 19 May 2011 18:20:28 GMT

You were right Barbara, that was the rule causing the problem. Thanks!

I created a column that totalled the different skill sets, and then just did a greater than on that number. Better workaround.

Re: Filter a drop-down with more than 5 conditions (Xpath)

Barbara Gunion — Wed, 18 May 2011 22:24:23 GMT

I think I would separate them into their own filters - at least for troubleshooting. This one might be causing the problem because you have and 'and' and 2 'or's. xdXDocument:get-DOM()/my:myFields/my:SkillSet = "Breakouts" and d:Lighting >= 40 or d:Audio >= 40 or d:Video >= 40

Re: Filter a drop-down with more than 5 conditions (Xpath)

shniggens — Wed, 18 May 2011 21:14:17 GMT

In my above scenario, it displays the person if ANY ONE of the Skillset fields is above 75. So if I pick "Audio" in my dropdown, it displays a person who might have "75" or greater in their "Lighting" field.

Filter a drop-down with more than 5 conditions (Xpath)

shniggens — Wed, 18 May 2011 18:56:47 GMT

I have a drop - down list box that gets entries from a secondary data source that I need to filter more than 5 conditions on. I've tried using Xpath in an expression, but it doesn't seem to be seperating the arguments. All of the arguments have 2 conditions, IE, field needs to = text, AND @field = >number. Here's how I tried to do it -

xdXDocument:get-DOM()/my:myFields/my:SkillSet = "Lighting" and d:Lighting >= 75 or

xdXDocument:get-DOM()/my:myFields/my:SkillSet = "Audio" and d:Audio >= 75 or

xdXDocument:get-DOM()/my:myFields/my:SkillSet = "Video" and d:Video >= 75 or

xdXDocument:get-DOM()/my:myFields/my:SkillSet = "IT" and d:IT >= 75 or

(xdXDocument:get-DOM()/my:myFields/my:SkillSet = "Breakouts" and d:Lighting >= 40 or d:Audio >= 40 or d:Video >= 40) or

or xdXDocument:get-DOM()/my:myFields/my:SkillSet = "Neck-Down"

Is this the correct way to string them together?