Is there a simple way to filter a dropdown to show only those contacts that belong to a particular Role?

I have explored several common approaches, but none have provided the ideal, straightforward method:

  1. No-Code Filtering by Contact Folder: Attempted to create a static "Reviewers" folder in the Contacts section. However, this doesnt seem to work for filtering with Freedom UI.
  2. Business Rules in Page Designer
    • Field‑level rules only expose “Make required” / “Read‑only” / value‑copy actions, no lookup‑filter.
    • Page‑level rules let me “Apply static filter,” but they don’t list Folder or FolderId, or any path through SysUserInRole.
  3. Custom Data Model (Object/View):
    • Using a custom object with BaseLookup as its parent forced a mandatory 'Name' (text) field for the lookup value itself, which isn't suitable for directly linking to a Contact record and requires extra, redundant user input.
    • Using BaseEntity as the parent required adding an extra display field (a lookup to Contact) and the dropdown would store the ID of our custom object record, not the Contact.Id directly, making it less intuitive and adding an unnecessary layer.

Is there an out‑of‑the‑box no‑code way in Creatio Freedom UI to filter a lookup dropdown by all users in a given Role (without creating a separate lookup table or writing custom page schema JSON)?

If that’s not supported today, what’s the best “no‑code” or “low‑code” pattern you’d recommend to maintaining a dynamic list of Reviewer users (ideally driven by Role membership or using a custom object)

Thanks in advance for any guidance or creative alternatives!

 

Like 0

Like

2 comments
Best reply

Hello 
To achieve this in a Contact folder, create a dynamic filter that targets contacts linked to system users who are members of the "Reviewer" role. This is done by referencing the “System administration object” associated with the Contact and ensuring that it has a user type of 4 (standard user) and that it is part of the “Reviewer” role through the “User in roles” relationship. The folder will then automatically include all contacts whose users match these criteria, keeping the list dynamic based on role membership.
Please Refer to the Screenshot

Hello 
To achieve this in a Contact folder, create a dynamic filter that targets contacts linked to system users who are members of the "Reviewer" role. This is done by referencing the “System administration object” associated with the Contact and ensuring that it has a user type of 4 (standard user) and that it is part of the “Reviewer” role through the “User in roles” relationship. The folder will then automatically include all contacts whose users match these criteria, keeping the list dynamic based on role membership.
Please Refer to the Screenshot

Thank you. That worked.  I had to ensure that the Lookup for the Reviewer field was set to Contact, after which I was able to see the System Administration Object and proceed with the rest of the steps in the diagram.

Show all comments
foreign
key
constraint
Error Message
Studio_Creatio
8.0

Hello all,

I am having difficulty reading foreign key constrain errors on cloud instances of Creatio. Everything I find says I need to execute a command in a SQL console which I don't have access to just to get something more helpful than "foreign key constraint error" Is there no lookup I can access to read the errors? Why are they so vague?

Like 0

Like

1 comments

That is a database level thing, so can only be read from the directly from the database:

To see it on a cloud instance, you can use Clio Explorer to execute the SQL statement to see what the constraint references. See this article for help setting Clio Explorer up (once all setup and installed, you can use it's Execute SQL function): https://customerfx.com/article/how-to-install-clio-explorer-for-creatio/

As for the query to determine the foreign key error details, see: https://customerfx.com/article/troubleshooting-constraint-violation-errors-in-creatio/

Ryan

Show all comments
custom
Studio_Creatio
8.0
ProcessModuleUtilities
#BusinessProcess

Hello,

I want to call a business process from a custom component which I am developing using the remote module.

I have seen that I need to use ProcessModuleUtilities to achieve that. Now, how do I get this ProcessModuleUtilities in my remote module?

I checked in the npm registry to install using npm but its not there.

Like 0

Like

5 comments
Best reply

For a remote module, it would be better to use the devkit SDK to execute the process. See examples here: 

Starting a process

Starting a process and getting process parameter results back

Ryan

For a remote module, it would be better to use the devkit SDK to execute the process. See examples here: 

Starting a process

Starting a process and getting process parameter results back

Ryan

Ryan Farley,

I am trying to use the dev kit to call a business process but getting an error. Can you see if I am making any mistake !!

Sagar Rodda,

Maybe try forming the request like this?

{
	request: "crt.RunBusinessProcessRequest",
	params: {
		processName: "name here",
		processParamters: {
			//...
		}
	}
}

Ryan

Ryan Farley,

Looks like request is not a valid property..

 

Ryan Farley,

Any alternative? 

Show all comments

Hi Team, 

Critical issue -

We are transferring our package from dev to prod site and package migration is successful but source code files are not transferred from dev to prod - 

In dev site there are total - 35 source code files


But in prod only - 25 files. 



Package migration is not throwing any errors its always successful but when I see the application hub I noticed that it only shows package with timestamp till 12 June 2025



Can you please help us why is this happening in the system?

Thanks

Like 0

Like

0 comments
Show all comments
Studio_Creatio
8.0

Like 0

Like

1 comments

Hello, 

 

For further investigation we recommend to contact Creatio Support team by e-mail - support@creatio.com

 

This issue seems to need deeper analysis. 

 

Thank you for reaching out!

Show all comments
deactivate
studiocreatio
baselookup
Baseentity
Studio_Creatio
8.0

Hey Community 
I’m trying to enable record deactivation on an object that inherits from BaseEntity. The object is also used as a lookup in several other objects. From the documentation it looks like the “Allow records deactivation” option is only available for BaseLookup objects.

Has anyone found a reusable approach—perhaps a utility class —that lets a BaseEntity behave like a deactivatable lookup? I’m aware I could add an IsActive Boolean column, but that would require adding filter logic everywhere the object is referenced, which I’d rather avoid.

Any pointers or examples would be greatly appreciated.

Like 0

Like

1 comments

Hello,

when adding a record inline of detail list, is it possible in code to set default value for Lookup column?

Thanks.

Like 0

Like

1 comments

Here is a code sample on how I solved it, maybe it helps somebody:

handlers: /**SCHEMA_HANDLERS*/[
    {
        request: "crt.HandleViewModelAttributeChangeRequest",
        /* The custom implementation of the system request handler. */
        handler: async (request, next) => {
            if (request.attributeName === 'GridDetail_u6gv7vy_ActiveRow') {
                const activeRowId = await request.$context.GridDetail_u6gv7vy_ActiveRow;
                const gridDetail = await request.$context.GridDetail_u6gv7vy;
                const defaultType = await request.$context.UsrLookupFileType;
                gridDetail.forEach((item) => {
                    if (item.attributes.GridDetail_u6gv7vyDS_Id == activeRowId
                       && !item.attributes.GridDetail_u6gv7vyDS_Type
                       ) 
                    {
                        item.attributes.GridDetail_u6gv7vyDS_Type = defaultType;
                    }
                });
            }
            
            return next?.handle(request);
        }
    }
]/**SCHEMA_HANDLERS*/


Please change "GridDetail_u6gv7vy" name to your list name and also attribute names ("item.attributes.GridDetail_u6gv7vyDS_Id" or "GridDetail_u6gv7vyDS_Type").

Show all comments
DCM
#progressbar
Studio_Creatio
8.0

Hi Everyone,

image showing update dcm button

We changed our DCM structure/case.

However it seems we need to manually click on the refresh button for all records.

Is there an automatic or a SQL method to update the DCM for all records.

Thanks

Like 0

Like

1 comments

Hello Rohith,

After reviewing your inquiry, I would like to inform you that, unfortunately, it is currently not possible to update all existing DCM records to the newly created DCM version in bulk. At this time, the case version can only be changed manually for each record individually.

However, a request has already been submitted to our R&D team to evaluate and potentially implement this functionality in a future release.

Show all comments
AISkill
Studio_Creatio
on-site
local instance
8.0

Hi,

Is Creatio AI not available for local deployments(8.2.2)? if not is there a way to purchase the licence and install it on local instance? 
I tried to use the AI but it says "Authorization failed".

Like 0

Like

2 comments

Hi! 

Right now, unfortunately, Creatio AI is available only using Creatio Cloud Service. To connect it to your local deployments - feel free to ask our support team for help.

Okay thank you

Show all comments
compilation
Studio_Creatio
8.0

i have installed creatio on windows 11 pro but when i tried to run first compilation it throw an error without any reference, id or code number ,  when i tried for win-10 pro , it worked, but i need to work on win-11 pro . so what i do.

Like 0

Like

1 comments

Hello,

Windows version has no impact on application compilation.

If there is issue with site deployment on premise, please follow this instruction:
https://academy.creatio.com/docs/8.x/setup-and-administration/on-site-d…


Best regards,
Ivan

Show all comments