AnsweredAssumed Answered

PDM_LIST Query

Question asked by Balram.Deswal on Jun 8, 2015
Latest reply on Jun 8, 2015 by Gutis

Hi Team,

 

I am using PDM_LIST in the following manner:

<PDM_LIST PREFIX=ci WHERE="id > 0" FACTORY=loc>

 

Now according to the condition given, it will always fetch all the records from the database. Due to this, my page has gone slow.

 

I am accesing the selected site in a variable as shown:

var site_value=document.main_form.elements["SET.zsitelookup"].value;


Now my concern is that I want to change the condition in the PDM_LIST to fetch only those records, where the site id is equal to the value stored in the site_value variable. I want to change the condition WHERE="id > 0" to something like WHERE="site = site_value". Please tell me the syntax for this.


Regards,

Balram

Outcomes