Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 398 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Query is incorrect within our custom widget (Oracle B2C Service)

We are having an issue with our custom widget SolveCaseCreateNew and it looks like the issue is within the controller.php file. The user will select a support contact for either Parts Help Desk or from Parts Distribution Center to create an incident on our Customer Portal. If the user selects Parts Distribution Center to create an incident and it has been resolved/closed, the user has the option to create a new incident by clicking the button "Need Further Assistance" on the CP that will reference the closes incident number. A new incident is opened but not under the original path of Parts Distribution Center. Regardless if it is a Parts Help Desk or Parts Distribution Center, it will automatically direct the user to open a new incident under the Parts Help Desk no matter how the original incident was created.
Below is the temporarily code to find what the value of ‘Team’ which is showing up as blank. The query must be incorrect and perhaps the else statement is wrong as well.
Code (view.php)
<div id="rn_<?= $this->instanceID ?>_Label">
<p><b>Case # <?= $this->data['ReferenceNumber']?> has been closed.</b> If you need further assistance on this case, click the button below.</p>
<p><b>Team: <?= $this->data['Team']?></b></p>
<!--<p>If you need further assistance, please click the button below to open a reference case for Case # <?= $this->data['ReferenceNumber']?>.</p>-->
</div>
I believe the Query is the problem (snippet of code below), it is not pulling the correct path.
Code (controller.php):
$incidentQuery = "SELECT I.ReferenceNumber, I.StatusWithType.StatusType.LookupName, I.CustomFields.c.support_team FROM Incident AS I WHERE I.ID = " . $i_id;
CONTROLLER.PHP
VIEW.PHP