Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kgarvind
Partner - Contributor
Partner - Contributor

Section Access for Multiple Tables

Hi

I have a set of tables Company / Contact / Order / Employee / +5 More tables.

Each user (employee ) has access to a set of records

Employee

USER

DESIGNATION

NTNAME

JACK

MANAGER

DMN\JACK

DAVE

USER

DMN\DAVE

JOHN

SUPERVISOR

DMN\JOHN

Company_Access:

USER

COMPANY_ID

JACK

XX1

JACK

XX2

JACK

XX3

JACK

XX4

JACK

XX5

DAVE

XX1

DAVE

XX2

JOHN

XX3

JOHN

XX4

JOHN

XX5

Contact_Access:

USER

CONTACT_ID

JACK

YY1

JACK

YY2

JACK

YY3

JACK

YY4

JACK

YY5

DAVE

YY1

DAVE

YY2

DAVE

YY3

DAVE

YY4

JOHN

YY1

JOHN

YY2

JOHN

YY3

JOHN

YY5

JOHN

YY100

ORDER_Access:

USER

ORDER_ID

JACK

OR1

JACK

OR2

JACK

OR3

JACK

Or4

JACK

OR5

DAVE

OR1

DAVE

OR2

JOHN

OR3

JOHN

OR4

JOHN

OR5

SECTION Access;

SecureAccess:

LOAD

                NTNAME,

                [USER],

                EMPLOYEE_ID,

                COMPANY_ID,

//            CONTACT_ID,

//            ORDER_ID

FROM   C:\SecureAccess.qvd (qvd) where 1=1;

                                                                     

When I apply this section access – the user gets what he is entitled.

However

Problem 1 –

  • - The contacts / orders (atleast associated contact with the filtered companies / orders with that companies) are not being shown. They show blank

Problem 2 –

  • - If I enable the Associated Section Access   for Contact_ID & Order_ID as well
    • Some cases it shows everything or nothing

What am I missing / doing wrong

Any help is appreciated.

1 Reply
sundarakumar
Specialist II
Specialist II

I think this is a problem with strict exclusion. this option is available in the document properties where u enabled section access.

u filter the access with the employee id , then y would u again use company id.

As u r saying everything is blank, I guess this should be strict exclusion. try unchecking it. then u will see all data if u have restricted it by conflicting fields.

By conflicting fields I mean  for eg, u restrict data by employee id and company name. say an employee aaa belong to company xxx. and u have in section access table like

user   comany

aaa    yyy

this is where the strict exclusion will remove all the data and show a blank. pls use only the field that would be used as a filter in the section access. let this be at the lowest granularity that u would implement section access on.

Pls attach an sample app so that we could assign u more.

Regards,

Sundar