All the solutions ive found to find your current Creatio version/distribution require you to use a specific MSSQL SQL query that doesnt work with PostgreSQL and doesnt seem to have any easy syntax conversion, does anyone have any ideas?

Like 2

Like

3 comments
Best reply

Oliver Crowe,

Use 'Product Version'

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Product version' 

 

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Configuration version' 

 

keith schmitt,

How do you get it to involve the product distribution? eg Sales enterprise/Studio

Oliver Crowe,

Use 'Product Version'

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Product version' 

 

Show all comments

Hi community!

I am trying to add some validation in Lead section by setting business rules.

I need to make one field mandatory at two specific Lead stages for specific Customer needs.

As I am unable to group conditions I created like 5 different business rules. It seems it works only if one of them is enabled. If I have like both of them enabled then validations don't apply.

 

some examples:

 

 

Like 0

Like

3 comments

Hello,

 

this is correct, usually you cannot set more than 1 rule for a specific field.

 

The thing is that the system needs one parameter to change a fileld specified in the rule, and once there are two or more rules, the system does not understand which one to use, as the result - only one can be applied.

 

The good news is that group conditions are being developed and this feature should be enabled in the nearest verstion of the system.

 

Regards,

Gleb.

Gleb,

Thanks Gleb, did you know in what release this feature will be implemented?

Julio Falcon (Cibernética),

 

This feature was implemented in version 8.0.3, Freedom UI.

Show all comments

Dear sir, madam,

 

I have been troubleshooting this for a few hours and it is very frustrating. In one process it does work, in another it doesnt.

 

Apparently I found the problem, I am not sure if this is a bug of somesorts?

 

The following script is an example from: https://academy.creatio.com/docs/8-0/user/bpm_tools/process_elements_re…

var list = new CompositeObjectList<CompositeObject>();
var item1 = new CompositeObject();
item1["Id"] = Guid.NewGuid();
item1["Name"] = "Name1";
list.Add(item1);
var item2 = new CompositeObject();
item2["Id"] = Guid.NewGuid();
item2["Name"] = "Name2";
list.Add(item2);
Set<CompositeObjectList<CompositeObject>>("CompositeObjectListParameter", list);

I get the following error message

System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at Terrasoft.Core.Process.ProcessParameterProvider.SaveCollection(String parameterPath, ICompositeObjectList`1 items)
   at Terrasoft.Core.Process.ProcessParameterProvider.SetParameterValueInternal[TValue](String parameterPath, TValue value, Boolean setMustReadFromParameterStore)
   at Terrasoft.Core.Process.ProcessParameterProvider.UpdateParameterValue[TValue](String parameterPath, TValue value)
   at Terrasoft.Core.Process.ProcessParameterProvider.SetParameterValue[TValue](ProcessSchemaParameter parameter, Guid schemaElementUId, TValue value)
   at Terrasoft.Core.Process.ProcessModel.SetParameterValue[T](FoundParameterData result, T value)
   at Terrasoft.Core.Process.ProcessModel.TrySetValue[T](ProcessSchema processSchema, String propertyPath, T value)
   at Terrasoft.Core.Process.ProcessModel.Set[T](String propertyPath, T value)
   at Terrasoft.Core.Process.UsrProcess_0ca90bfCustom1MethodsWrapper.ScriptTask1Execute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessScriptTask.InternalExecute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.ExecuteItem(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

It only works when inserting the Collection of Records "CompositeObjectListParameter" parameters Id and Name into a subprocess.

If you do not 'connect' a subprocess it gives the error message.

 

Why is this? Is this a bug?

Like 0

Like

3 comments

Hello,

 

This can be fixed by creating the CompositeObjectListParameter in the following manner:

Id and Name are the "Title" and the "Code" of the nested parameters + it's important to set default values. As a result the code will work properly.

Hi Oleg

I tried what you suggest but it does not work.

In the subprocess arrives the initial default value configured on the parent business process not the values setted on the script task.

 

Can you help me?

 

Hi Stefano

Encountered the same issue that you described. After removing the default values in the parent process it started to work normally. Didn't see any negative effects.

Show all comments

Im trying to transfer a package from one enviroment to another, but get an error saying it cant find the dependent package, when i try remove any dependencies from the package before exporting it, I get a long error, any suggestions?

Like 0

Like

1 comments

Hello,

 

Please refer to the instructions in the Academy articles below that explain the package dependencies and data binding in the system:

Bind data to a package

Package dependencies and hierarchy

Define the package dependencies

Show all comments

Hi! 

We face some issues with binding a grid. After we exported the package from an environment to another, a column setups is still the same.

What is the appropriate way to make a bind for a grid?



Thank you! 

Rareș Ivan

Like 0

Like

2 comments

Hello Ivan,

I have an article here that shows how to bind the column layout to a package. 

https://customerfx.com/article/including-the-default-column-layout-for-…

Ryan

Hi, Ryan



Thank you for sending me this article. We already tried this method and it worked on some other grids, but, unfortunately, not for OpportunityPageV2OpportunityProductDetailV2.

Do you have any idea if there's any other method for binding this grid, or if could be an installation from an environment to another?



Best regards,



Rareș Ivan

Show all comments

Dear Creatio,

 

I am stuck on loading screen for a while now. Existing tabs still work but opening new tabs or refreshing a tab gives me a forever loading screen with Creatio 8 Atlas.

 

Yours sincerely,

 

Pascal

 

 

Like 1

Like

1 comments

Hello Pascal, 

 

If it's your on-site instance we'd suggest to try to restart the site/IIS. If it's cloud instance, please contact the support team at support@creatio.com for further investigation, additionally I'd suggest to provide the team with detailed screenshots of the error you have. 

 

Best regards,

Anastasiia

Show all comments

Dear Creatio,

 

I apparently ran out of memory. The parent process gave an error, I cancelled this process and all sub processes cancelled automatically, except for about 20 processes. Status is Running, unable to cancel since the parent needs to be cancelled first, but the parent has already been cancelled.

 

Yours sincerely,

 

Pascal

Like 0

Like

1 comments

Hello Pascal, 

 

We'd suggest to first stop the process execution and then try to delete it. 

Please let us know if the issue persists. 

 

Best regards, 

Anastasiia

Show all comments

I made a post before which didnt get any replies than to contact Creatio support which doesnt provide support for this, any help would be appreciated

Like 0

Like

1 comments

Hi, 

I'm looking for some guidance on setting up a process.

 

I want the process to run once per week, reading all Activities where the start date is <= Yesterday and the field (Result) is not filled in. 

Then I want the process to send 1 E-mail to the organiser listing the records that need the results field completing. 

 

I'm  relatively new to processes and sub processes so any guidance would be really appreciated.

 

Like 0

Like

1 comments

Hello Tom,

 

You can design your business process to run once a week with a help of "[Start timer] event" element, more detailed information is available on our Academy:

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

 

Best regards,

Anastasiia

Show all comments

Hi community!

I need to make file attachment mandatory in Lead object (Attachments and notes) at Sales in progress stage. If there isn't any file attached I need to prohibit user to go to the next stage. Any suggestions?

Like 0

Like

4 comments

Hello,

 

In order to achieve the goal, you can use a business process in the case, which will check the "availablity" of the files and links to the details of the specified section. 

 

That will be nice to use in the business process the following element:

 

"read data", which will read the object "file and link <section name>"  according to the filter <section name> = id of the transfered record.

 

After that, using the formula, you will be able the check the availabillity of the files the the records of the corresponding section. 

 

 

Kyrylo Iudin,

Hello, thanks. Yes, I have done the check of file in that way, but after check is done how can I prohibit user to proceed to the next stages without file. Only manual transition is allowed between stages.

Yana,

Hello,

 

I am so sorry for misunderstanding. Currently such an option can't be achieved but i am sure we will do our best to add such a feature in future releases. 

Yana, you can achieve this in a business process in front end when the stage is changed and the file is missing then you roll back to the previous stage and you can also show a popup to the user that the file is missing.

Show all comments