Hi Jose,



You can select * from RuleRelationSections and see how the fields look.



You need the Name (capitalized) of the custom section you want to add and the Uid of this section from SysSchema table.



So the script should look like this:



insert into RuleRelationSections (Name,SectionSchemaUId) values ('name of the object capitalized','UID of the custom object from SysSchema')



Thank you.

Thanks Bohdan! I follow your instructions and it worked as I need it.

Hello Bohdan Zdor, 

Where we can get RuleRelationSections? and where to put the query?

Thanks in Advance

Hi Shrey Soni,



You can find RuleRelationSections as the object in advanced settings of your instance.



You can put the query using SQL Executor (https://marketplace.creatio.com/app/sql-executor-creatio)

if your instance is the cloud one.



In case you have an on-site SQL installation of Creatio you can use your SQL Management Studio to put the queries.



Thank you for choosing Creatio!

Dear Shrikanth,

In order to store an object in Application cache you should serialize the object to string and save the string. Please find more information about serialization in the article by the link below:

https://stackoverflow.com/questions/2434534/serialize-an-object-to-string

Best regards,

Norton

Hello Fulgen,

This is an out-of-the box logic of our application so that IDs of elements on the page are generated randomly when refreshing the page. Currently there is no way to modify this logic since it is set in core application schemas and binary files of the application. We already have a problem registered to our R&D team so they could add some extra logic that allows static IDs of elements on the page (since request like that was asked to integrate Creatio application with PRA tools like UiPath).

The only possible way to achieve your task is to use data-item-marker since values there are static and doesn't modify after each refresh of the page. For example data-item-marker for global search window is "command-line".

Best regards,

Oscar

Oscar Dylan,

Thanks Oscar,



I just noticed like in Product Section data item marker is the product name, if there are duplicate product name data item marker will not be unique. Is there a way I can modify the data-item-marker of each row, i will give the guid of the record instead of the name? Please give me example how to do it. Thank you so much

Hello,

It is not possible to modify "data-item-marker" of the edit page (it is being generated) and we don't have a particular example of such an implementation. 

Best regards,

Oscar

Dear Gokul, 

You can enable a change log to track the modification/deletion of data. Here is an academy page on the change log: 

https://academy.creatio.com/documents/administration/7-15/change-log

Dennis Hudson,

Thank you

It's possible to set the correct date time format in user profile settings in Creatio that will be automatically applied to the mobile application too - https://i.imgur.com/luwba6x.png

Hi Alina (or others), I aware that this is a quite old post, but in the current Mobile app it doesn't seem to work. I have the date and time format in my Creatio app set to Dutch, which should mean DD/MM/YYYY for the date, yet it remains in format MM/DD/YYYY in the mobile app. I've also searched system settings in the browser app, but am not able to find anything useful. Is there any way to force this change in the Mobile app, as I can't seem to find it. Thanks

Hi Kurt,

unfortunately, there is no such option to change the date format, as for now.

We will register the task for our developers to add this functionality in the future.

Regards,

Gleb.

What does the URL look like that you're doing the PUT on? It needs to look like this (but obviously with the record Id instead of an empty Guid):

https://creatioaddress/0/ServiceModel/EntityDataService.svc/ContactCollection(guid'00000000-0000-0000-0000-000000000000')

Also, even though the docs specify a PUT for updates, it will also accept a PATCH (which is what I usually use)

Ryan

Hi Ryan,

I don't understand why my PUT calls work fine today without any modification on my side.

Here's the URL:

https://urltocreatio/0/ServiceModel/EntityDataService.svc/UsrExternalisationCollection(guid'b83bedb1-ad72-4c6a-9965-88677a13dfe1')

I see with my support team if they have modified something.

Thank you for the answer, have a nice day.

Nicolas

=>>>>

I had the problem one more time.

it was because i didn't compile the database new elements before to try my oData access

Hello Tomasz, 



Can you please try to compile all items on your website first and see if it helps? 



Kind regards,

Roman

Roman Brown,

unfortunately it didn't

regards

Tomek

Roman Brown,

I have the same issue now, I published the process separately, the package, and the entire system. nothing helps I still get this error

Any ideas?

the same problem, but in Creatio 8.0.6, created the source code, compile all but no way. any ideas?

Hi Tomek, 



Unfortunately, there is no such functionality in Creatio yet. 

The only way to create a new version of existing process is to save it when at least one instance of this process is running or new version cannot be saved in it's package (happens when a process has been imported as a part of some package into the system). 



We already have a proposition created for the responsible R&D team to implement functionality which would allow users to create a new versions of the process despite of conditions mentioned above.

I will pass this post to them so to increase the importance of it. 



Kind regards, 

Roman 

Dear Tomazs,

Unfortunately, there are no basic application tools to restrict the columns setup for users. Each user can set up the columns of a section as per his preferences and own convenience. This is the main point of columns settings. As a workaround, you can make changes for all users by clicking on the button 'Save for all users' in the column list setup http://prntscr.com/lrrfbr . This option is available for the users with the system administrator rights. Thus you can set up the columns view for all users, but they still will be able to change it.

Regards,

Dean

Dean Parrett,

thanks

Dean;

did you try to hide it in CSS?

Regards

Tomek

Dear Tomasz,

You can try to do it, but unfortunately we do not have any examples of such implementation.

Regards,

Dean

Dean Parrett,

Thanks

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