Oracle PeopleSoft Notes

3 way Prompts In this way user can able to run the query either by giving value or giving prompt value or some part of the value. To do so we need to, Create the Expression Create a Prompt Add criteria with Expression and Prompt Change logical mapping Group the criteria Initial Query Create the Expression Create the Expression like below and in the Express Text give only <single quote> <space> <singlequote> Create a Prompt Create a Prompt for the Field where u need a Prompt while running the Query Please note that here the Prompt Table been mentioned with “No Table Edit” as Edit Type Add criteria with Expression and Prompt While adding criteria first select the Expression and Condition Type should be equal to and then select the Prompt which you created earlier. Add other Criteria like below Make sure here the Condition Type should...

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