omit 3rd column section access

[joeybird]

Hiya

i have seen two posts from hic

i have used the following similar content like this in an app, first post from hic

Load Region &'|'& Product as AuthID, Region &'|'& Product as %AuthID  From OrderDetails ;

     Load Region &'|'& Product as AuthID, Region &'|'&'<ANY>' as %AuthID  From OrderDetails ;

     Load Region &'|'& Product as AuthID, '<ANY>'&'|'& Product as %AuthID  From OrderDetails ;

     Load Region &'|'& Product as AuthID, '<ANY>'&'|'&'<ANY>' as %AuthID  From OrderDetails ;

second post from hic 

Data Reduction Using Multiple Fields

issue i have is this is for section access relating to two columns of data...Region and Product...

i for example need to restrict on columns Region and Product...and CompanyName..

how is this achievable?

please help...

[ogster1974 · Accepted solution]

By extending your cases to include CompanyName. e.g.

Load Region &'|'& Product &'|'& CompanyName as AuthID, Region &'|'& Product &'|'& CompanyName as %AuthID  From OrderDetails ;

......

Although you might be able to get away without using Region if you are now using CompanyName as a security identifier if a Company belongs to a Region.

Regards

Andy

[joeybird]

Hiya

Brill thank you worked really well

Kind Regards