Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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
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
Hiya
Brill thank you worked really well
Kind Regards