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:
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.