I realised Navision Attain 3.01 has a new feature called Security Filter. It appears to enhance the security feature in Navision. But i cannot fiure how to make it work. anybody has any ideas?
Hi, The security filter is only working in SQL option only. Be careful of your setting. It will affect the workflow. Richard
It is true. Security filter functionality is realized in Attain. The field “Security Filter” is appeared in Role permissions setup window. Any Navision-style filter can be applied in this filed to any TableData object. NA builds SQL enquiry statements with the “WHERE” clause based on corresponding “Security Filter” field value expression. You can examine it by MS SQL Server Profiler. Unfortunately, it does not work in Navision Server based version of NA as well as in local database file based version. Regards, Yuri Pokusaev IBS, Senior Consultant NCPS, NCSD firstname.lastname@example.org +7(095)987-8080