Section Access - for all values(Not Just *)

Tue, 11 Mar 2014 11:17:23 GMT

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 ?

Re: Section Access - for all values(Not Just *)

amit_saini — Tue, 11 Mar 2014 11:35:07 GMT

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,