Fixed
Filtering

Hi Team,

 

Kindly advice on how to block the mulitiple fixed filter  as attached .

 

Regards,

Sethuraghav N

Like 0

Like

3 comments

Hello,

 

Can you please specify your business task?

Do you want to prevent users from adding multiple single filters on the page?

 

Best regards,

Bogdan

 Yes Bogdan Spasibov, we need to restrict user in adding the multiple filters in a calendar page. Only one filter should be selected at a time.

 

 

HI SathishKumar,

 

There is the option to change filter behavior; however, Creatio R&D team highly disrecommend you implementing such a filter and can provide only theoretical instructions.

 

Firstly, please note that the filter you've mentioned is implemented as an old module functioning through the whole system, not the Activity/Calendar section only. Thus, to avoid affecting all filters of your platform, you need to create your custom one and call it from the replacing client schema module. 

 

The main filter loader is located at the "BaseDataView", the "loadFiltersModule" method. You need to replace the "ActivitySectionV2" and write there your own "loadFiltersModule" method that will re-write the original one from the "BaseDataView". 

 

Then, please create a new module at the Configuration:

 

define("UsrixedFilterViewModelV2", ["FixedFilterViewModelV2"],
	function(fixedFilter) {       
        function generate(config) {
            var result = fixedFilter.generate(config)
            result.methods.oldaddNonPeriodFilterValue = result.methods.addNonPeriodFilterValue;
            result.methods.addNonPeriodFilterValue =  function (tag, simpleFilterValue) {
                var filters = this.get(this.getSelectedLookupValuesPropertyName(tag));
                filters.clear();
                this.oldaddNonPeriodFilterValue(tag, simpleFilterValue);
            };
            return result;
        }
		return {
			generate: generate
		};
	});

 

Below the detailed description step by step. The "fixedFilter" is the old model.

var result = fixedFilter.generate(config)

This code calls a standard out-of-the-box filter.

result.methods.oldaddNonPeriodFilterValue = result.methods.addNonPeriodFilterValue;

Here please write the logic you need:

result.methods.addNonPeriodFilterValue =  function (tag, simpleFilterValue) {
                var filters = this.get(this.getSelectedLookupValuesPropertyName(tag));
                filters.clear();
                this.oldaddNonPeriodFilterValue(tag, simpleFilterValue);
            };

 

 

Regards, 

Anastasiia

Show all comments
Filtering
mobile application
Mobile_Creatio

Hi,

 

There are list of columns available in order to search for a contact in Mobile App. I have a use case to remove/hide those and set "Last Name" as the primary and default column to search based on.

E.g. as soon as you chose to set a filter, your text to be search as a last name.

 

How is this possible in Creatio?

 

Thanks

 

Like 0

Like

1 comments

Dear Kavian, 



It's possible to configure columns by which search will be performed in mobile application. 

Information on where and how it can be configured can be found in this academy article: https://community.creatio.com/articles/search-multiple-columns-mobile-a…



Please refer to it and configure the list of columns in your own way. 



Kind regards,

Roman

Show all comments
export
data
Export Data
Business Process
Run Process
Filtering
Filters
7.15
Studio_Creatio_enterprise_edition

Creatio CRM has the feature of exporting data by filtering some records. Then we can export the data using the export to excel option.

However, for customers(end user) it may be confusing to apply multiple filters.

 

In this case lets suppose I only want to apply filter to only 2 fields.

So I want to create a process which will ask user to input values for those 2 filters. After that process will automatically generate a excel file which have all the records filtered according to the 2 filters input values.

 

Is this possible to do so?

I tried to create process but how to export data I can not figure out.

 

Like 0

Like

4 comments

Hello Ramnath,

 

It is better to use a standard scenario of specifying the filter and exporting records using the "Export to excel" action in the section. If you could create a script-task that could trigger the "ReportService" service and "GetExportToExcelKey" method inside this service based on the filtering parameters than this process could be executed. But we have no examples of this logic implementations so you need to look through the "GetExportToExcelKey" method and test it on your side.

 

Best regards,

Oscar

Hey Oscar,

 

I have very less development experience on Creatio Platform so I can't think I can develop scripts right now.

 

Rather I came up with another solution - Dynamic folder with access rights. So user will have access to the dynamic folder where they can filter record according to two fields. But I am unsure if giving them edit access may result in modifying the filter parameters. 

 

For example I want to find all the records that were created in between a period - I can create a dynamic folder with two fields -

(Created on > date_1 and Created on <date_2)

 

But having access to edit dynamic folder, the customer can also modify Created on parameter to modified on. 

RAMNATH SHARMA,

 

They cannot modify the Created On value of the record (since we are discussing the Created On column for records not for the folder itself (by the way they cannot modify Created On for folders as well)).

 

Yes, the client can modify the parameter itself (replace Created On with Modified On), but the client needs to understand that he/she shouldn't do it. By the way the client can create such a filter on their own (the possibility of advanced filters was developed for such proposes). Why there should be a process that should do this? It is easier to do it manually than via a process.

 

Also you can remove edit access rights for all users in the system using the "Change access rights" process element. As a result the client will see the folder, but won't be able to modify it.

 

Best regards,

Oscar

Oscar,

I thought of making the the process of exporting data easily with one click. That's why I wanted to see if it's possible with process.

Show all comments

Basing on the results of a vote held in the Creatio Community, the development team has planned a timeline for implementing improvements in Creatio product filtering tools. I am happy to let you know that, thanks to your active participation in the vote, the delivery of the vast majority of features is planned for Q3 and Q4 of this year. Hurrah! The team is still searching for a technical solution to task #3 "The ability to filter records from one or more dynamic groups". We will announce the possibility and delivery time a bit later.

Thanks to everyone who participated in the vote. You can always share your ideas, how to improve Creatio products in the "Ideas" section of Creatio Community. The product development team will definitely consider them. See ideas from other Community Members and participate in discussions.

Here is the Community’s rating of filtering enhancements for Creatio products:

 

Like 0

Like

Share

0 comments
Show all comments
Filtering
look up filters
7.15_()
Sales_Creatio_()

Dear mates,

In my opportunity products interest detail, i'd like to filter the inactive products.

How can i do that ?

Is it in the OpportunityProductDetailV2 that i must insert a filter ?

define("OpportunityProductDetailV2", [], function() {

    return {

        entitySchemaName: "OpportunityProductInterest",

        details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,

        diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,

        methods: {}

    };

});

Like 0

Like

2 comments

Dear Nicolas,

You can simply do it via business rules in UI: http://prntscr.com/qbw0eh. Filter by code must be inserted in OpportunityProductPageV2.

Best regards,

Angela

Thank you

Show all comments
account
7.11
Accounting
Filtering
Filters
7.11_()
Studio_Creatio_()

Hi Team,

We were trying to filter out the account classification. However, we were not able to add the field account classification which is present in the account section to filters. is there a way to add them into the filter so that it can be searched quickly? 

 

 

 

Thank you in advance, Gokul

 

Like 0

Like

2 comments

Hello Gokul,

This field that you are trying to add to the filtration is a detail and detail values cannot be read using 1 level filter. To achieve your task you need to build a complex filter using Academy article here.

Best regards,

Oscar

Thank you for replying Oscar. I tried adding the advanced filter too but the account classification is not coming as an option in the filter

Show all comments
Mobile app
Filtering
mobile

Hi all,

Is there any way to read all the existing records of sections in the mobile app without setting up individual filters? If yes, how?

 

Thanks 

Like 0

Like

1 comments

The mobile application doesn't have a section that contains all data. However, it's usually not needed. Probably, it will be possible to give you more information if you describe the business task.

Show all comments
Filtering
Custom Details
Filters

Hi all,

i want to ask on how to filter the filtration field.

i want this field shows only some data, not all.

how to do it?

 

thanks all..

 

Like 0

Like

1 comments

Hello Jordy,

You can do that in the following way:

1) Open the replacing object that is usually in the Custom package (in the configuration).

2) Open all settings of the object: http://prntscr.com/ioprlo

3) Then you can set the usage mode for the column as "None".

Please note that if you set such usage mode for the column, you won't be able to filter the records by it but also you won't be able to add this field to be displayed in the tile or list view in the section.

Best regards,

Oscar

Show all comments
Discussion
studio
7.14_()
Filtering
Ideas

I would like to be able to change the records that are can be viewed by the workplace that the section is viewed in and/or the current user role.  For example, if the section, Requests, is viewed by Product Quality Engineers in Product Qualification, I would only want to display Qualify a Product requests.

4 comments

Dear Janine,

Could you please give us some more details on your idea? Do you want display only those records in the section that are on some particular stage? Thank you for more details in advance.

Looking forward to your reply. 

Dean

Dean Parrett,

Whenever a user views records in a section, I would like to be able to filter the records that they can view by the Workplace they are viewing and their role.  It is irrelevant to the status of the record, but being able to filter by record fields and user characteristics would be helpful. I would like sections to look different depending on who is viewing them and where they are viewing them, rather than having to rely on lists in dashboards or folders.

Dean Parrett,

A good start would be to be able to select a default folder by Section, but it would be better if it was also sensitive to the Workplace the Section is in because Sections can be used in multiple Workplaces.

The Janine,

Thank you for the reply.

We've registered your idea and forwarded to our R&D team for consideration and implementation in future. Thank you so much for helping us to improve our product.

Best regards,

Dean

Show all comments
Discussion
Filtering

Please enable filtering more than one level deep.  For example, I set up a section for role assignments with contact and role.  Role has a boolean for determining if the role is appropriate for a specific process.  I can't filter an assignment selection in an edit page based on the boolean in the role. I also can't filter for more than one role.  Currently, the only way to handle this without development is to allow any assignment to be selected, then use a process to monitor the selection after the record is saved, which is suboptimal.

3 comments

Dear Janine,

Can you please specify in what part of the system you want this functionality? In business rules setup? 

Angela Reyes,

Yes, business rules is where I would use it right now.

Janine White,

Thank you very much for your idea! We have informed our R&D team so they consider enhancing this functionality in upcoming releases.

Best regards,

Anastasia

Show all comments