AnsweredAssumed Answered

How to query database from .htmpl forms

Question asked by Balram.Deswal on May 7, 2015
Latest reply on Jul 20, 2015 by William Teixeira

Hi Team,


I would like to know whether it is possible to fetch the database query results in .htmpl forms. For instance, I want to run the following query:

Select location_uuid from ca_owned_resource where own_resource_uuid=0x66BDC4C8C8D71B43A61970660FF0CD0A;

And store the value of location_uuid in a javascript variable. Using this variable, I want to further query the database for the location_name associated with this location_uuid using the query:

Select location_name from ca_location where location_uuid=0xF3348F40F98EC24D8CB617B336338143;

Then I want to populate this location name in a drop-down. I am able to fetch the own_resource_uuid in a javascript variable in detail_in.htmpl.

If not possible, kindly suggest me some alternative ways by which I can implement this thing.


Thanks & Regards,

Balram Singh Deswal