cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Setting parameter in XML query

Former Member

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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