Время создания
Filters
Creatio_Freedom_UI:_How_to_Extend_a_Lookup_Quick_Filter_with_an_OR_Condition?
Sales_Creatio
8.0

Hi Creatio Community,

I'm working on a customized Freedom UI form page and need guidance on implementing dynamic filtering for a List component.

Scenario

I have a grid with a native Quick Filter on a lookup field. There is another lookup field in the same object, referencing a different lookup object.

Both lookup objects contain records with matching names, but their record IDs (GUIDs) are different.

Requirement

When a user selects one or more values in the Quick Filter, I want the grid to display records matching either of the following conditions:

Selected Lookup Field IN (Selected Values)
OR
Second Lookup Field IN (Matching Lookup Values)

The matching lookup records should be identified by comparing their Name fields rather than their GUIDs.

All existing predefined filter conditions on the grid must also be preserved.

What I have tried

  1. Capturing Quick Filter selection using crt.HandleViewModelAttributeChangeRequest.
  2. Reading the selected lookup record IDs from the Quick Filter structure.
  3. Loading the corresponding records from both lookup objects using sdk.Model.
  4. Matching the records by Name.
  5. Dynamically creating lookup filter conditions and adding them to the grid's predefined filter using a nested filter group with OR logic.
  6. Keeping the root predefined filter's logical operation as AND to preserve existing criteria.

However, the native Quick Filter continues to apply its own condition independently. Consequently, the grid displays only records matching the selected lookup value, while records matching only the second lookup field are excluded.

I also tried modifying the Quick Filter's internal filter collection, but this resulted in a query execution error.

const dynamicItems = {};

dynamicItems["FirstLookupCondition"] = {
    filterType: 4,
    comparisonType: 3,
    isEnabled: true,
    leftExpression: {
        expressionType: 0,
        columnPath: ""
    },
    isAggregative: false,
    dataValueType: 10,
    referenceSchemaName: "",
    rightExpressions: [{
        expressionType: 2,
        parameter: {
            dataValueType: 10,
            value: {
                Name: "",
                Id: "",
                value: "",
                displayValue: ""
            }
        }
    }]
};

dynamicItems["SecondLookupCondition"] = {
    filterType: 4,
    comparisonType: 3,
    isEnabled: true,
    leftExpression: {
        expressionType: 0,
        columnPath: ""
    },
    isAggregative: false,
    dataValueType: 10,
    referenceSchemaName: "",
    rightExpressions: [{
        expressionType: 2,
        parameter: {
            dataValueType: 10,
            value: {
                Name: "",
                Id: "",
                value: "",
                displayValue: ""
            }
        }
    }]
};

updatedFilter.items["DynamicLookupGroup"] = {
    filterType: 6,
    isEnabled: true,
    logicalOperation: 1,
    trimDateTimeParameterToDate: false,
    items: dynamicItems
};

updatedFilter.logicalOperation = 0;

request.$context. = updatedFilter;

I also tried modifying the native Quick Filter's internal filter collection to prevent its original condition from being applied. This resulted in a query execution error.

My questions

  1. Is there a supported way in Freedom UI to intercept or override a native Quick Filter condition while retaining the user's selection in the Quick Filter control?
  2. Can the native Quick Filter condition be replaced with a custom OR filter involving two different lookup fields?
  3. Is there a recommended approach using crt.HandleViewModelAttributeChangeRequest, the grid's predefined filter, or another supported Freedom UI API?
  4. How can this be implemented while preserving the grid's existing predefined filter conditions?

I would appreciate a working example or guidance on the recommended implementation approach.

Thank you!

Like 0

Like

0 comments
Show all comments

Hi,

I am facing an issue while trying to access the Change Log for the Activity object.

I have enabled Change Log for the Activity object through System Designer → Change Log and clicked Apply. I can also see the Activity change history under the Change Log section (Log data).

However, when I try to open the Change Log directly from an individual Activity record using the View Change Log action, Creatio displays the following messages:

  • "Logging is currently off for Activity."
  • "Do you want to enable Change Log permissions from System Administrator user?"

Any guidance or suggestions to resolve this issue would be appreciated.

Thank you,

Like 0

Like

0 comments
Show all comments
capacity
planing
capacityplaning
New_in_Syntech

Hi everyone,

We just published a new app: Syntech Capacity Planning for Creatio. It helps you compare demand with capacity month by month and spot staffing shortages before they hit a project.

What's inside:
- Demand vs. capacity, month by month across a configurable hierarchy - Portfolio → Program → Project → Role → Person - for any horizon from 6 to 24 months, in hours or FTE.
- Instant over-/under-load signals: every month cell is colour-coded by utilization against thresholds you set.
- Future staffing-shortage report: see exactly where demand will exceed capacity and by how much (hours and FTE), grouped by month, role or row.
- Plan directly in the grid: type planned hours into a month cell and they’re saved as a monthly allocation - no separate screen.
- Binds to your data, no code: every schema and column is picked in settings, so it works with standard or custom project and resource objects. “Reset to defaults” only fills in objects that actually exist on your instance.
- Ready for large portfolios: data loads in pages and the grid reveals rows on demand, so big data sets stay responsive.

Requirements: Freedom UI, Creatio 8.3.0 and up.

Marketplace page:
https://marketplace.creatio.com/app/syntech-capacity-planning-creatio?u…

Thanks,
Syntech team

Like 1

Like

Share

0 comments
Show all comments
pivot
SyntechPivot
pivot_table
syntech
New_in_Syntech

Hi everyone,

We’ve released Syntech Pivot for Creatio 1.7.0. This update is all about reporting accuracy, especially when a pivot table works with related data sources. Here’s what changed and why it matters in day-to-day use.

1. Reports keep working when the page passes a filter about another object: the condition is left out and a line above the table names the column, instead of an empty component.
2. Totals are correct when a related data source is joined - a column of the primary object counts once per record, not once per joined row.
3. Reaching the related-rows ceiling is reported above the table; the data set is never shortened silently.
4. The record counter counts records of the primary object, through the same filters the table uses, and loading more records with a joined source no longer skips any.
5. Searching for an object when connecting a data source finds it: matches are ranked, exact ones first, and the list says when it shows only part of them.
6. Removing a data source refreshes the table instead of leaving its totals on screen.

Compatibility: Creatio 8.3.1 and up.

Product page: https://syntech.digital/en/products/syntech-pivot-for-creatio?utm_sourc…

Creatio Marketplace: https://marketplace.creatio.com/app/syntech-pivot-creatio?utm_source=cr…

Like 1

Like

Share

0 comments
Show all comments

Is there a way to set the axis values, or add a minimum value when making graphs? Similar to how you can in Microsoft Excel. I have this chart and the values are all similar, so I'd like to have the axis start at 10k to better emphasize the difference. 

Like 0

Like

1 comments

Not to my knowledge, either for bar/column or line charts. I would say that generally it's not good practice to do so for bar/column charts, since it can be misleading given that the area of the bar no longer correlates with the absolute values, and so can make smaller differences appear much bigger. That said, it would be nice to have the option to be able to do so for line charts which don't have that issue.

Show all comments