Job Aid to Replicate an Operator from Another Report

JOB AID TO REPLICATE AN OPERATOR FROM ANOTHER REPORT

Scenario: You want to print this output on a report: 9 of 10 enrolled, 0 waitlisted or Full, 2 waitlisted

You find thatin the days of legacy reporting, Plateau retrieved this result by using the select statement:

pkg_enrollment.localized_enrollment_status(a.SCHD_ID) as stud_enroll_status

You try that. But the result is: label.EnrollmentStatus.PartialEnrollmentWaitlisted||||10||||9||||0||||2

Or if any user is Pending: label.EnrollmentStatus.PartialEnrollmentWaitlistedPending||||12||||4||||1||||1

Explanation:The older version used a Plateau operatorat run time to decode this string. You can use the same operator in the new PRD. Or you can find an operator in any existing report and use it in YOUR report.

Detective Work – Locate the Existing PRD Report or Legacy Report

Locate and analyze an existing report for clues.

You can use this BLOB query to track down any report that usesa given string. In this case, use'pkg_enrollment'. You can use this search for a legacy report or a report that has Plateau has converted into PRD:

SELECT report_name, report_id, definition

FROM PA_REPORT

WHERE dbms_lob.INSTR(definition, utl_raw.cast_to_raw('pkg_enrollment'),1,1) > 0;

You will find a list of one or more reports. Onewill be the RegistrationStatus legacy report.Now you can research thedefinition field where the XML is stored as a BLOB. This is true for legacy reports AND for PRD reports.

NOTES: A non-hosted customer has direct access to the database, so can use this queryto find the BLOB. If you use SQL Developer, you can access the BLOB field directly from the output. Double-click on the BLOB field or click the Edit icon (ellipsis or pencil, depending on version). This opens the BLOB Edit Value window. Select the Text button and Text tab to view the BLOB contents.

TIP:You can map an application such as TextPad so that clicking the External Editor button opens your application. Select the Helpbutton from this screen for instructions.

A hosted customer can click here to download a rptdesign file with the BLOB search as a data set.

If the report has been converted to PRD, you can go to the Plateau application and download the file, then open it in PRD.

If the report has NOT been converted to PRD, you can copy the entire XML from the BLOB field and paste it into TextPad or other editor to continue the research. You will be looking for the elements of this report that you can re-use in a PRD report.

Click here to download a job aid on tips for analyzing a legacy report for re-use in PRD.

Detective Work – Research the Existing PRD Report or XML if Legacy Report

Step 1: Find the Query

Now you need to find the query in the report that uses the pkg_enrollment package. Search for this string and you will find:

Step 2: Test the Query

Run the query and you will find output such as this for the stud_enroll_status field:

Step 3: Analyze the Output

You realize that Plateau must have used an operator to parse the results. Reading the sample output, you deduce this syntax:

max registration |||| current enrolled |||| number waitlisted|||| number pending

You can check the XML in the legacy report by searching for “operator” and find this

Or look up the operator in the Reporting Framework document.

Click here to download a document with operators used by Plateau. You will see this listing:

The “ref-ids = stud_enroll_status” tells you that the operator only needs only this stud_enroll_status field as input. The stud_enroll_status field needs to be retrieved in one of the data sets in the PRD report.The operator document suggests that you include this select statement to retrieve the field: pkg_enrollment.localized_enrollment_status(s.SCHD_ID) as stud_enroll_status

Retrievethe Field(s) in a Data Set

You can create a new data set in an existing report to use this query. Or edit an existing data set.

Insert the Field and Use the Operator

Click here to download a CSV version of this report to see one solution, shown below.

The report designer added a text field for registration status and used the above operator, following steps in the PRD job aid on operator fundamentals (click here to download).

Replicate an Operator from Another ReportPage 1Knowledge Services Organization