Where can I get all details on allowed formula systax and possible functions allowed to use For example I was working to extract month & year from date and it was not so easy to understand best function allowed in business process formulas windows.
Formulas are C#. Creatio does have a few built in functions that can be used in formulas, but for the most part, it's a better approach to just think of it as C#. For extracting the month and year from a date, you'd just use C# syntax for Year and Month. For example:
I am trying use AggregationType.Sum for in source code schema for my web service but its not summing the the totals as i wanted to do. It only sends the first records Amount rather than finding the all the records with that condition match and total them up. Can anyone direct me to documentation of implementing this?
var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "UsrExample");
var totalSum = esq.AddColumn("UsrTotal");
totalSum .SummaryType = AggregationType.Sum; // Set aggregation to sum
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