1
349
Question Guillaume Lepretre · Oct 18, 2018

Use parameter in Select Component

#Caché #SQL #ZEN

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?KE…;

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>
Discussion (2)0
Log in or sign up to continue

Comments

Vitaliy Serdtsev · Oct 19, 2018

Try

<FONT COLOR="#000080">ClientMethod </FONT><FONT COLOR="#000000">changeParams() [ </FONT><FONT COLOR="#000080">Language </FONT><FONT COLOR="#000000">= javascript ]
{
  </FONT><FONT COLOR="#008080">var </FONT><FONT COLOR="#000000">query </FONT><FONT COLOR="#000080">= </FONT><FONT COLOR="#000000">zen(</FONT><FONT COLOR="#800000">'categorieBeneficiaire'</FONT><FONT COLOR="#000000">);
  </FONT><FONT COLOR="#008080">var </FONT><FONT COLOR="#000000">param1 </FONT><FONT COLOR="#000080">= </FONT><FONT COLOR="#000000">zen(</FONT><FONT COLOR="#800000">'catBParam1'</FONT><FONT COLOR="#000000">);
  </FONT><FONT COLOR="#008080">var </FONT><FONT COLOR="#000000">param2 </FONT><FONT COLOR="#000080">= </FONT><FONT COLOR="#000000">zen(</FONT><FONT COLOR="#800000">'catBParam2'</FONT><FONT COLOR="#000000">);


  param1.value</FONT><FONT COLOR="#000080">=</FONT><FONT COLOR="#800000">'OS'</FONT><FONT COLOR="#000000">;
  param2.value</FONT><FONT COLOR="#000080">=</FONT><FONT COLOR="#800000">'NSAL'</FONT><FONT COLOR="#000000">;
  query.refreshContents();
}</FONT>


<FONT COLOR="#000080">/// This client event, if present, is fired when the page is loaded.
ClientMethod </FONT><FONT COLOR="#000000">onloadHandler() [ </FONT><FONT COLOR="#000080">Language </FONT><FONT COLOR="#000000">= javascript ]
{
  zenPage.changeParams();
}</FONT>

0