Hello!



We have Product field in 'Product in order' detail and we can add Product.Type, Product.Category and other columns in the detail for employee users.

But is no option to add them in the detail for Portal users. It is incorrect way to add such fields and synchronise them (cause there can be a lot of them) to the detail.



How can we display such linked fields in details for Portal users?

Thank you!

Like 0

Like

4 comments

Hello Vladimir,

 

Thank you for your question. There is an intentional limitation for portal users not to be able to display linked objects. That is one of the core differences between the system and portal user.

 

Best Regards,

Dan

So, all characteristics of object (e.g. Product type, Product category, Product code, Product link and so on) should be added additionaly as physical fields to all objects like Product in Order, Product in Invoice, Opportunity product, Product in Contract and so on?

I believe that might be one of the ways to display the needed value. You just need to avoid using linked objects for the portal. 

Can anyone suggest other ways as well to choose the best one?

Show all comments

Hi Team,

 

We have created two case life cycle [DCM] and the initial stage for both the cycle is not the same. So we cant set the stage as a default as the initial stage is different for Both the cycle and we need to write a business process that as soon as the case is created based on of the field selected in the mini field set the first stage.

 

Question : is it possible to set the first stage based on the field value selected in mini page without writing a business process. How do we set default value for the case life cycle based on the field value selected.

 

Thanks in advance!

 

Regards,

Mayan

Like 0

Like

1 comments

Hello,

 

As for now, there is no option to automatically change the DCM version for all records. 

 

We've registered it in our R&D team backlog for consideration and implementation in future application releases.

 

Thank you for helping us to improve our product. 

 

Show all comments
oData
json
API
Collections
Sales_Creatio
8.0

Hi Team,

We want to retrieve a specific record by Id along with all the related elements (eg - Retrieve Account A with all of its related Contacts). 

What we already know:

We can retrieve the account record itself along with related records that are linked with lookupfields, like the PrimaryContact

 

Account(0001111-1111-1111-1111-111111231123)?$expand=PrimaryContact($select=Name)

This works, but it returns only one contact, the primary one.

 

Instead, we need an embedded list of contacts, like

{
    "@odata.context": myurl.creatio.com/0/odata/$metadata#Account(PrimaryContact(Name))/$entity,
    "Id": "22222-222222-2222-222222-22222207ba6",
    "Name": "somename",
    "OwnerId": "111111-11111-11111-11111-1111111",
    "CreatedOn": "2022-11-16T21:11:57.214167Z",
    "Contacts“ : [
{object}, {object}
]
}

Given the first URL in the response, we expected that all NavigationProperties would behave the same:

But this collection:

Is not accessible. If we call for :

Account(0002204c-d255-46c0-bea6-0f32e2e07ba6)?$expand=ContactCollectionByAccount

 

We get this error in return:

{
    "error": {
        "code": "",
        "message": "An error has occurred."
    }
}

If we use other expand values, we retrieve meaningful errors like „Could not find a property named xy“, but this error is not self explaining. How can we return an object with an embedded list of children? I know that in this example we also could ask for a list of Contacts filtered by their account, but we cannot do that in all scenarios we have in mind.

Thank you

Petrika

Like 3

Like

1 comments

Hello Petrika,

 

This property cannot be used to retrieve all contacts related to the account and can be used in filtration only. To retrieve related contacts you need to perform the GET query to the Contact object with the correspondent AccountId filter. Using this approach you will be able to get contacts needed.

Show all comments

Our sales and production processes use multiple funnels. Huge advantage of Creatio is the ability to create multiple funnels with different settings. That is why we chose Creatio when fucked off russian amoCRM.

But the trouble is, we have an opportunity to build several funnels, but we have not the ability to manage several funnels together.

We found the Calculated metric add-on, which allows you to operate with formulas and get, for example, the conversion rate for the sum of two funnels, LTV or the number of sales per client for two funnels.

But it is not clear why you stopped half way and did not create the Lists and Charts in the same way.

THIS IS MEGA USEFUL. It is almost the functionality of Power BI.

Serious competitive advantage

Please clarify if there are any plans to improve it and when?

Thank you!

Like 1

Like

2 comments

Hi Artem,

 

Thank you for the detailed and thorough feedback. We appreciate it.

The developer of the Calculated metrics application is yet to improve it. However, the Creatio R&D department has already devised plans to redesign and enhance the charts interfaces in the out-of-the-box Creatio functionality. While I cannot provide you with an approximate release date, we scheduled the first steps in this direction after the 8.1 Creatio release.

Thank you for your answer.  We will be wait the update. We hope than in charts interfaces appear Filters "like Power BI" which help to use universal reports for different directions of analizes: levels (employee/dep/company) , offices, products ect

Show all comments
Freedom_UI
Sales_Creatio
8.0

Hello Community,

I'm trying to implement the opportunity Client in creatio Latest version. How can we add diff and attributes in latest version?

I tried in this way, but it didn't work. Is there any way to do the multilookup column or can we do multilookup column in latest version.

{

                "operation": "insert",

                "name": "Customer",

                "values": {

                    "type": "crt.ComboBox",

                    "label": "Customer",

                    "control": "",

                    "listActions": [],

                    "showValueAsLink": true,

                    "controlActions": [],

                    "multiLookupColumns": [

                        "Account",

                        "Contact"

                    ],

                    "layoutConfig": {

                        "column": 1,

                        "row": 1,

                        "colSpan": 1,

                        "rowSpan": 1

                    },

                    "controlConfig": {

                        "enableLeftIcon": true,

                        "leftIconConfig": {

                            "bindTo": "getMultiLookupIconConfig"

                        }

                    }

                },

                "parentName": "SideAreaProfileContainer",

                "propertyName": "items",

                "index": 0

            },

 

Thanks in advance! 

Regards,

I Yasaswini

Like 1

Like

1 comments

Hi,

Unfortunately, for now, you cannot create a multi-lookup column on the Freedom UI page. 

We already created a request for our R&D team to add this feature in the future version.

Show all comments
update
#PostGreSQL
Sales_Creatio
8.0

Hello Team,

I am trying to insert a null guid directly to the DB. I use the following snippet

	QueryColumnExpression nullParameter =
					Column.Parameter(DBNull.Value, new GuidDataValueType(UserConnection.DataValueTypeManager));
				update.Set("ResponseDetailsId", nullParameter);

I get the following exception

 

System.NotSupportedException: The CLR type Terrasoft.Core.DB.QueryColumnExpression isn't supported by Npgsql or your PostgreSQL. If you wish to map it to a PostgreSQL composite type you need to register it before usage, please refer to the documentation.

 

If this is not a suitable way, which is the proper way to insert a null guid directly in a PostgreSQL db from C# code ?

Like 2

Like

1 comments

Solved 

Example

new Update(_userConnection, "SysAdminUnit")
					.Set("LDAPElementId", Column.Parameter(null, "Guid"))
				.Where("SynchronizeWithLDAP").IsEqual(Column.Parameter(true));
			int operationsCount = update.Execute();

 

Show all comments

Hi Team,

 

A new DCM is created/OOTB DCM is used in a stage and few records are created. Post that there is a change made in the life cycle and new stages are added and saved and made it actual version.

 

Records created post the new stages has been defined will have the new DCM stage shown but the old records will have the old DCM and option to “change case” available and on click of the “change case” the stage will show with the new DCM flow.

 

Question : instead of going to each and every old record to change the DCM to the new DCM created, is there an option to update all the old records DCM to the newly created DCM?

 

 

Thanks in advance!

 

Regards,

Mayan

Like 3

Like

4 comments

Hello,

 

We have already registered it in the backlog of our R&D team to fix this logic in future releases.

 

Currently, you can only change the version of a case manually in each record separately.

+1 here, it would be great to update all or select opps in batch to switch to new dcm version.

Hello,



Would like to ask if this is possible now?



Thank you

Kalymbet Anastasia,

Any update on this.

Show all comments

Hi,

Is there a way to add advanced filter mode to lookup record in lookup section?

Right now there is only "Add filter" option on Filters/folders. I need to add "Switch to advanced mode" to lookup record to add more modes to filter. 

 

Like 1

Like

1 comments

At the moment, it is not possible to configure advanced filters in Lookups records.

We have recorded your request and this issue will be considered in as much detail as possible with the prospect of implementation in future versions of the application.

As a workaround, the advanced filter can be configured by the "list" dashboard by selecting the directory object, and in the display parameters select the advanced filter.

Thank you for your appeal and for helping to make our product better!

Show all comments
pivot
Sales_Creatio
8.0

Hello!

 

We need to add Pivot to the Account page.



As there is no widget with pivot available in page wizard, is there another option to do that?

Like 0

Like

4 comments

I do wish we could add dashboard list elements on pages. It would make things easy to display unrelated data on a page and things like pivot tables. However, I don't believe there is anyway to add it to the page that I know of. We usually just create a view, then display the results in a detail on the page instead. For creating a pivot table, Postgresql does have the crosstab function which does this easily - However, that is part of the tablefunc extension, which isn't installed in Creatio postgresql databases - I've never tried to see if it allows you to install extensions like that. See https://stackoverflow.com/questions/3002499/postgresql-crosstab-query/1…

Ryan

Ryan Farley,

We have added widget with list to the page, but it is still displayed like flat list, not pivot... 

That's why I would like to find out if it is possible to make this last step :)



Hello Vladimir,

Did you find a solution ?

Vladimir Sokolov,

Could you please add the steps for adding the list element to a page?

Thanks!

Jacek

Show all comments
dashboard
Metrics
Opportunities
Color
Sales_Creatio
8.0

Hello all,

 

Is there any way to change the color of the big blue confidence level widget on opportunities? It looks good when the instance is configured in standard Creatio blue but we have several clients using different section colors and when you make the section list something like red, it clashes.

Is there any way to change the color of the widget?

Like 0

Like

1 comments
Best reply

You can add this CSS to the opportunity page:

#ConfidenceLevelWidgetContainer .background-container {
    background-color: #9f5989;
}

Result

 

If you need help with how to add the CSS to the page, see https://customerfx.com/article/adding-custom-css-style-sheets-in-bpmonl…

Ryan

You can add this CSS to the opportunity page:

#ConfidenceLevelWidgetContainer .background-container {
    background-color: #9f5989;
}

Result

 

If you need help with how to add the CSS to the page, see https://customerfx.com/article/adding-custom-css-style-sheets-in-bpmonl…

Ryan

Show all comments