Filtering content data

abhishek_prabhakar · November 24, 2021, 7:30am

I have…

[ #] Read the following guideline: https://docs.squidex.io/01-getting-started/installation/troubleshooting-and-support. I understand that my support request might get deleted if I do not follow the guideline.

I’m submitting a…

[ ] Regression (a behavior that stopped working in a new release)
[ ] Bug report
[ ] Performance issue
[ ] Documentation issue or request

Current behavior

Expected behavior

Minimal reproduction of the problem

Environment

[ ] Self hosted with docker
[ ] Self hosted with IIS
[ ] Self hosted with other version
[# ] Cloud version

Version: [VERSION]

Browser:

[# ] Chrome (desktop)
[ ] Chrome (Android)
[ ] Chrome (iOS)
[ ] Firefox
[ ] Safari (desktop)
[ ] Safari (iOS)
[ ] IE
[ ] Edge

Others:
Hi Sebastian,

I have a few queries related to filtering of content

I want to filter my content based of some condition on attribute of referred content available as reference.
ex: I want to display the shows for the movie(reference) having shows for next week
I want to display filter content from unfiltered content having any of the given value from a list of values
ex: I want to display the shows for a movie from given list of movies

Kindly let me know if any of these is currently available in cloud version or how can we implement this on our local version!

Sebastian · November 24, 2021, 8:13am

Hi,

1 I want to filter my content based of some condition on attribute of referred content available as reference.
ex: I want to display the shows for the movie(reference) having shows for next week

This is not directly possible, but you can solve it with graphql the reverse direction:

Something like this:

query {
   queryShowContents(filter: "data/date/iv gt <MONTH_START> and data/date/iv lt MONTH_END) {
     id,
     data {
        movie {
            iv
            data {
               title {
                 iv 
...

I want to display filter content from unfiltered content having any of the given value from a list of values
ex: I want to display the shows for a movie from given list of movies

If you do not want to filter the shows something like this is possible

query {
   queryMovieContents(...) {
      id,
      referencingShowContents {
        id,
        data 
        ...
   }
}

If you want to filter the shows as well then there should be an “IN” operator for the movieId, like this:

$filter=data/movie/id in ('id1', 'id2', 'id3')

abhishek_prabhakar · November 24, 2021, 9:22am

for 1st one i think i have given wrong example, I need all the shows of movies directed by “xyz”
where director is property of movie not “shows/director/iv”

Sebastian · November 24, 2021, 2:33pm

It is the same principle:

query {
   queryDirectorContents(filter: "data/name/iv eq 'George Lukas') {
      data {
          movies { 
              ...