If you're not able to come up with an ESQ solution for this (I've never tried a groupby with ESQ, not sure if it can do those - nothing mentioned in the docs), often when I have a complex SQL statement, I instead put it in an configuration web service and do the query using the Select class or a direct SQL statement, then call/consume the service from the client side code.

If you go that route, here's some articles on those topics:

Select class: https://academy.creatio.com/documents/technic-sdk/7-15/retrieving-infor…

Direct SQL: https://customerfx.com/article/executing-direct-sql-statements-in-a-pro…

Creating and calling configuration services: https://customerfx.com/article/creating-a-web-service-and-consuming-it-…

Ryan

I'm not 100% on that, but I'm fairly sure that you can use an aggregration column for the nested SQL statement, which handles the group by for you. You could then run the first 2 lines as a separate ESQ inside the first ESQ callback, and then do the rest of the logic separately in JS.

Dear Fulgen, 

Unfortunately, there is no way to create a complex query with subqueries via client ESQ.

You can create a business process that will perform the request to the database, fetch all needed data, process it and display it on the page.

Hi Ryan Farley,



When using CustomQuery, what library should I declare? I am getting "The type or namespace name CustomQuery could not be fould".



Thank you

Fulgen Ninofranco,

CustomQuery is located in Terrasoft.Core.DB

Ryan

Hi Community, Any Idea? Thanks

Dear Fulgen,

Please create a replacing client module for the “CaseRatingFeedbackPage” schema and modify the “diff” property. Please find more information about the “diff” property in the article by the link below:

https://academy.creatio.com/documents/technic-sdk/7-15/diff-array

Best regards,

Norton

Dear Fulgen,

You can inspect the Account address detail as an example of integration with OpenStreetMaps in the system and Field Force application as an example of maps functionality on mobile apps. 

Best regards,

Angela

Angela Reyes,

Thanks Angela, I tried in Account address detail, by clicking it map is opening, what I need is that user should be able to pin location on the map, then will capture the coordinates(long/lat) and save it back in case edit page in mobile. Do you have any sample for this.

Fulgen Ninofranco,

Try checking Field Force application as well as it contains map for mobile application. Unfortunately we do not have any example of such customisation. 

Dear Fulgen, 

The compilation is not required after the package installation. However, if you install packages via configuration section, I would recommend to compile the system afterwards. 

Hi,

as Attachments is not a field, but is a detail, you can do the following validation script (sample for Activities) in object process for Validating message

UserConnection userConnection = context.UserConnection;
 
   Select select = (Select)new Select(userConnection)
            .Column(Func.Count("Id"))
            .From("ActivityFile")
            .Where("ActivityId").IsEqual(Core.DB.Column.Parameter(Entity.Id));
       
if (select.ExecuteScalar<int>() == 0)
            throw new Exception("Attachment is required");
 
return true;

Vladimir Sokolov,

Hello Vladimir Sokolov,

Thank you for your reply uttej

could you please tell me clearly 

for which page this code belongs to and where it is write in  (diff or methods)  detail page or card schema page or section page or detailpagev2

please give me  detail explanation about code

hope you reply soon 

with positive response  

regards;

uttejyadala

Hi, this is not Page Code.



You should add process in your Object "UsrAligment"

Hello,

Unfortunately, there is no option to make the fields as required in the attachments detail without code. Technically it is possible to enable the Required attribute for the detail fields but you will not be able to attach the file itself. It will fail with errors.

Regards,

Dean

Hello Vladimir,

Could you please specify where exactly we need to write the validation script provided.



Do we need to create process with validation message as signal?

Hello,

You are right, you need to create a process with the validation message as a signal. You can do it by clicking the "Open Process" button in the object configuration. The start signal in this case would be "AccountValidating".

Dmytro Vovchenko,

 

I'm not able to drag any business process element in the object process

Amritha Mayan Gorky,

I suggest you contact our support team directly with this specific issue at support@creatio.com.

Hi,Vladimir Sokolov,

Isn't there another way to make the attachment file mandatory through validation of the form page and not by placing a condition on the table in the database that I want in the form page?

I have the same exact issue -- can someone assist with this asap please?

Dear Fulgen,

If email is sent automatically via business process it will not create activity. You can either send it manually or use script task to send email and create activity. 

Best regards,

Angela 

Angela Reyes,

Thanks Angela,

Then how I can show it on Case Timeline?

Fulgen Ninofranco,

It will appear in timeline when it is connected to the record. To connect email to record it must be created firs. You can use Send email to case assignee as an example to examine how activities are created and connected to records via script task. 

Hello. Would really appreciate some help on this question

M Shrikanth,

1. There is no way to set the custom max length for a field from the Creatio GUI.

2. It's possible to set the custom max length for a field via development by creating a field validator. Please find the examples in the article on Academy:

https://academy.creatio.com/documents/technic-sdk/7-15/how-add-field-validation?_ga=2.27542716.1082264901.1584023961-1276886288.1584023961

3. The validation functionality must be developed in the mobile application separately. You need to create a custom business rule in the mobile for that. The guidelines can be found in the article on Academy:

https://academy.creatio.com/documents/technic-sdkmob/7-15/custom-business-rules-mobile-application

Hello

Creatio by default allows a user to choose between 50, 250 and 500 as max lengths of a Text column from the Object designer.

1. Is there a way to set this custom max length for that object from the Freedom UI?

Ahamed Rizlan,

Hello,

On the object level it's not possible however field validator can be used on the page where the field is added to ensure the value has a specific length and prevent saving when the field length is greater than some value. Here is an article regarding field validators in Freedom UI.

Dear Fulgen,

Hope you are doing well today.

The mobile application doesn't have this option. We already had similar requests from multiple users and our R&D team has in plans to implement the sorting option in the future application versions.

Best regards,

Dean

Dean Parrett,

Thanks Dean, but programatically is there any way?

Dear Fulgen,

Yes, you can develop custom sorting function. You can try to debug the sorting feature in the web version and implement similar logic for mobile version.

Regards,

Dean