cancel
Showing results for 
Search instead for 
Did you mean: 

Setting parameter in XML query

Former Member
0 Kudos

hi all,

how to use [Param.1] in XML query template?

-murali

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

in the parameter tab u can directly give the parameter value it will be taken as the first parameter. if u want to pass that parameter just give param.i in the first line it will be taken a the parameter

regards,

shyam

Former Member
0 Kudos

shyam,

my source url in XML query is like "C:\Inetpub\wwwroot\test\testquery.xml" if i click the test button i got the full daa table. now i want to get datas above the certain ranges using parameter. please explain me how to use the param to retrive required datas?

-murali

Former Member
0 Kudos

hi murali,

in this case u have to use business logic transaction to filter the values,

do u want me to explain that..

regards

shyam

Former Member
0 Kudos

hi shyam,

i want to dynamicaly change the data range value from UI it is possible in BLS please explaine me

thanks

murali

Former Member
0 Kudos

using the business logic transaction the steps to be done are

1.use a query action block and map the xml query

2.use a generic sort filter and right click the action block

3,in the configure u can enter the column name and condition that u want to display

4.excute the transaction using xcute query

regards

shyam

Former Member
0 Kudos

shyam,

it is give only some fixed output, i want to change the limit dynamically, so give any idia to set param in XML query templete

murali

Former Member
0 Kudos

ya u can dynamically pass the values to business logic transaction

these are the steps

1.add a xml query action block and in the links map the input to the param.1 and param.2 etc...

2.now from the out going link of the query action block map it to the incoming of the generic sort filter

3.in that give the conditions for filtring

regards shyam