Section ACCESS QUERY

[hariprasad_koya]

Dear Team,

I have written a section access code in the attached QVW and below is my query regarding this.

i have a transactional data at 2 Companycodes-IN01,IN02 and INDIA data is not there in the transactional table and i need to generate using INA+INB  and i have done it using INLINE Table

i want the below requirement regarding the section access.

For ADMIN,the data should show up only for INA,INB,INDIA(Company Name)

For CAN,the data should show up only for INA

For USA,the data should show up only for INB

You can open the QVW using the below credentials.

USERID : ADMIN

Password : ADMIN

Kindly provide the solution .

Thanks,

Hari

[hariprasad_koya]

Dear Team,

Kindly request to respond as it is very urgent sceanrio.

Regards,

Hari

[maxgro]

try this

Star is *;

Section Access;

LOAD * INLINE [

  ACCESS,USERID,PASSWORD, COMPANYNAME

  ADMIN,ADMIN,ADMIN, INA

  ADMIN,ADMIN,ADMIN, INB

  ADMIN,ADMIN,ADMIN, INDIA   

  USER,CAN,CAN, INA

  USER,USA,USA, INB

];

Section Application;

CompanyMaster: 

LOAD *, CompanyName as COMPANYNAME

inline [

CompanyNo,CompanyCode,CompanyName

1,IN01,INA

2,IN02,INB

3,IN01,INDIA

4,IN02,INDIA 

  ];

// remove USERID

LOAD CompanyCode,Value

inline [

USERID,CompanyCode,Value

CAN,IN01,1000

USA,IN02,2000

];

[muthukumar77]

Refer this app,