I have a script that collects a data set using:

 

var oppProdQuery = new EntitySchemaQuery(UserConnection.EntitySchemaManager,"OpportunityProduct");



On publish, this is throwing an error:

 

'FlowEngine' is obsolete: '7.17.3 | Class is not in use and will be removed in upcoming releases. Use IProcessExecutor (UserConnection.ProcessEngine.ProcessExecutor) to start the processes.'

 

Can you advise how to fix?

Like 0

Like

1 comments

Hello everyone,

I would like to calculate sales KPI and show them in dashboard like Last year to date, year to date sales, calculate the year to date difference and also made it also in percentage.

 

First I tried with a list and used pivot table to calculate these KPIs but I encounter a case wich if an account made an order this year but not the previous year, an error : divide by 0 occurs. I can't use any operators in the formula to avoid this case.

 

So I tried another solution by using the "calculated metrics" plugin to calculate the difference in sales since the beginning of the year and the difference in sales since the beginning of the last year as a percentage.

This works but the display is only in the form of metric values, is it possible to build a column dashboard with the metric data as input?

 

Can I create an object from my metric data and use it in a dashboard ?

Or even a function that takes order.account.owner as currentUser and returns the data?

Like 1

Like

1 comments

Hi,



 

Unfortunately, it is impossible to change the display of the dashboard from the Calculated metrics add-on using basic methods.

 

Regarding the "Divide by zero error encountered" error, to avoid this error, you can add +0.01 /(last year to date + 0.01) to the value by which the division is performed, but this will cause a slight difference in the calculations.

 

You can also add filtering to the Pivot table so that records with the value "last year to date" are not included in the list, so division by 0 will not occur and you will avoid the display error.

 

We have created a task for our development team to investigate and develop a mechanism to address this error in future versions of the application as the error occurs at the database level.

 

Thank you!

Show all comments

Hi Community,

In the OData4 protocol the maxTopLimit parameter

defines the limit for the value in the maximum number of rows in the output (which is 20.000 records)

We are retrieving the data from the Accounts table which has around 40.000 records.

What is the workaround or fix for this scenario?

Sasor

Like 0

Like

1 comments
Best reply

You can use the $top and $skip parameters to retrieve the data in pages. 

For example: 

Page 1 (first 1000)

https://creatiourl/0/odata/contacts?$top=1000&$skip=0

Page 2 (next 1000) 

https://creatiourl/0/odata/contacts?$top=1000&$skip=1000

Page 3 (next 1000) 

https://creatiourl/0/odata/contacts?$top=1000&$skip=2000

etc

Ryan

You can use the $top and $skip parameters to retrieve the data in pages. 

For example: 

Page 1 (first 1000)

https://creatiourl/0/odata/contacts?$top=1000&$skip=0

Page 2 (next 1000) 

https://creatiourl/0/odata/contacts?$top=1000&$skip=1000

Page 3 (next 1000) 

https://creatiourl/0/odata/contacts?$top=1000&$skip=2000

etc

Ryan

Show all comments

Hi

 

I have two buttons on the accounts page that appear fine except when navigating to page via Global Search, where one disappears.

 

Standard Record access

 

Access via Global search

 

 

Both buttons have same set up except one is right container and one is left.

 

Anyone know why this is happening and how to resolve it?

 

Like 0

Like

4 comments

Hello,

 

Please specify how exactly this button was implemented in your system.

It was created using Replacing view model. It works and displays fine unless you go into record via Global Search. The other button 'Supplier Approval' was created in same way and displays when viewing via global search. The pages are the same so it is strange.

Rob Watson,

 

are you sure that the "Compliance approval" button has its implementation in the section schema (the button is developed to be used in combined mode)?

Hi Oleg,

 

Yes the setup is the same as the 'supplier approval' which does show when accessing via Global Search, The only difference is that one is using combined right container and one is using combined left container

Show all comments

Does Creatio allow to sign outgoing e-mails with S/MIME?

Like 2

Like

3 comments

Hello,

 

Unfortunately, at the moment, there is no mechanism for signing outgoing emails in Creatio.

 

We have registered the request for our development team to evaluate the possibility of implementing such a mechanism in future releases of the application.

 

Thank you for helping us make our product better!

Best regards,

Pavlo.

Thank you for the reply :)

Dawid Brezwan,

Thank you for your question. We would like to inform you that our development team is currently working on the request to add the functionality you specified. At the moment, we do not have a specific ETA for the implementation of this functionality, but we do our best to add it in future releases of the application.

Show all comments

Hi all,

 

Could someone please kindly advise:

1. "Timestamp" for Stages similar to Stage in Opportunity Section. 

2. How to measure Interval duration for each stage

 

Many thanks

Mid

Like 0

Like

1 comments

Hello Mid,

 

We have consulted with our colleagues from the R&D team regarding your case.

Unfortunately, there is no such option. Apart from that, its implementation would require development tools. 



For example, 

The necessary logic according to your business task is implemented on the coreb part "Case Lifecycle" and you can build on the work of this part when developing.



The implementation of CaseLifecycle filling method can be observed in the event process (CaseSaving and CaseSaved) of the Case object from the SLM package.

CaseLifecycle filling method - SaveLifecycle().



To implement the logic, you will need to create two objects - Usr[ObjectName] stages and Usr[ObjectName]history, on the basis of which the detail will be created.



We will also create a case for our R&D team on this matter so it may be implemented in the next releases.

Show all comments

Hi community, 

does anyone successfully upgraded a creatio instance hosted on docker container ? 

Like 1

Like

1 comments

Hello,

 

At the moment, there is no official procedure for updating the application to the docker. You can find the relevant communication in this article on Creatio Academy.

We recommend deploying to the docker only for test environments.

 

Thank you.

Show all comments

Hi Community,

 

We couldn't find more articles regarding the client side coding of freedom ui form page in documentation, mainly because it is already promoting no code platform. However, we've able to achieve so many complex client requirements before through the help of client side coding in classic ui. Could you please help us know the counterpart of the following classic ui functionality in freedom ui.

 

1. "dependencies" in attributes to Call custom function

2. "lookupListConfig" attributes for custom filter in lookup

3. "filterMethod" in detail for custom filter of detail

4. ESQ in client side

5. asyncValidate

6. ProcessModuleUtilities to call business process from client side

7. ServiceHelper to call source code schema function

 

Thank you so much.

 

Like 0

Like

5 comments

Hello,

 

As for 1-3 - there are no particular examples of implementing the same in Freedom UI unfortunately.

 

4. ESQ in Freedom UI is "replaced" with the sdk.Model class (see examples here https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…)

 

5. validator example in Freedom UI can be found here https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…

 

6. An example of calling the business process from the client-side can be retrieved manually: you can add a button clicking which will trigger a business process (setup is performed in the designer). The autogenerated code of the click handler for a button can be then reviewed and the same functionality implemented.

 

7. As for calling ServiceHelper - you can add a separate module as a dependency to your list or form page (like

 

define("Accounts_FormPage", /**SCHEMA_DEPS*/["UsrSomeCustomModule"]/**SCHEMA_DEPS*/, function/**SCHEMA_ARGS*/()/**SCHEMA_ARGS*/ {

...

)

 

and in that UsrSomeCustomModule implements service calling like in the classic UI and calls the method that calls the service as: UsrSomeCustomModule.MethodFromTheCustomModule.

Thank you Oleg,

 

Is there any other work around for 1,2 and 3?

 

Regarding number 6, we need to call the business process from client code as there are few extra processes to prepare the parameter that needs to be passed on business process. 

Fulgen Ninofranco,

 

 

As for 1-3 the only workaround is using business rules for filtration, this is the only workaround for the moment.

 

As for the 6th - you can also setup the process to be triggered with passing some parameters, so it will give an example of such a code.

Hi Oleg, 



In case we need to filter a lookup inside an editable grid, is that possible with Business Rules too? 

We used to do this with Business Rules in the detail.

#1 For change events on the page the equivalent is just handing the change request and checking if the change is for the column you're handling it for. See https://customerfx.com/article/responding-to-an-event-when-a-field-is-c…

 

#2 For filtering lookups there are filtering business rules available, however, if you need to filter a lookup in code, see https://customerfx.com/article/dynamically-filtering-a-lookup-on-a-crea…

 

#3 For filtering lists (equivalent to details), the article I listed for #2 works for filtering a list as well. All things like lists and lookups request a datasource to retrieve it's data, so you can handle that request and apply filters to it as needed. Also, you can add filters to lists easily in the designer as well with no code. I've not tried the approach with filtering a lookup in an editable list. There are a few things in editable lists that aren't yet possible as far as I know (such as validation, applying rules etc)

 

#4 Using the model class is the ESQ equivalent. See

https://customerfx.com/article/querying-data-using-filter-conditions-vi…

or 

https://customerfx.com/article/retrieving-a-record-via-the-model-class-…

 

#5 Validators are the equivalent. They can async or synchronous. See https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…

 

#6 You can start processes easily with no code. However, if you need to start them via code, see https://customerfx.com/article/starting-a-process-from-client-side-code…

 

#7 For Freedom UI equivalent of calling a configuration web service, see https://customerfx.com/article/calling-configuration-web-services-from-…

 

Ryan

Show all comments

I changed the SQL Server Authentication settings to Windows Authentication Mode. But when I login to Creatio I get a Login Failed error.

What do I need to set in the Connection String?

 

Like 0

Like

1 comments

Hello all,

 

Is there a way to add an Iframe to a Freedom UI page? I found the documentation here that details how to add one but it only seems to describe how to add to a Classic UI page.

Like 0

Like

1 comments