Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Use parameter in Select Component

Question
Guillaume Lepretre · Oct 18, 2018

Use parameter in Select Component

Hello everyone,

I want to fill data into my select component with sql request and parameter.

I tried to follow this example https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY... 

I need to call a method because my parameter can be different. I tried something like this but it doesn't work... 

 ClientMethod changeParams() [ Language = javascript ]
{


var query = zenPage.getComponentById('categorieBeneficiaire');
query.setProperty('parameter', 1, 'OS');
query.setProperty('parameter', 2, 'NSAL');
}

or like this : 

 ClientMethod changeParams() [ Language = javascript ]
{


var query = zenPage.getComponentById('categorieBeneficiaire');
var param1 = zenPage.getComponentById('catBParam1');
var param2 = zenPage.getComponentById('catBParam2');


param1.value='OS';
param2.value='NSAL';
    query.executeQuery();
}

You can see my select here : 

 <select id="categorieBeneficiaire" label="Catégorie bénéficiaire " sql="SELECT row FROM mytable where cond = ? and cond2= ?" required="true" >
    <parameter id="catBParam1" />
    <parameter id="catBParam2" />
</select>
#Caché #SQL #ZEN

Source URL:https://community.intersystems.com/post/use-parameter-select-component