Hi everyone,

 

Does anyone know if is is possible to set up a field value in business rules by combining 2 strings? For example change the title to something like "Account name - Customer need"? Hope this is achievable without programming as this is really a basic "no code" functionality...

 

 

Thanks!

Like 0

Like

1 comments

A business rule isn't able to do this. 

You could do it with a no code approach by creating a process that starts on the record added or modified that reads the record, then sets the field value by combining the two values. The down side to this approach is that the user won't see this value until they refresh the page.

I realize you're after a no code approach, however, if you want to do this with code, you can add something like this to the methods of the page - this will set the name when the record is saved (assuming the field names are correct):

save: function() {
    var account = this.get("Account");
    var need = this.get("LeadType");
 
    if (account && need) {
        this.set("Name", account.displayValue + " - " + need.displayValue);
    }
 
    this.callParent(arguments);
}

(btw, I don't know why formatted code doesn't format code correctly on these forums, but the && is supposed to be &&)

Ryan

Show all comments

Hi, 

 

When trying to run a  sql query in clio against a Creatio cloud environment I'm getting this eror:

 

System.Net.WebException: The remote server returned an error: (404) Not Found.

   at System.Net.HttpWebRequest.GetResponse()

   at Creatio.Client.ATFWebRequestExtension.GetServiceResponse(HttpWebRequest request)

   at Creatio.Client.CreatioClient.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)

   at Clio.Common.CreatioClientAdapter.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)

   at Clio.Common.SqlScriptExecutor.Execute(String sql, IApplicationClient applicationClient, EnvironmentSettings settings)

   at Clio.Command.SqlScriptCommand.SqlScriptCommand.Execute(ExecuteSqlScriptOptions opts)

 

Any thoughts?

 

Like 0

Like

1 comments

Hi,

 

It's impossible to determine the reason without reviewing the logs. You need to try running the same command using a local copy of the app hosted in cloud, get the error message and review the application logs. Also sine this is a PostgreSQL command review the command itself and check if all tables and columns in the query are double-quoted and the register is correct.

 

Best regards,

Oscar

Show all comments

Hi Community,

 

We decided to install a new Creatio Application instance on our linux based servers. We would like to know if we could use the lastest version of PostgreSQL (13 or 14)?

Thanks in Advance.

 

Best Regards,

Pedro Pinheiro

Like 0

Like

1 comments
Best reply

Hello Pedro,

 

You can use the 13th version of PostgreSQL. But not the 14th for now.



Best regards,

Bogdan

Hello Pedro,

 

You can use the 13th version of PostgreSQL. But not the 14th for now.



Best regards,

Bogdan

Show all comments

Hi Team ,

 

I'm looking for a solution for a scenario where a user double clicks on the record of a detail with column setup as list view, the record of the connected section should open instead of that detail record page.

 

Please help me achieve this.

 

Many Thanks,

 

Sarika

Like 0

Like

2 comments
Best reply

Hi Sarika,

To do this would would add some code to the detail to change what happens when the row is double clicked. First, add the NetworkUtilities to the modules list at the top of the detail schema, something like this:

define("UsrMyDetail", ["NetworkUtilities"], function(NetworkUtilities) {

Something like this:

editRecord: function(primaryColumnValue) {
    var row = this.getActiveRow(),
        entity = row.get("UsrMyEntityColumn");
 
    if (Ext.isEmpty(entity)) {
        return;
    }
 
    var hash = NetworkUtilities.getEntityUrl("UsrMyEntityName", entity.value);
    this.sandbox.publish("PushHistoryState", {hash: hash});    
}

Ryan

Hi Sarika,

To do this would would add some code to the detail to change what happens when the row is double clicked. First, add the NetworkUtilities to the modules list at the top of the detail schema, something like this:

define("UsrMyDetail", ["NetworkUtilities"], function(NetworkUtilities) {

Something like this:

editRecord: function(primaryColumnValue) {
    var row = this.getActiveRow(),
        entity = row.get("UsrMyEntityColumn");
 
    if (Ext.isEmpty(entity)) {
        return;
    }
 
    var hash = NetworkUtilities.getEntityUrl("UsrMyEntityName", entity.value);
    this.sandbox.publish("PushHistoryState", {hash: hash});    
}

Ryan

Hi Ryan,

 

Thanks for the solution, I tried the below given code and it is working as expected. 

 

 

Best Regards,

 

Sarika 

 

 

 

 

Show all comments

Hello community,

I tried downgrading packages to 7.18.2.1236 and everything is working fine. The next thing I need to do is downgrading the database version from 7.18.4.1532 to 7.18.2.1236. Which is the correct way to fix this issue because I'm getting "Versions of application "7.18.2.1236" and configuration "7.18.4" are incompatible"

Like 0

Like

1 comments

Hello,



Unfortunately, it's impossible to downgrade the application. 



You can downgrade it if you made the full backup before the upgrade.



Best regards,

Bogdan 

Show all comments
Question

Hi Team,

 

I have applied red asterisk using CSS on the fields that are mandatory in a section edit page using a client module for CSS.

 

 

The asterisk are visible in the pre-existing records but not in the new record. Please help me resolve this issue.

 

New record page :

 

 

Previously saved Record:

 

 

Also I'm facing this error of amplitude not defined 

 

Many Thanks,

 

Sarika

Like 0

Like

2 comments

Hi Sarika,

 

It the fields are mandatory then make them mandatory in the section wizard directly, but not applying red asterisk via css. Using the wizard the fields will be mandatory even when adding a new record.

 

Best regads,

Oscar

Hi Oscar, the labels that you can see are field default values that is being used as field label which I have implemented for proper alignment of section fields layout.

The Label Group Name is itself a field and the blank space for the value for Group name is another field whose title has been hidden.

That is why, for applying style, I have used CSS.

 

Show all comments

Hi Community,

 

I am trying to implement JIT when a user is not present. But by default it is creating a user as "Company Employee". Any suggestions how I can identify and create either Company Employee or Portal user based on the response that has been received in the SAML token.

I have followed the following two articles:

  1. Single Sign-On via ADFS
  2. Just-In-Time User Provisioning

 

Thanks,

Sourav Kumar Samal

Like 2

Like

3 comments

Hi All,

 

Can anyone answer on this?

 

Thanks,

Sourav

Dear Sourav, 



I would suggest you to carefully check the web.config file located in the root folder of Creatio. 

In this file you can find the list of login providers (the place where you enabling JIT by the guide):



        <provider name="SsoAuthProvider" type="Terrasoft.WebApp.Loader.Authentication.SSO.SsoAuthProvider, Terrasoft.WebApp.Loader">

          <parameters>

            <add name="UserType" value="General" />

            <add name="UseJit" value="false" />

          </parameters>

        </provider>

        <provider name="SSPSsoAuthProvider" type="Terrasoft.WebApp.Loader.Authentication.SSO.SsoAuthProvider, Terrasoft.WebApp.Loader">

          <parameters>

            <add name="UserType" value="SSP" />

          </parameters>



If you want to enable JIT for portal user you need to make sure that key <add name="UseJit" value="false" /> is added to the block related to the "SSPSsoAuthProvider"

so it looks like:

    <provider name="SSPSsoAuthProvider" type="Terrasoft.WebApp.Loader.Authentication.SSO.SsoAuthProvider, Terrasoft.WebApp.Loader">

          <parameters>

            <add name="UserType" value="SSP" />

            <add name="UseJit" value="true" />

          </parameters>



After that please make sure that SspLogin.aspx is specified in all keys instead of NuiLogin.aspx to make sure that user will get a proper portal cookie in case if you want to use a Service Provider initiated SSO flow to create portal users. 

Also please note that in this case ordinary company employees will have to login via direct link only or use the link to NuiLogin.aspx module if they want to use SSO as well. 



Kind regards,

Roman

Roman Brown,

Does this mean we can only use Jit either for Portal User or for Company Employee user?

 

Regards,

Sourav

Show all comments

Dear team,

 

We have an observation from 7.18.5 Cloud Version of Creatio. User A has added his email inbox. When User B logs in using User B's credentials and goes to Contact record of User A, User B is able to see all emails sent by User A!

 

This could be a possible security issue unless we are missing something.

Please help us with this.

 

Thanks

Like 1

Like

5 comments

Hello Shivani,

 

Please, check the following setting:

 

image.png

 

This option should be disabled for the user in question. In case, this is not enabled for user B - please, reach out to us at support@creatio.com so that we could have a closer look at the problem.

 

Best regards,

Anastasiia

Anastasiia Lazurenko,

I am unable to see this image. Could you please reupload or type out the  setting?

Anastasiia Lazurenko,

Can we have an update on this please?

Anastasiia Lazurenko,

The image is not shown.  What setting/parameter are you indicating here?

Shivani Lakshman,



Is it Resolved?

Show all comments

Hello community,

I'm trying to install a package using update from file system. After the installation everything is added successfully, except for some objects which have the following status (Source code update required).

I tried the following commands but nothing happens.

The structure of the object in the database is modified successfully but this message is displayed again.

** This happens only with replacing objects.

 

Like 0

Like

3 comments

Hello,

 

Thank you for your question!

 

Please, run database structure update for these objects.

 

After that, 

select Generate For All Schemas (source code) as on the screenshot below:





 

And compile the system:

 

This should resolve the issue.

In case it persists after these recommendations - please, let us know.

 

Regards,

Anastasiia

Anastasiia Lazurenko,

I tried the recommendations you sent but it still did not work. This happened because I was using the landing version 7.18.2.1236 and the package version was newer (7.18.4.1532). After downgrading the package version everything was compiled successfully. 

Hello,

 

Thank you for updating us. Good to know the issue is no longer in place.

 

Regards,

Anastasiia

Show all comments

Hi,

 

while filling a record in detail I am getting the below error 

What does this error means?

 

When I tried compiling the site I again get the below error

What does this error means?

 

I don't see any linking between these errors. Can anyone please help?

 

Many thanks!

Like 0

Like

2 comments

The 2nd error is resolved I figured out the reason is that the field name(code) is same as the section name(code).



But I didn't find out the reason of 1st error. 

Hi,

 

As for the first error message, find this Id from the error message in the UI sources in the developer console F12 -> Sources tab -> Search and see which object is returned in ViewModule.aspx when searching for the Id from the error message (like here https://community.creatio.com/questions/how-overcome-item-unique-identi…). Then you need to remove the SysModule record from the system that is related to the object found in the UI sources.

 

Best regards,

Oscar

Show all comments