Query XML File using parameters

[Former Member]

I have an XML file that is created from an XMII service. I am writing a BLT that accepts parameters from the UI, filters the XML, changes the XML format and returns the new XML to the client for Display.

My question deals with the best way to query/filter and XML file. Currently I am using an XML query and then using a repeater and Xpath to narrow down the data.

Is there a better way to do this? I notice parameters in the XML query template, but according to the help docs, it looks like this is to change the format to match XMII's rowset/rowset/row format

thanks in advance,

Jeff

[Former Member · Accepted solution]

How about the Generic Sort/Filter action?

[Former Member · Accepted solution]

I tried the generic sort/filter and set the filter options using an assignment block(used an assignment block because the conditions are dynamic) It worked when I had one filter condition, but I couldn't find a way to enter multiple conditions using an "or". The only options I see are Column, condition, value and type. How do I set whether or not the filter conditions are "ands" or "ors"

also, is it possible to make a litle more complex queires such as

(FieldA = 1 and Fieldb = 2 ) or (FieldA = 5 and Fieldb = 10)

as always, thanks for the help

Jeff

[Former Member · Accepted solution]

Here's a good trick for getting around that, Jeff...

You can use a calculated columns action with an integer or boolean column that includes a complex expression such as:

( (X > 55) or (B < 133) ) and (stringleft(Thing,1) == "C")

You can then filter on the calculated column being true or false...

- Rick

[Former Member · Accepted solution]

I never would of though of that, I'll give it a shot

thanks for the help

Jeff