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

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

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

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

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

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

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

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

Hi Community,

How I can convert existing functional role as Portal Functional Role?

Like 0

Like

0 comments
Show all comments

I get an error while creating a package with clio:

Unhandled Exception: System.MissingMethodException: Constructor on type 'Clio.Command.ReferenceCommand' not found. 

 

Like 0

Like

1 comments

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

 

Show all comments