Hi, I am trying to create a slice of data where I have project status but this is a enum reference of another table called status.
This is the query [Status]<>‘Complete’
When I test the slice it gives the data within that column the value _SLNPnb49l4Lqah-1a_jP1 I am guessing this is rowID?
I have tried query [Status]<>‘_SLNPnb49l4Lqah-1a_jP1’ but it is still showing the rows with that value in the test data.
Its probably simple but I am new at this.
Thanks
Alex