Forum Stats

  • 3,855,322 Users
  • 2,264,499 Discussions
  • 7,905,968 Comments

Discussions

Query is incorrect within our custom widget (Oracle B2C Service)

User_R1YA6
User_R1YA6 Member Posts: 2 Green Ribbon
edited Mar 10, 2022 3:40PM in PHP

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