Section Access - for all values(Not Just *)

[#1]

Hi

I have 10 products named A,B,C,D,E,F,G,H,I,J

Using section acees I want to enable:

[ Reduction of Products ]

U1 to access A,B products

U2 to access B,C products

U3 to access all the products. products

How can I achieve it ?

[amit_saini]

Hi

First maintain an excel sheet. (See the attchment) after this write this script in your qvw :

Section Access;

Access:

LOAD ACCESS,

    NTNAME,

    upper(Product) as Product

FROM

[Give the path of excel sheet\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table is SectionAcess)

where 1=1;

Section Application;

PlantAccess:

load

    upper(Product) as Product,

    Product asProduct

FROM

[Give the path of excel sheet\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table isSectionAcess)

where 1=1;

Thanks,

AS