JavaScript tools.getDatabase
I tired to call the database in a HTML-Rule.
The Script language is JavaScript and i will always get an exception when i try to call a function with tools... (I tried also to import the publicAPI, but it doesn't work)
I need a solution to call the Database in Javascript and to put the result on the var Result
HTML-Rule
<script language="JavaScript">
switch (Action)
{
case "openCase" :
Database db = tools.getDatabase();
ClipboardPage lp = tools.createPage("Code-Pega-List", "");
lp.putString("pyMaxRecords", "1");
var aSQL = "select TEST as \"TEST\" from Table where Field = 'ABC'";
var Result = db.executeRDB(aSQL, lp);
...
break;
}
</script>
Vodafone DE
DE
The public API is for JAVA not Java Script. calls to the public API only work in Java steps on activities, Rule Utility Functions, etc. I do not think you have access to the public API via Java Script.
C3i
IN
Hi Despotj,
Did you try writing your java code in script lets '<% %>' ?. We need to include our java code in script lets in HTML rules, I hope.
Thanks,
Harsha A
Vodafone DE
DE
There are some libraries for java script, that maybe someone here can give us a reference.
- pega.u.d
- pega.util
- pega.util.Dom
This are accessible via Java Script. I have personally used "pega.u.d.reloadSection()" for example. But the full list of all the method available unfortunately I do not have
Unisys
AU
Use a custom control alogn with scriptlets to do this.
Create a control which is non-auto generated and write your code in the HTML tab of the control. The db logic should go into a scriptlet and fetch the required information from the server and use it in the javascript varaibles using script tags.
Beaware, writing non-auto controls is not recommended by Pega
Blue Rose Technologies GmbH
DE
Could you please explain your usecase better, so that we can guide you towards faster resolution.