Can you check my code on the basis of two I am trying to update the values in esq but not able to do that.
Please let me know how we can do that.
I am not able to update the records on the basis of conditions I put.
methods: {
onEntityInitialized : function() {
this.callParent(arguments);
this.BudgetValidator();
},
BudgetValidator: function() {
var location=this.get("UsrLocation").displayValue;
var cat=this.get("UsrServiceCategory").displayValue;
var esq=this.Ext.create("Terrasoft.EntitySchemaQuery", {
rootSchemaName : "UsrBudget"});
esq.addColumn("UsrBudgetAmount");
esq.addColumn("UsrBudgetCode");
var esqFirstFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,"UsrCompany.Name",location);
var esqSecondFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,
"UsrServiceCategory.Name",cat);
esq.filters.logicalOperation = Terrasoft.LogicalOperatorType.AND;
esq.filters.add("esqFirstFilter",esqFirstFilter);
esq.filters.add("esqSecondFilter",esqSecondFilter);
esq.getEntityCollection(function(result){
if(!result.success){
this.showInformationDialog("Data query Error");
return;
}
if (result.collection.getByIndex(0)){
this.set("UsrIsBudgetedBudgetAmount",result.collection.getByIndex(0).get("UsrBudgetAmount"));
this.set("UsrBudgetCode",result.collection.getByIndex(0).get("UsrBudgetCode"));
}
else {
this.showInformationDialog("0");
}
},this);
},
Like
Dear Bhumika,
This code works fine on our side. Please contact Creatio support to check why the code is not working on your side - they will be able to help you.
Best regards,
Angela