var ceArray = ArrayNew(1); var retDataPageID = 0; if ( LEN(TRIM(arguments.elementName)) ) ceArray = application.ptPortlet.ceData.getCEData(TRIM(arguments.elementName),TRIM(arguments.idfieldname),TRIM(arguments.idfieldvalue)); if ( ArrayLen(ceArray) ) { for (i=1;i LTE ArrayLen(ceArray); i=i+1) { if ( ceArray[i].PageID GT 0 ) { retDataPageID = ceArray[i].PageID; break; } } } var ceArray = ArrayNew(1); var retQuery = QueryNew("temp"); var temp = ""; ceArray = application.ADF.ceData.getCEData("PortletPodInstance"); if ( ArrayLen(ceArray) ) { columnlist = ArrayToList(StructKeyArray(ceArray[1].values)); //columnlist = ListPrepend(columnlist,"datapageid"); //Application.ptPortlet.utils.dodump(columnlist,"columnlist",0); retQuery = QueryNew("datapageid," & columnlist); for (i=1;i LTE ArrayLen(ceArray); i=i+1) { temp = QueryAddRow(retQuery); temp = QuerySetCell(retQuery, "datapageid", ceArray[i].pageid); for (c=1;c LTE ListLen(columnlist); c=c+1) { temp = QuerySetCell(retQuery, ListGetAt(columnlist,c), ceArray[i].values[ListGetAt(columnlist,c)]); } } } Application.ptPortlet.utils.dodump(retQuery,"retQuery",0);