Solved: Expression of ref column - Page 2

aminsaleh · 05-18-2023 12:22 PM

Hello everyone

In my App I have a table called "Orders"

It contains a column called "Driver" of type REF

>> The "driver" column refs to a table called "Driver Ca"

>>> "Driver Ca" table contains a column called "driver" which stores the name of the driver and a column called "Email" which stores the driver email.

----------------

Now in the "Order" table I've added a new slice called "Delivery Ca" and I want to make a row filter condition where ....

if (driver) column in (order) table MATCHES (driver email) in (driver ca) table

then that row will be shown

I've tried with THISROW but it hasn't worked.

please any help

aminsaleh

@Izzat_Safrah

@dbaum

Thank you all, I've read some posts and finally I am able to solve it 🙂

> Here is what I did:

►In "Driver ca" table I made Email column as a key.

► In slice " Delivery Ca" in table "Orders" I wrote this code to filter rows.

And(
[status]="Processing",
[Pickup Delivery]="Delivery",
USEREMAIL()=[Driver].[Email]
)

and now each driver can only see his/her own rows.

Thank you all indeed

View solution in original post