Slice don´t filter upon conditions

Good morning everyone. 
I have a condition in a slice to filter all records that meet the OK condition in the [ESTCONTRATO] field, and a second condition to filter based on the user. The problem is, I don't know why the filter isn't only showing those that meet the OK condition. 
The formula is the next:

AND(
    ([ESTCONTRATO] = "OK"),
    (LOWER([EmailUser])=LOWER(USEREMAIL()))
)

Thanks in advance,
Javier

Please test in isolation with one condition each so that you would know if any one or both are failing. Also in general wrapping email columns with LOWER() should not be necessary.
So, please test with slice filter of
[ESTCONTRATO] = “OK”
first and then with a slice filter of
[EmailUser]=USEREMAIL()

3 Likes

What makes you think it isn’t working? How are you reviewing the results?

2 Likes

Hi Steve.

Thank you for your answer.

I´m testing in appsheet. I send you attached a screenshot. In this example, some of the conditions are false, but I can see in the slice.

1 Like

Hi !!!

Thank you for your answer.

I tried onli with the slice filter [ESTCONTRATO] = “OK”, but I can see al the records: the records with OK and the records with NO.

1 Like

Please share the possible values that the column [ESTCONTRATO] can have and has in the backend table. Is it an enum column?

2 Likes

Hi !!!

The values for this column can be: OK or NO.

I want to filter the records with OK value.

This column is in text format

Captura de pantalla 2025-12-12 155926

1 Like

Please post screenshots of the configurations of the views of the slice.

2 Likes

Is it what you said?

That’s the slice configuration. I’d like to see the view configurations from UX > Views. The detail view, at least.

3 Likes

Hi Steve.

I attach two screenshots of the view:

I think Steve has asked for the detail view configuration.

1 Like

Sorry!!

Is this the right view? The value that I want to filter is OK, but I get both values, OK and NO

Please share the configuration of the view by selecting view as encircled in red below.

2 Likes

Hi !!!

I send you the detail in 3 screenshots. If you need something else, please, tell me.

Hi you all !!

I forgot to tell you that in the field [ESTCONTRATO] I got the result with a formula:

My quick test showed that it is working in the test pane. Could you update if you were able to verify how the slice expression behaves in the test pane?
Result for the record with “OK” value

Result for the record with “NO” value.

1 Like