Hey, Community

I'm trying to implement a custom filtering logic for quickfiltering of records and to do the same i'm trying to retrieve the value  from the request using the crt.HandleViewModelAttributeChangeRequest. However, the value is being logged as Proxy(nt) due to security reasons.  I'm wondering if there's a way to bypass this limitation in order to obtain the desired result for a custom quick filter. I've attached some photos for reference.



Like 0

Like

4 comments

Hello Vishal,

 

Please clarify what task exactly you want to achieve. Do you need to get the filter itself?

Hey ,Oleg Drobina,

While entering the value in quick filter, dropdown values need to be filter based on first letter. 

For ex: if i enter 5 , it should show the values start with 5. 





thanks,

Vishal

 

vishal,

 

Understood, thank you!

 

As an option you can change the value in the StringColumnSearchComparisonType system setting to 0 and relogin to the app. In this case the filtration will be performed using the "Starts with" option. There is no inbuilt comparisonType property in the component metadata and the system setting is applied to all filters in the system (in this case if you need to use the "contains" option there should either an advanced filter used or use comparison with the % symbol "like '%5%')

Thank you, Oleg Drobina.

 

Show all comments

Hi all,

 

How would one add a boolean type static filter to a section (similar to the Active flag in the Process Library)?

 





I have a field called UsrActive in my section and I'd like to have this filter applied by default.

 

Nb. I'm not currently using Freedom sections.

Like 0

Like

1 comments
Best reply

Hello,

 

In order to implement such logic in the Classic UI additional development is needed. You may refer to the below post for an example of similar implementation:

https://community.creatio.com/questions/please-help-how-add-custom-filt…

 

Best regards,

Anastasiia

Hello,

 

In order to implement such logic in the Classic UI additional development is needed. You may refer to the below post for an example of similar implementation:

https://community.creatio.com/questions/please-help-how-add-custom-filt…

 

Best regards,

Anastasiia

Show all comments

Hi Community,

I've this situation where I need to get the value from a section quick filter and use it on another filter. For example, I've two quick filters one for the Accounts and other for Contacts. I want to filter the Contact Filter values based on the Account I've selected.

In other words, if the Account is "Teste1", my Contact Filter should return all the Contacts that belong to the "Teste1" Account.

 

Any sugestion on how to achieve this?

 

Thanks in Advance.

 

Best Regards,

Pedro Pinheiro

Like 2

Like

1 comments

Hi Pedro,

 

The logic of the drop-down list forming in the quick filter is stored in the CustomFilterViewModelV2 model inside the getLookupValueColumnList function. Your question cannot be solved easily since there is a need to override the module method logic completely and it's not recommended to do. I will create a problem for our R&D team so they could develop the logic of filtering the drop-down result of one filter condition based on the value of another filter condition.

 

Thank you for the idea and helping us in making the application better!

 

Best regards,

Oscar

Show all comments

Hi everyone,

 

I would like to know how can i add quick filters for a detail, like the ones used for section pages. (check print bellow)

 

I've tried to implement this Quick Filter in the same way i implemented the section pages one, without success.

 

 

 

File attachments
Like 1

Like

1 comments

Hello Pedro,

 

Similar questions were previously reviewed on the Community here https://community.creatio.com/questions/quick-filters-detail and here https://community.creatio.com/questions/prefilter-detail-grid-page-load. Please use these articles I've mentioned so to resolve your business task.

 

Best regards,

Oscar

Show all comments

I am developing a custom search block in 'Contact Section'.  In a Contact section, I have one child entity that contains 2-3 MRN number for one contact. So I want to add a custom search field with MRN number. If I search with any MRN number of contact then it should filter contacts. So, can you please provide me with any article or example so I can proceed.

image.png

image.png

 

Above is my screenshot for child entity and contact list. I want a filter for contact with above mentioned MRN number.

 

Please guide.

Like 0

Like

4 comments

Dear Riddhi,

Unfortunately, the screenshots you have attached are not displaying correctly. Though, please take a look at the following article. There is an example of quick filter implementation. As I have understood from your explanation, such filter can cover your business task:

https://academy.bpmonline.com/documents/technic-sdk/7-13/adding-quick-filter-block-section

If you will have any question, or this approach does not suit you, please let us know why and we will be happy to advise.

Regards,

Anastasia

Anastasia Botezat,

Hello,

Above article is providing me fixed filter over list section. But I want my custom dropdown with custom values to fill in it. I will bind those values from a dynamic database. I don't want a predefined filter to fix on search section.

 

I want to add my own filters to FilterContainer.

Riddhi Jadeja,

In this case you need to create a functionality from scratch to proceed the values you receive from third-party. 

Unfortunately, we do not have a ready code snippet, though, the approximate algorithm can be the following:

1. You add a dropdown to the section replacing schema. This can be just regular dropdown created by the means of JavaScript and added to the GripUtilitiesContainer for example. The other option is to take Owner filter from the article and pass values to the filter. In this case inspect the filter realization to create your own.

2. Receive values for the dropdown. This can be done when section initializes, so launch and API call, or web service call ( which one you use for integration) and store values to the virtual column e.g., or in any other comfortable way (new array, object e.t.c.) 

MyField: {
   dataValueType: Terrasoft.DataValueType.COLLECTION,
   type: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN
},

3. On dropdown value picked pass a filter to the fixedFilterConfig.

Hope you will find it helpful!

Anastasia

Anastasia Botezat,

Thank you.

Show all comments

I have a child section(with two fields) in a Contact Section. In that section,  I want to add customize search filter with a child entity column. So I got help from the support team like below:

  • Secondly, into method getFilters() you should write the next script(example for OEMGroup):

var oemGroup = this.get("VistOEMGroup");

if (!oemGroup) {

                filters.removeByKey("VistOEMGroupGroupFilter");

} else {

filters.add("VistOEMGroupGroupFilter",Terrasoft.createColumnFilterWithParameter(

Terrasoft.ComparisonType.EQUAL,"VistOEMGroup", oemGroup.value));

}

 

But I don't know that getFilters() method already exists or do I need to add this to 'methods'.

Please help.

Like 0

Like

2 comments

Please override the getFilters() method in the "methods" property. Please find more information about methods on academy by the link below: https://academy.bpmonline.com/documents/technic-sdk/7-13/methods-methods-property

Alina Kazmirchuk,

Thanks Alina.

Show all comments

Hi,

I implemented a method for quick filter on section page based on the following link

https://academy.bpmonline.com/documents/technic-sdk/7-13/adding-quick-f…

The filter i created is based on the Accounts object. I would like that the users can only select a subset that contains a bollean with a true value.

Is there any parameter in the initFixedFiltersConfig method that does that?

Thanks.

Best regards,

Nuno Gonçalves

Like 0

Like

1 comments

Dear Nuno,

You can take an "Active" filter in Process Library section as an example for your functionality. 

Please inspect the BaseProcessLibSection schema code for more details on the filter. In has a container and filter insert:

		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",
				"name": "HasActiveProcessFilterContainer",
				"parentName": "FiltersContainer",
				"propertyName": "items",
				"index": 0,
				"values": {
					"itemType": this.Terrasoft.ViewItemType.CONTAINER,
					"wrapClass": ["active-process-filter-container"],
					"items": []
				}
			},
			{
				"operation": "insert",
				"parentName": "HasActiveProcessFilterContainer",
				"propertyName": "items",
				"name": "HasActiveProcessFilter",
				"values": {
					"caption": "Boolean filter",
					"controlConfig": {
						"className": "Terrasoft.CheckBoxEdit",
						"checkedchanged": {
							"bindTo": "onActiveProcessFilterChecked"
						}
					}
				}
			}
		]/**SCHEMA_DIFF*/

Also method which is triggered by click - onActiveProcessFilterChecked.

You can use it as an example and add your own filter.

Regards,

Anastasia

Show all comments

Hello everyone,

 

I'm trying to add some custom quick filters to bpm solutions I'm working on. Specifically I need to add filters for dates: 30 and 60 days (Creation date until Current date), which are similar to the 1 and 7 days already provided. And Team based filter, similar to the employee/owner one, but instead of 1 person, 1 team (which might include several employees in a custom object)

Has anyone done anything similar? If so,how?

I've already read through this post https://academy.bpmonline.com/documents/technic-sdk/7-13/adding-quick-filter-block-section but has not answered my questions.

 

Thanks!

Ignacio

 

 

Like 0

Like

2 comments

to further clarify. Is there a way to do this from the original code for quick filters?

Technically the buttons are in the "FixedFilterViewV2" module. But it will be very hard to modify it. I think that it will be easier to create your own control and place it to the container with the buttons with the same style.

Please find more information in the article by the link below.  

https://community.bpmonline.com/articles/how-create-custom-control-element

Show all comments