Please debug the function in the developers console in google chrome. Once you find how it works, you'll be able to find how to pass the parameter. Additionally, you can search for the examples with the global search trough all sources in the google developers console.

You can use the InsertQuery client-side. Here is a sample: 

var insert = Ext.create("Terrasoft.InsertQuery", {
	rootSchemaName: "UsrMyEntity"
});
 
insert.setParameterValue("UsrMyParentId", this.get("Id"), Terrasoft.DataValueType.GUID);
insert.setParameterValue("UsrMyDateProperty", new Date(), Terrasoft.DataValueType.DATE);
 
insert.execute(function() {
	// do any refreshing if needed here
}, this);

Ryan

Ryan Farley,

Great! this helps. Is there a way I can do bulk insertion of multiple records at 1 single time? Any documentation reference would be really helpful. 

Thank you

kumar,

To do any sort of insertions of multiple records, I would create a configuration service and call that instead from the client. It would be far more efficient that way.

Ryan

Ryan Farley,

Hi guys, that is helping me in another implementation. Is it also possible to use it as updateQuery?

Thanks.

Danilo Lage,

Yes, an UpateQuery is similar, see the following sample:

var update = Ext.create("Terrasoft.UpdateQuery", {
	rootSchemaName: "Contact"
});
 
update.filters.add("IdFilter", update.createColumnFilterWithParameter(
	Terrasoft.ComparisonType.EQUAL, "Contact", this.get("UsrContactId")));
 
update.setParameterValue("UsrSomeField", "value", Terrasoft.DataValueType.TEXT);
update.setParameterValue("UsrSomeId", someId, Terrasoft.DataValueType.GUID);
 
update.execute(function() {
	// do any needed refreshing here etc
}, this);

Ryan

Danilo Lage,

kumar,

Please see the following articles, there you can find instructions on building update, insert, delete and batch queries. 

https://academy.bpmonline.com/documents/technic-sdk/7-13/dataservice-ad…

https://academy.bpmonline.com/documents/technic-sdk/7-13/dataservice-up…

https://academy.bpmonline.com/documents/technic-sdk/7-13/dataservice-ba…

https://academy.bpmonline.com/documents/technic-sdk/7-13/creating-detai…

The examples are done using C# language in case you decide to create a web service. Also there is a JavaScript example. They are particularly the same in the syntax. There also you can find examples of cases using insert, update, delete and batch queries.

Hope you will find it helpful.

Regards,

Anastasia

Ryan Farley,

Thanks, Ryan!

Anastasia Botezat,

Great, Anastasia...

Use mixin   A good example of mixin allows add multi-currency field

Hello.

The mixin would indeed be a decent way to achieve the desired functionality.

Best regards,

Matt

In ActivitySectionV2 do it by analogy with this example

1) Create new filter near Owner and Date filters

{

    "operation": "insert",

    "parentName": "IsActiveFiltersContainer",

    "propertyName": "items",

    "name": "IsActiveCheckbox",

    "values": {

        "bindTo": "IsActive",

        "caption": "Активные",

        "controlConfig": {

            "className": "Terrasoft.CheckBoxEdit",

            "checkedchanged": {

                "bindTo": "onIsActiveCheckboxChecked"

            }

        }

    }

}

2)

getFilters: function () {

    var sectionFilters = this.callParent(arguments);

    this.setIsActiveFilter(sectionFilters);

    //this.setCommunicationFilter(sectionFilters);

    return sectionFilters;

},

setIsActiveFilter: function (filterCollection) {

    var isActive = this.get("IsActive");

    if (isActive) {

        if (!filterCollection.contains("IsActiveFilter")) {

            filterCollection.add("IsActiveFilter", this.Terrasoft.createColumnIsNullFilter("Account"));

        }

    } else {

        filterCollection.removeByKey("IsActiveFilter");

    }

},  

onIsActiveCheckboxChecked: function (value) {

                if (!this.get("IsSectionVisible")) {

                    return;

                }

                this.set("IsActive", value);

                this.sandbox.publish("FiltersChanged", null, [this.sandbox.id]);

                this.reloadGridData();

            },       

3)Add atribute "IsActive"

attributes: {

      "IsActive": {

          "dataValueType": this.Terrasoft.DataValueType.BOOLEAN,

          "type": this.Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,

           "value": true

            },

        }

}

Hello!

Please see a comment from Grigoriy above, this would help you implement your idea.

Matt

Dear Mohamad,

Please see the ESQ example below. The method can be triggered by the button click on th product page.

checkProductNumber: function() {
				var currentProduct = this.get("Id");
				var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "InvoiceProduct" });
				esq.addColumn("Product");
				esq.filters.add("Product", Terrasoft.createColumnFilterWithParameter(
					Terrasoft.ComparisonType.EQUAL, "Product", currentProduct));
				esq.getEntityCollection(function(response) {
					if (response && response.success) {
						var quantity = response.collection.collection.length;
						if (quantity > 0) {
							var esq1 = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "InvoiceProduct" });
							esq1.addColumn("Id");
							esq1.getEntityCollection(function(result) {
								if (result && result.success) {
									var total = result.collection.collection.length;
									this.showInformationDialog(quantity / total);
								}
							}, this);
						} else {
							this.showInformationDialog("This product is not indicated in any invoice.");
						}
					}
				}, this);
			}

Hope you will find it helpful.

Regards, 

Anastasia

Hello, what you described is an object logic (validation) than can be both created and deleted with code only by a skilled developer.

In many cases our customers implement similar logic purposefully.

If you need our help in resolving this case, please, let us know. 

Dear Romadan,

Not all queries can be easily translated in a single DataService request. In the most complex cases consider refactoring a query into few smaller queries and sending them one by one storing the result from first query and passing it as a parameter to the next query. 

Hi,

There is good description here how to write such queries. When reading pay attention to "Adding columns to query" section there. You can not only use aggregation in queries but also can use aggregation in filters

Please investigate how to work with ESQ

https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entitysche…

Then check the article by the link below. It shows how to select aggregate data.

https://community.bpmonline.com/questions/esq-query-find-role

Then check the next article. There you'll find how to fill in a lookup value. 

https://community.bpmonline.com/questions/update-query-change-lookup-va…

If you want to set a text or integer value, you need to use the following syntax:

this.set("fieldname", value); in a replacing client module.

Please find more information about modules in the article by the link below.

https://academy.bpmonline.com/documents/technic-sdk/7-11/adding-calcula…

It should be something like this

var userConnection = Get<UserConnection>("UserConnection");

var activityQuery = new EntitySchemaQuery(userConnection.EntitySchemaManager,"Activity");

activityQuery.AddAllSchemaColumns();

var activityId = new Guid("0afe839a-ff8c-4543-a7b8-29e4aab9787a");

var filter = activityQuery.CreateFilterWithParameters(FilterComparisonType.Equal, "Id", activityId);

activityQuery.Filters.Add(filter);

var activityEntities = activityQuery.GetEntityCollection(userConnection);

foreach (var activityEntity in activityEntities)

{

    var titleColumnCaption = activityEntity.Schema.Columns.GetByName("Title").Caption.Value;

}

return true;

Eugene Podkovka, This is only for c#? is posible in javascript?

In JS columns are already loaded. You can get access to the columns in the following way.

https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entitysche…