Hi
Im fairly new at this so bare with me.
I have been trying to create a new slice with the query below, testing and viewing the data from the slice works perfectly and i have all the data i need, problem is when i create a view of that slice i get no items shown !
Filtering Query :
ISNOTBLANK(Select([Formations Stagiaire][Stagiaire], (
or(
and(
today() >= ([Date de debut] - 3),
or(
and(IN(“pré-formation”, [Tests][type]), IN(“No”, [Tests][Disponibilité])),
and(IN(“Questionnaire de motivation”, [Questionnaires][type]), IN(“No”, [Questionnaires][Disponibilité]))
)
),
and(
today() >= (IF(ISNOTBLANK([Date de fin rectifiée]), [Date de fin rectifiée], [Date de fin]) + 10),
or(
and(IN(“post-formation”, [Tests][type]), IN(“No”, [Tests][Disponibilité])),
and(IN(“Questionnaire de fin de formation”, [Questionnaires][type]), IN(“No”, [Questionnaires][Disponibilité])),
and(IN(“Avis Google”, [Autres documents][type]), IN(“No”, [Autres documents][Disponibilité]))
)
)
)
)))
Can you post a screenshot of your view definition?
Displaying all the data in a slice should be super straight forward and I see no reason you are not getting any data displayed.
1 Like
Exactly
Nothing special about the view. I have other slices with views similar to this and they work perfectly
the only thing that i can think about is the filter/condition query but i have no way of knowing where its coming from since its executing with no errors and it shows me the correct results when i view the slice data
I believe this is because of a bug.
See my previous post.
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Slice-view-rendering-wrong-set-of-rows/td-p/438561
I reckon AppSheet dev team is currently working on to bring a fix.
What you can do (for now until a fix is released), you push the slice condition (expression) into VC, which would return yes/no. Then you use that VC for slice condition. Then it would work, although it is not ideal solution.
4 Likes
It worked !!
Thank you, i will use this temporarily until the issue gets fixed
Any idea if there is an bug tracker for this ?
1 Like
Yes, all the columns are used
I have used the solution suggested above by @Koichi_Tsuji and it works. Its a temporary fix until the bug gets fixed
1 Like
As far as we know (based on the last communication with AppSheet), a fix is in their hands, and introduced gradually. I have no ETA, but hopefully soon.
@Aleksi
@Adam-google
2 Likes
@Koichi_Tsuji Thanks, the VC approach worked.
It seems this issue still not resolved, @Koichi_Tsuji @KZA_ALM @koma25 @TeeSee1 Can you please confirm.
