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
compile
install package
7.15_()
Studio_Creatio_()

Hi Community,

Is it recommended to "Compile All" items in configuration after package installation? Or a compile modified items is already enough? Why I am asking is that "Compile All" items is taking too much time to finish. 

Like 0

Like

1 comments

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. 

Show all comments
7.14_()
Studio_Creatio_()

Hello Team

please Guide me 

how to do attachment* as mandatory field

kindly let me know the process .hoping for a positive reply

regards,

uttej.

 

Like 0

Like

9 comments

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?

Show all comments