Question Re: To select field from xml file in Product Lifecycle Management Q&A

To select field from xml file

Former Member — Fri, 03 Nov 2006 08:34:20 GMT

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

Re: To select field from xml file

Former Member — Fri, 03 Nov 2006 12:46:09 GMT

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

Re: To select field from xml file

Former Member — Fri, 03 Nov 2006 18:53:25 GMT

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

Re: To select field from xml file

Former Member — Thu, 16 Nov 2006 06:07:26 GMT

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