Question Re: Create new ticket from Fragments in Technology Q&A

Create new ticket from Fragments

Former Member — Tue, 27 Sep 2016 14:02:17 GMT

Hi Experts,

My requirement is to create new ticket fetching details from fragments. I have odata table with single select option. On clicking a row and clicking the "Create Ticket" button a fragment will be displayed with the data of the row as below

On clicking the "Submit" button in the fragment I should be create new ticket with the data. I tried the below code to implement the create functionality.


submitticket: function(oEvent) {
var a = this.getView().byId("idibaseTable");
  var oBindingContext = a.getSelectedItem().getBindingContext();
  var service = this.getView().byId("idibaseTable").getModel().getProperty(oBindingContext.getPath());
  var oEntry = this.getView().byId("idibaseTable").getModel().getProperty(oBindingContext.getPath());
  oEntry.type = service.ProcessingTypeCodeText;
  oEntry.SerialID = service.SerialID;
  oEntry.ServicePriorityCodeText = service.ServicePriorityCodeText;
  oEntry.ProductID = service.ProductID;
  oEntry.CustomerID = service.CustomerID;
  oEntry.WarrantyFrom = service.WarrantyFrom;
  oEntry.WarrantyTo = service.WarrantyTo;
  // var oModel = new sap.ui.model.odata.ODataModel("/sap/c4c/odata/v1/c4codata/");
  var oModel = this.getView().getModel("ticketCreate");
  // this.getView().setModel(oModel);
  console.log("model", oModel);
  oModel.create("/ServiceRequestCollection", oEntry, null, function() {
  var msg = "New Service Ticket has been created successfully.";
  MessageBox.show(msg);
  });
  },

I am facing an error here saying "oModel.create is not a function". Please provide suggestions on how this can be implemented.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

saurabh_vakil — Wed, 28 Sep 2016 09:22:10 GMT

On line 14 where you are fetching the "ticketCreate" model and storing in the oModel variable, check in debugging whether actually the ticketCreate model is getting returned. If for some reason the ticketCreate model reference is not getting fetched then the oModel would hold nothing and hence the error message "oModel.create is not a function".

Re: Create new ticket from Fragments

Former Member — Wed, 28 Sep 2016 10:59:44 GMT

Hi Saurabh,

Thank you for the reply. I am getting the required data in the "ticketCreate" model.

The checked console for the reference.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Wed, 28 Sep 2016 12:58:33 GMT

In I see,

You want to use create method in json model.JSON Model has not method create.

ODataModel has own create method.Comment 14 line instead of 13.

Re: Create new ticket from Fragments

Former Member — Wed, 28 Sep 2016 15:39:41 GMT

Hi Yalcin,

I tried your suggestion. Got the error "2016-09-28 20:59:06.225100 The following problem occurred: HTTP request failed400,Bad Request,<?xml version="1.0" encoding="utf-8"?><error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>00145E5B1CC71EE0AB8B3A3B086F432E</code><message xml:lang="en">The Data Services Request could not be understood due to malformed syntax</message></error> -" in the console.

I have the below code in my OnInit()

var oModelTicket = new JSONModel();

this.getView().setModel(oModelTicket, "ticketCreate");

Would that be the reason for the error?

Please advice.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 10:11:06 GMT

Hi Experts,

Any suggestions regarding the issue would be very helpful.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 10:50:20 GMT

Hi,

Look at /iwfnd/error_log.

And Also

change ServiceRequestCollection to ServiceRequestCollectionSet

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:04:18 GMT

Hi,

I tried /iwfnd/error_log in the console and got the error "Invalid regular expression flags".

Further I also changed my EntitySet name as you suggested. Still facing the same issue.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:08:34 GMT

Hi Srinivasan,

Firstly, the create method is applicable only for oDataModel and not for JSONModel. If you have defined the ticketCreate model in the init method, I would suggest, create a new oData Model with the service URL. (Line 13).

Secondly the data that needs to be passed in create needs to be JSON object. So comment line 5 and define oEntry as oEntry = {}. Build the oEntry exactly as the service is expecting with all the properties needed.

Thanks,

Esha.

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:19:55 GMT

Hi Esha,

Thank you for your suggestion. As you have suggested I have created a new oDataModel with service url as in line 13 and have also kept oEntry = {} commenting line 5.

I am getting the error

"sap-ui-core.js:160 2016-09-29 16:43:04.400689 The following problem occurred: HTTP request failed400,Bad Request,<?xml version="1.0" encoding="utf-8"?><error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>00145E5B1CC71EE0AB8B3A3B086F432E</code><message xml:lang="en">The Data Services Request could not be understood due to malformed syntax</message></error> -"

I am building the oEntry using the code


var service = this.getView().byId("idibaseTable").getModel().getProperty(oBindingContext.getPath());
oEntry.type = service.ProcessingTypeCodeText;
  oEntry.SerialID = service.SerialID;
  oEntry.ServicePriorityCodeText = service.ServicePriorityCodeText;
  oEntry.ProductID = service.ProductID;
  oEntry.CustomerID = service.CustomerID;
  oEntry.WarrantyFrom = service.WarrantyFrom;
  oEntry.WarrantyTo = service.WarrantyTo;

Hope this is the correct procedure.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:27:13 GMT

Can you check the value of oEntry in debugger and share that.

Thanks,

Esha.

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:34:28 GMT

Hi,

The entry array from the console.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:40:50 GMT

Can you pass the date fields in oData date format. The screenshot shows they are getting passed as string.

For test purpose use new Date() function to create the dates.

Thanks,

Esha Ailani.

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:44:28 GMT

I will be using formatter() to display the dates properly. Apart from the date should I be doing anything additional.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 11:48:36 GMT

Hi,

Entry not be array.

Use entry[0] directly.

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 13:01:45 GMT

Hi Yalcin,

Still the error persists.

Thanks,

Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 13:13:41 GMT

Hi,

Please send controller all code and also add picture of entry values and also /iwfnd/error_log picture.

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 13:27:40 GMT

Hi,

I have attached the controller code(IbaseDetail_controller.txt) with this message.

Also attaching the image for entry and /iwfnd/error_log below

Thanks,
Srinivasan

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 13:44:22 GMT

Hi,

The format of the data that is passed should match the format the service is expecting it.

So check the metadata for the service, all the properties should have the correct format. Strings should be passed as Strings, interger as interger and date as dates.

Please use this for the date fields for testing

oEntry.WarrantyFrom = new Date();

oEntry.WarrantyTo = new Date();

Also remove the oEntry[0] and just keep as oEntry in the create call(if oEntry is not an array).

If error exists, share the metadata also.

Thanks,

Esha Ailani.

Re: Create new ticket from Fragments

Former Member — Thu, 29 Sep 2016 13:53:48 GMT

Hi,

Change /ServiceRequestCollection to /ServiceRequestCollectionSet.

Try this.