topic omit 3rd column section access in App Development

omit 3rd column section access

joeybird — Mon, 11 Jan 2016 12:15:03 GMT

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...

Re: omit 3rd column section access

ogster1974 — Mon, 11 Jan 2016 13:28:57 GMT

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

Re: omit 3rd column section access

joeybird — Tue, 12 Jan 2016 14:24:08 GMT

Hiya

Brill thank you worked really well

Kind Regards