Question

Get Id in BatchQuery

22:43 Nov 01, 2017

Hello community!!

I need construct a batchquery but in one column is necesary constuct a string with the id of the object. How can call the id object in the insert?

var insert = Ext.create("Terrasoft.InsertQuery", {
		                        rootSchemaName: "Entity"
			                    });
insert.setParameterValue("EmailURL", "?entityid=" + //Need put the Id of object Entity//, this.Terrasoft.DataValueType.TEXT);
 
bq.add(insert);

2 comments

Anastasia Botezat

13:48 Nov 10, 2017

Dear Federico,

In order to use the Id of the entity you created, you need to specify this ID before creation.

You can generate new Id by using Terrasoft.generateGUID() method:

var newGuid = Terrasoft.generateGUID();
var insert = Ext.create("Terrasoft.InsertQuery", {
   rootSchemaName: "Entity"
});
insert.setParameterValue("Id", newGuid, Terrasoft.DataValueType.GUID);
insert.setParameterValue("EmailURL", "?entityid=" + newGuid, this.Terrasoft.DataValueType.TEXT);
 
bq.add(insert);

Regards,

Anastasia

Solem Khan Abdusalam

06:58 Mar 19, 2021

Anastasia Botezat,

Is there a way to do Terrasoft.generateGUID(); in server side web service?

Show all comments