Running Connected Query BIP / XMLP through Peoplecode / AE Process
Hi All, Most of us tend to find the Answer for this Question "How to I execute Connected Query XMLP report through Peoplecode or AE Peoplecode?" Here it is, what you are seeking for, import PSXP_RPTDEFNMANAGER:ReportDefn; import PT_CONQRS:QUERYITEMPROMPT:*; import PT_CONQRS:CONQRSMGR:*; Global string &BU, &Invoice; Local array of PT_CONQRS:QUERYITEMPROMPT &prompts; Local File &xmlFile; &reportDefinition = "XX_CONNQRY"; &connQueryName = "BI_INV_PRNT_CQRY_V1"; /* Start by creating the Connected Query Object */ &connQueryObject = create PT_CONQRS:CONQRSMGR("", &connQueryName); If Not (&connQueryObject.Open( False)) Then /* If it can't be opened, throw an error */ Error ("Failed to open Connected Query."); End-If; If Not (&connQueryObject.Validate()) Then /* Validate that all PSQueries within the Connected Query Exist */ Error ("Unable ...