I have column in object called "Lead no" in format- "L_". I want to get the maximum value of integer value in the same through esq.
SQL query of something like this:
SELECT MAX(CAST(SUBSTRING("UsrName",3,length("UsrName")) AS DECIMAL)) FROM "UsrLead"
can someone help me on this?
Thanks
Like
Hi Gokul,
Here are some examples how you can implement it :
1. By using direct SQL queries
https://customerfx.com/article/executing-direct-sql-statements-in-a-pro…
2. By using "Select" class
https://academy.creatio.com/documents/technic-sdk/7-15/retrieving-infor…
3. By using client side logic (but modifying this code according to your business logic) example below
var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "Activity" });
esq.addColumn("Account.UsrINN", "AccountINN");
var column = esq.addColumn("ModifiedOn");
column.orderDirection = Terrasoft.OrderDirection.ASC;
esq.rowCount=1;
esq.filters.addItem(esq.createColumnFilterWithParameter(3, "Account.UsrINN", "7730616959"));
esq.getEntityCollection(function (result) {
if (result.success && result.collection.getCount() > 0) {
var item = result.collection.getByIndex(0);
var INN = item.get("AccountINN");
var modOn = item.get("ModifiedOn");
}
}, this);
P.S. Please refer the post below about ESQ access rights, that could be also useful for you
https://community.creatio.com/questions/access-issue-esq