To select field from xml file

[Former Member]

Hi all,

I need to fetch some fields from a table without using database. I am trying with XML query. I have converted an sql table into xml document.Now I want to select some

fields based on some condition ( Normally we do by "where clause" in SQL query ).Could any one tell me where should

I apply the filtration logic.

Thanks in advance

Best Regards

Rahul

[Former Member · Accepted solution]

Hi Rahul

Follow these steps

1) GO to Business logic Editor and and load this xml in

xml loader.

2) Go in logic part of editor and put generic sort

filter.Here you can filter your data as your need.

3) If you want to apply some condition also than you can

go for IF and WHERE type of actions that also exist

in logic editor.

Hope this will help you.

If you have further any query you can call me also on this no +91 9884581512.

With Regards

Ramshanker Upadhyay

[Former Member · Accepted solution]

A few other tips and techniques:

- You can use "input links" into the GenericSortFilter action to provide dynamic filtering and sorting rules

- You can also use xPath expressions to define filtering

- Rick

[Former Member]

Hi Rahul

Some easy way to do the same

step -1 - Load the XML file

step -2 - use repeater

step -3 - put a filter block

step -4 - define the expression

Rajeev