Changes

Pandora Filter Examples

253 bytes added, 21:12, 28 August 2013

no edit summary

* This filter will look for Level 3s attached to the current level 2 with a value from the variable "exType" in the custom field 1301787:

grs=levelonecontact_find(false,"",103069,@opportunityid@,fields,"opr.contactid=@me.userid@","",0,1);

var od=grs.getfieldbyname(1,'oprid');

<pre>

var fields="opportunityid,opportunitytype,cf_1329697,cf_1324714";

var filter="opportunitytype=11406 and tbl_1329697.valuestr!='' and tbl_1329697.valuestr not like '%-Done!%'";

var rs=levelone_find(false,"",appid,fields,filter,"",0,500,"");

</pre>

===Escaping Apostrophes===

0

edits