How to remove the custom filter added to a lookup?

(0) Share

Report

Posted on by Community Member

We have a scenario where in we need to dynamically set a custom filter to a lookup but the problem is that when we add a new custom filter the previous filter stays on the lookup. Is there a way on how to remove the previously added custom filter on a lookup? Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report

Hello,

You can try to follow the instructions from the below mentioned link:-

inogic.com/.../add-custom-view-in-lookup-and-disable-all-the-other-views

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
ScottDurow 21 on at

Like (0)

Report

You simply need to set the filter each time the lookup is opened in the presearch event. If there is no filter then don't set it. There is no way of removing the filter once added in any given presearch event.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (0)

Report

Hi,

If i am not wrong you can disable the other filter which one you don't want to get.

Please see the link below:

community.dynamics.com/.../add-custom-view-in-lookup-and-disable-all-the-other-views

Hope you might be get any solution!!

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Rajkumar,

Thank you for your reply but we are not adding a custom view instead we are adding a filter on the current view.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Scott,

What we are currently trying to implement is a dynamic filter on Many to Many relationship subgrid, that whenever a user add/remove a record on a subgrid (Subgrid 1 lets say) we retrieve all the related record (account lets say). Then on the 2nd subgrid only the related record to subgrid 1 should display and we were able to accomplish this via addCustomFilter. Now the problem is if there are 2 records on the subgrid 1, and we remove one of the record (record 2) lets say, the previous filter for record 2 still stays on the lookup but should be removed.

Is there a way to refresh a lookup? By that we are hoping that the customFilter added will get removed.

We have some more days before the demo :s

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Jharana,

Thanks for the response but we are not adding a custom view but instead using addCustomFilter. But we are thinking of if resetting the view of the lookup will remove its custom filter? We will try this tomorrow. Thanks :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Up...

Was this reply helpful? Yes No
ScottDurow 21 on at

Like (0)

Report

The addcustomfilter method only works in lookup fields and does not work on sub grids. To implement a filter on a subgrid you will need to create a custom webresources using html. Do you really mean subgrid as in a grid added to a form?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Scott,

What we are filtering is the look up on the sub-grid. We added a JavaScript that runs on click of + on the sub-grid then access the sub-grid lookup and add custom filter to that lookup.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Scott,

Even though you've spoken about removing the filter, I still have some hope for possible workaround.

Let me introduce you to my specific case. Phone Call form: filter Call From/Call To field based on Regarding object, depending on Direction.

I am currently using .addPreSearch with .addCustomFilter to filter out Call To on outgoing call. On changing the Direction to incoming, the filter does its magic again and sets on the Call From lookup field. Unfortunately, Call To still remains filtered.

I have tried using .removePreSearch or overriding this saved custom filter with other XML filter. No luck so far.

Is there anything worth trying in order to achieve this kind of behavior in my case?

Cheers,

Łukasz

Was this reply helpful? Yes No