Set Form Filter Issue

xina_man

Hi there!

I'm having this issue using a form filter.
One of our customers is getting fused with another company, but instead of creating another company in navision they want to merge all the data in the actual company.
We've made some changes in order to manage the access of the users to de tables with common data.
Now my problem is, I created a filter in the OnOpenForm() trigger to filter the data by location code from the "Warehouse Entry" table, but the form gets so slow and I can only use it 1 minute after I open it... If I use the filter from the form properties it works OK, but using the filter in the trigger it gets realy slow.

What can I do to speed it up using the filter below???

FILTERGROUP(2);
CompanyCodeUnit.GetUserLocationFilter("Location Filter");
SETFILTER("Location Code", "Location Filter");
FILTERGROUP(0);

Thanks in advance!

DaveT

Hi,

What key are you using - does it include/start with location?

xina_man

DaveT wrote:

Hi,

What key are you using - does it include/start with location?

I was using the primary key!!!
I've changed it to a key that includes the Location code and now it works ok!

Thank you very much!:D

DaveT

Glad to Help