IF {@PASS_User} = "Admin" THEN
(
{usp_BB_InvoiceListing_01;1.BranchID} = "7a229196f28249f797ca"
)
ELSE
(
IF {@PASS_User} = "AaronP" THEN
(
{usp_BB_InvoiceListing_01;1.DB_Classification} = "9a9c17ecb477450d8288"
)
ELSE
(
{usp_BB_InvoiceListing_01;1.DB_Classification} = 'ZZZZZZZZZZ0000000000' OR {usp_BB_InvoiceListing_01;1.DB_Classification} = '1fc7657fa21b443b8b6b' OR {usp_BB_InvoiceListing_01;1.DB_Classification} = '4fbedf4b311449eeb898'
)
)
Users browsing this forum: No registered users and 1 guest