Hi,

I am facing some problem regarding document type security permission roles and users. I have a document type and its name is "Documents" for attachment document files. In this document type there are 3 fields which we want to use in my customized Search Filter. That fields are Groups, Type, and Date. In my customized Search Filter I have 3 different drop-downs on the Search filter user control. 1st for Groups, 2nd for Types and 3rd for Years of the Documents date (this data we are fetching from the custom document type table suppose in the document table data there are 5 entries and its posted years are 2000,2005,2011,2012,2012 in that case year drop-down contains only 2000,2005,2011,2012 data and this data will be fetched from document tables and Groups and type are custom table data). By using CMSDesk panel, Administrator can assign security permission to any Document to any particular User-Role or Individual User by using Properties -> Security Section. In my site there are 7-8 different different roles available.

Now my client wants Suppose if administrator assign security permission to Document1 and assign to various User-Roles like role1 and role2 in that case this document doesn't display to role3, role4, role5, role6 and role7. Its works fine but clients wants that if Document1 posted year is 2000 and its assigned to role1 & role2 and deny permissions to other roles in that case if role3 user login into site at that time in Year Drop-down filter doen't contains 2000 year because role3 user doesn't have permissions to read Document1.

In a simple language how to read document type security permission setting by using any webparts or by using any SQL Query or any other way??