I am trying to make a filter system so that the record only appears to the user who is assigned a task (in the list page)
this is my configuration

however when i create a new record and the task is given to a user (SalesJKT1) the task(Open Edit Page Notification) is shown on SalesJKT1 but the record is not showing for SalesJKT1 

How do i make it so that the table only shows the records that are currently being done by the user

Stages
New => Fill 1 Column => Approval => Done/Rejected
New = the task is given to the user who creates it(in this case SalesJKT1 so only SalesJKT1 can see the record)
Fill 1 Column = SalesJKT1 fills the column and save then go to next stage(still only SalesJKT1 can see)
Approval = SupSalesJKT Approves(only SupSalesJKT can see the record at this stage, so the SalesJKT1 Can no longer see the record)
Done/Rejected = SalesJKT1 can see the record but SupSalesJKT cannot see the record

The funnel shows all possible stages, after which it outputs data only to those fields that we filter. And it is necessary that the filtered fields are not shown, hidden or deleted. It will not be possible to get it through the observer because it comes as one monolithic object, not different fields
For example hide the second and the third row.

Hello,

On the Case page, I want to add a chart showing the yearly sum of a numeric field, filtered by the contact who created the case, but I can't find a way to do this. If the chart object is Contact, the Column option cannot be selected the numeric field of the Case. If the chart object is Case, it cannot be filtered or associated with the Created By contact.

Is there a way to do this?

Thank you in advance.

Regards.

I have quick filter and i wanna set dynamically filters for each quick filter (related Filter).
Do you have solutions for my case? try to bind the value but not worked.
 
{
                    "operation": "insert",
                    "name": "QuickFilter_kp8pw59",
                    "values": {
                        "layoutConfig": {
                            "column": 9,
                            "colSpan": 2,
                            "rowSpan": 1,
                            "row": 1
                        },
                        "type": "crt.QuickFilter",
                        "config": {
                            "caption": "#ResourceString(QuickFilter_kp8pw59_config_caption)#",
                            "hint": "",
                            "icon": "filter-column-icon",
                            "iconPosition": "left-icon",
                            "defaultValue": [],
                            "entitySchemaName": "BsiArea",
                            "recordsFilter": {
                                "filterType": 6,
                                "items": {
                                    "byRegion": {
                                        "filterType": 1,
                                        "comparisonType": 3,
                                        "isEnabled": true,
                                        "leftExpression": {
                                            "expressionType": 0,
                                            "columnPath": "BsiRegion"
                                        },
                                        "rightExpression": {
                                            "expressionType": 2,
                                            "parameter": {
                                                "dataValueType": 10,
                                                "value": "SelectedRegionId"   // bind ke attribute
                                            }
                                        }
                                    }
                                }
                            }
                        },
 
Updated :
 
handlers: /**SCHEMA_HANDLERS*/[
			{
				request: "crt.HandleViewModelAttributeChangeRequest",
				handler: async (request, next) => {
					const regionQFAttrName = "QuickFilter_Region_Value"; // Region
					const areaQFAttrName = "QuickFilter_Area_Value"; // Area
					const outletQFAttrName = "QuickFilter_Cabang_Value"; // Outlet
 
					if (request.attributeName !== regionQFAttrName && request.attributeName !== areaQFAttrName) {
						return next?.handle(request);
					}
 
					const areaQFFilterAttrName = "QuickFilter_Area_ComboBox_List_Filter";
					const outletQFFilterAttrName = "QuickFilter_Cabang_ComboBox_List_Filter";
					const areaRegionColumnName = "BsiRegion";
					const outletRegionColumnName = "BsiRegion";
					const outletAreaColumnName = "BsiArea";
 
					const areaFilter = new sdk.FilterGroup();
					areaFilter.logicalOperation = sdk.LogicalOperatorType.Or;
					const outletFilter = new sdk.FilterGroup();
					outletFilter.logicalOperation = sdk.LogicalOperatorType.And;
					const outletFilterByRegion = new sdk.FilterGroup();
					outletFilterByRegion.logicalOperation = sdk.LogicalOperatorType.Or;
					const outletFilterByArea = new sdk.FilterGroup();
					outletFilterByArea.logicalOperation = sdk.LogicalOperatorType.Or;
 
					if (request.attributeName === regionQFAttrName) {
						let currentAreaValue = await request.$context[areaQFAttrName];
						const needAdditionalConfigurateoutletFilter = Array.isArray(currentAreaValue) && currentAreaValue.length > 0;
 
						if (Array.isArray(request.oldValue) && Array.isArray(request.value) && request.value.length > request.oldValue.length) {
							currentAreaValue = [];
							request.$context[areaQFAttrName] = [];
							request.$context[outletQFAttrName] = [];
						}
 
						if (Array.isArray(request.value) && request.value.length > 0) {
							for (var i = 0; i < request.value.length; i++) {
								await areaFilter.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, areaRegionColumnName, request.value[i].value);
								await outletFilterByRegion.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, outletRegionColumnName, request.value[i].value);
							}
							outletFilter.add(outletFilterByRegion);
						}
 
						request.$context[areaQFFilterAttrName] = areaFilter;
 
						if (needAdditionalConfigurateoutletFilter) {
							for (var i = 0; i < currentAreaValue.length; i++) {
								await outletFilterByArea.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, outletAreaColumnName, currentAreaValue[i].value);
							}
							outletFilter.add(outletFilterByArea);
						}
 
						request.$context[outletQFFilterAttrName] = outletFilter;
					}
 
					if (request.attributeName === areaQFAttrName) {
						const currentRegionValue = await request.$context[regionQFAttrName];
						const needAdditionalConfigurateoutletFilter = Array.isArray(currentRegionValue) && currentRegionValue.length > 0;
 
						if (Array.isArray(request.value) && request.value.length > 0) {
							for (var i = 0; i < request.value.length; i++) {
								await outletFilterByArea.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, outletAreaColumnName, request.value[i].value);
							}
							outletFilter.add(outletFilterByArea);
						}
 
						if (needAdditionalConfigurateoutletFilter) {
							for (var i = 0; i < currentRegionValue.length; i++) {
								await outletFilterByRegion.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, outletRegionColumnName, currentRegionValue[i].value);
							}
							outletFilter.add(outletFilterByRegion);
						}
 
						request.$context[outletQFFilterAttrName] = outletFilter;
					}
 
					return next?.handle(request);
				}
			},
			{
				request: "crt.HandleViewModelInitRequest",
				handler: async (request, next) => {
					const regionQFAttrName = "QuickFilter_Region_Value";
					const areaQFAttrName = "QuickFilter_Area_Value";
					const currentRegionValue = await request.$context[regionQFAttrName];
					const currentAreaValue = await request.$context[areaQFAttrName];
					const hasRegionValue = Array.isArray(currentRegionValue) && currentRegionValue.length > 0;
					const hasAreaValue = Array.isArray(currentAreaValue) && currentAreaValue.length > 0;
 
					if (!hasRegionValue && !hasAreaValue) {
						return next?.handle(request);
					}
 
					const areaQFFilterAttrName = "QuickFilter_Area_ComboBox_List_Filter";
					const outletQFFilterAttrName = "QuickFilter_Cabang_ComboBox_List_Filter";
					const areaModelColumnName = "BsiRegion";
					const outletRegionColumnName = "BsiRegion";
					const outletAreaColumnName = "BsiArea";
 
					const areaFilter = new sdk.FilterGroup();
					areaFilter.logicalOperation = sdk.LogicalOperatorType.Or;
					const outletFilter = new sdk.FilterGroup();
					outletFilter.logicalOperation = sdk.LogicalOperatorType.And;
					const outletFilterByRegion = new sdk.FilterGroup();
					outletFilterByRegion.logicalOperation = sdk.LogicalOperatorType.Or;
					const outletFilterByArea = new sdk.FilterGroup();
					outletFilterByArea.logicalOperation = sdk.LogicalOperatorType.Or;
 
					if (hasRegionValue) {
						for (var i = 0; i < currentRegionValue.length; i++) {
							await areaFilter.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, areaModelColumnName, currentRegionValue[i].value);
							await outletFilterByRegion.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, outletRegionColumnName, currentRegionValue[i].value);
						}
						outletFilter.add(outletFilterByRegion);
 
						request.$context[areaQFFilterAttrName] = areaFilter;
					}
 
					if (hasAreaValue) {
						for (var i = 0; i < currentAreaValue.length; i++) {
							await outletFilterByArea.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, outletAreaColumnName, currentAreaValue[i].value);
						}
 
						outletFilter.add(outletFilterByArea);
					}
 
					request.$context[outletQFFilterAttrName] = outletFilter;
 
					return next?.handle(request);
				}
			}
		]/**SCHEMA_HANDLERS*/,

Hello Creatio Community,

I’m working on creating a custom complex filter logic in a User Page JS and ran into a problem.

The following code works fine:

filter.addSchemaColumnFilterWithParameter(
    sdk.ComparisonType.Equal,
    "[TableA:TableB].ColumnX.Id",
    "1048f156-620f-4e01-8796-a43ee5182dcc"
);

However, this does not work:

filter.addSchemaColumnFilterWithParameter(
    sdk.ComparisonType.Equal,
    "[TableA:TableB].ColumnX.Id",
    "[TableA:TableB].ColumnX.[TableC:TableD].ColumnY.Id"
);

It seems like addSchemaColumnFilterWithParameter does not accept two expressions as parameters (i.e., the second argument as a schema column and the third argument as another schema column instead of a value).

Is there any other function or approach that allows passing two schema column expressions to create a complex filter like this?

Hello Creatio Community,

I’m trying to implement a custom filter for a contacts dropdown on my mini page, and I need help constructing it properly.

The filter has two main conditions combined with AND:

1. The first condition itself has two sub-conditions depending on whether a certain column is null or not:
   • If the column is not null, get a string value from the related column1id table and compare it with the contacts.
   • If the column is null, get an ID value from the related column2id table, then use that ID to retrieve a string for comparison with the contacts dropdown.
2. The second condition involves a specific field ID:
   • Use this ID to filter contacts who have a checkbox selected that corresponds to this ID.

How would you tackle retrieving data from data source? How can I build a filter that applies these conditions properly with AND logic between them? 

Edit: Question no.  2:
Would it be possible to do all the filtering logic in JS (manually send a query to the database) and somehow push the result to the dropdown as datasource?

Dear,

Sorry to bother you with a beginner's question, but on the call page, in Freedom UI, I can't filter the results by activity type.

I tried using business rules, but I can't figure out how to do this filter.

In each Result Activity Lookup, you have an activity category:

On the call page, all results are actually displayed on the Freedom UI.

So i go to the business rules but i didn't find how to filter the results with the call category.

I must be missing something

Thank you !
Nicolas

Dear,

When adding a new element to a detail, I would like to know if it is possible to filter these elements.

For example, in the account competitors detail below, I would like to only display accounts whose type is competitor.

So in the page that appears how to filter the accounts by type ?

Is it possible to do this type of filter or do you have to go through an intermediate page ?

Thank you !
Nicolas

i am trying to configure/make  a filter system that let's me select a set of options based on another set of options, basically a filter system for lookups based on lookups, what i understand is using business rules like so...

if Provinsi = DKI Jakarta 

then Kota = (Dropdown => Jakarta pusat, Jakarta Barat, Jakarta Utara, etc)

if Provinsi = Aceh

then Kota = (Dropdown => Aceh Selatan, Aceh Utara etc)

now im trying to find a better way to filter the dropdown without going through them 1 by 1 i want to do it for 5 fields

Provinsi, Kota, Kecamatan, Kelurahan, Kode Pos

and each one needs to have the right option values

can anyone suggest a better way to handle this since i have no idea on how to do this

Dear,

I would like to filter activities in the timeline by activity category :

do not display activities if their category corresponds to a given value.

I haven't found any articles or requests in the community to do this. I can not find where to apply this filter on the timeline object.

Thank you !

Nicolas