How can I remove a user's filter?

afarr

Our client has a customised item form (Form 50070). When I login in as 'abc' and open this form, there is a filter "Location Filter" = A123. In particular, this means that I only see the inventory for location A123.

User 'abc' does not see this filter in the usual item form (Form 30), so the total inventory for the item is visible from Form 30.

When user 'abc' logs in at the same time from a different machine, the filter does not appear on Form 50070, but it does appear when a different user logs in on the same machine.

So the filter is somehow associated with Form 50070 when opened from a particular machine.

Even when I restart the machines that host the client and server (this is not the actual client database of course, just a copy) the filter is still there.

I checked the user's security filter (Tools - Security - Database Logins - Roles - Permissions) for form 50070 and it's empty.

This doesn't look like it's being set through code, and in fact:
1. Form 50070 was last modified years ago, whereas this filter only appeared in the last few days.
2. When I turn on the debugger I can see the filter even before the first line of code in OnOpenForm has been executed.

Do you know how I can remove this filter?


Thanks in advance.
Alastair

Tvis

How you tried removing the users zup-file?

Just copy it somewhere then delete it and see if the filter is still there

tinoruijs

The filter is probably stored in your zup-file.
Have you tried to remove the filter (Shift+Ctrl+F7), close NAV and login again?
Is the filter still there then?

afarr

Thanks, removing the zup file did the trick.

I should have known that, but for some reason I couldn't find the zup file last week. I found it now, in
Documents and Settings\afarrugia\Application Data

tinoruijs

afarr wrote:

Thanks, removing the zup file did the trick.

Nice. 8)

But removing the filter should have been enough.
That way you can keep your other settings.

afarr

No, I repeatedly tried to remove the filter (through Ctrl+F7) and it wouldn't go away.

Actually, when I pressed Ctrl+F7, the filter didn't appear, but when I looked up field "Location Filter" it showed that it was filtered to A123.

I don't know if this is standard behaviour for FlowFilters.

tinoruijs

afarr wrote:

No, I repeatedly tried to remove the filter (through Ctrl+F7) and it wouldn't go away.

Actually, when I pressed Ctrl+F7, the filter didn't appear, but when I looked up field "Location Filter" it showed that it was filtered to A123.

I don't know if this is standard behaviour for FlowFilters.

You have to remove a flowfilter in the form that's opens with Shift+F7.

afarr

Thanks, I wasn't aware of that.
I think this will save me a lot of time in future.

tinoruijs

Btw; Shift+Ctrl+F7 does not remove flowfilters, so you always have remove that manually.

JedrzejT

Hi,

Sometimes if You dont want to remove all personal setting of user with "problem" filter by delete Zup file, You can just compile form in which user can't remove filter.
In this case You remove all zup setting on this form for all users. Most of customers have basic form designers and can hadle this situation on their side.

Regards

afarr

Thanks - I didn't know that either.

I just tried this, and when I compiled without saving, the filters remained there. But when I saved the form, the filters were removed.