Hi Community,

 

In client code, How i can retrieve the html div id of each row of grid section data?

Like 0

Like

3 comments

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

Show all comments
delete
order
7.11
account
audit
order_delete
Studio_Creatio

Hi Team, 

 

Is there a way to keep a track of activities like who has deleted the order, invoices and accounts. How can we find who has deleted/edited the orders/accounts/invoices etc? Please let me know if there is any way to do it?

 

Thanks,

Gokul

Like 0

Like

2 comments

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

Show all comments
mobile application
7.15_()
Studio_Creatio_()
7.15
Studio_Creatio

Hi Community,

In mobile grid view, we are showing a date/time field, we want to change the format of Date/Time. Anyone, please guide me to do this.

Like 0

Like

3 comments

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.

Show all comments
oData
7.15_()
Studio_Creatio_()

Dear mates,

I m building an external form which must insert/update an object collection with oData.

GET - POST and DELETE works fine

But if i want to update (PUT), i ve got the following error: the item is not found

{"error":{"code":"1","message":{"lang":"","value":"L'\u00e9l\u00e9ment UsrExternalisation est

    introuvable
."},"innererror":{"message":"L'\u00e9l\u00e9ment UsrExternalisation est

    introuvable
.","type":"Terrasoft.Common.ItemNotFoundException","stacktrace":" at

    Terrasoft.Core.Entities.Services.EntityLazyProxy.<>c__DisplayClass28_0....

My PUT function works fine in other object update.

Do you have an idea why this error occurs ?

Thanks,

Nicolas

Like 0

Like

2 comments

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

Show all comments
7.15_()
Studio_Creatio_()

After migration from version 7.12 to 7.15 one of our processes throw such exception (in subject).

when i click save system wants to publish script tasks i click publish get message compilation succesfully but its does not help

 

Regards

Tomek

Like 0

Like

4 comments

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?

Show all comments
7.15_()
Studio_Creatio_()

Hi;

I have a simply question.

how can I create a new version of process if i don't have any running instance of it?

 

regards

Tomek

Like 0

Like

1 comments

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 

Show all comments
7.15_()
Studio_Creatio_()

Hi;

Can we in easy way block changing column setup for details for some users?

I try deny add records to User profile but it doesn't work

Regards

Tomek

Like 0

Like

4 comments

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

Show all comments
ESQ
7.15_()
Studio_Creatio_()

Hi Community,

I need to have a validation on my edit page and this validation will involve complex sql query, now please help me how i can convert below sql query in esq client side.

The query below involves some joins and group by function

select a.Table2Id, b.Name, a.CreatedOn from Table1 a 

inner join Table2 b on a.Table2Id = b.Id 

join ( 

select b.Name as Name, Max(a.CreatedOn) as CreatedOn from Table1 a 

inner join Table2 b on a.Table2Id = b.Id  

group by b.Name ) 

c on c.Name = b.Name and c.CreatedOn = a.CreatedOn

 

Like 0

Like

5 comments

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

Show all comments
satisfaction_survey
7.15_()
Studio_Creatio_()

Hi Community,

How I can customize the OOB satisfaction survey page, Aside from Comments field, I need to add some more fields from Case object into it.

Like 0

Like

2 comments

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

Show all comments
maps
7.15_()
Studio_Creatio_()

Hi Community,

I have a scenario below, that we want to apply on the mobile app

1. On Case edit page there will be a link to open a map

2. On the map user can move a pin to indicate his current location.

3. Capture the location(long/lat) based on the location of the pin

Any idea how I can implement above scenarios?

 

 

Like 0

Like

3 comments

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. 

Show all comments