Using filter groups via API?

API & Programming
1

Using the API, is it possible to filter entities using filter groups?

My app enables users to schedule an appointment. They can filter the available appointment slots based on the required skill (of the workers assigned to the slot).

Workers are pre-assigned to appointment slots, but they are divided using two relationship fields; “coaches” and “fixers”.

I want to search for available appointment slots, based on the specific skill of a coach OR a fixer. Results have to be after a specific date.

Right now I have:

"q/where": [
    "q/and",
    [">", ["q/start", ["Appointments/Timeslots"]], "$today"],
    ["=", ["Appointments/Available Coaches", "People/Skills", "fibery/id"], "$coachType"]
]

Something like this?

"q/where": [
    "q/and",
    [">", ["q/start", ["Appointments/Timeslots"]], "$today"],
    [
        "q/or",
        ["=", ["Appointments/Available Coaches", "People/Skills", "fibery/id"], "$skillType"],
        ["=", ["Appointments/Available Fixers", "People/Skills", "fibery/id"], "$skillType"]
    ]
]
2

You can match any filter conditions available in the browser when you make queries.
Fun fact: under the hood the website is making the api call and then returning the results as the page loads.

Whenever I need to make a complex query I open developer tools to see network activity then open a view that matches the search. Find the activity that contains the command/ query api call and review the inputs. That’s the exact api call you want to make.
Copy + paste

1 Like
3

Thank you, that’s a really good trick. I never thought of that!

1 Like
4

It is possible to use filter groups, using the trick from @helloitse I found the correct syntax:

"q/where": [
    "q/and",
    [
        ">",
        [
            "q/start",
            [
                "Appointments/Timeslots"
            ]
        ],
        "$yesterday-date-time-end"
    ],
    [
        "or",
        [
            ">",
            {
                "q/from": [
                    "Appointments/Available Coach Skills"
                ],
                "q/select": [
                    "q/count",
                    [
                        "fibery/id"
                    ]
                ],
                "q/where": [
                    "=",
                    [
                        "fibery/id"
                    ],
                    "$coachType"
                ],
                "q/limit": "q/no-limit"
            },
            0
        ],
        [
            ">",
            {
                "q/from": [
                   "Appointments/Available Fixer Skills"
                ],
                "q/select": [
                    "q/count",
                    [
                        "fibery/id"
                    ]
                ],
                "q/where": [
                    "=",
                    [
                        "fibery/id"
                    ],
                    "$coachType"
                ],
                "q/limit": "q/no-limit"
            },
           0
        ]
    ]
],