Skip to content

Instantly share code, notes, and snippets.

@ricardocasares

ricardocasares/free_rooms_groq.js

Last active December 1, 2022 23:17
Show Gist options
  • Save ricardocasares/aef9f9fffe48e91fdd37cfae7b28405e to your computer and use it in GitHub Desktop.
Save ricardocasares/aef9f9fffe48e91fdd37cfae7b28405e to your computer and use it in GitHub Desktop.
Download ZIP
GROQ Queries
Raw
free_rooms_groq.js
export const FREE_ROOMS = groq`
*[_type == 'room' && count(*[_type == 'booking' && ^._id in room[]._ref && ((checkin >= $ci && checkin <= $co)||(checkin <= $ci && checkout >= $ci))]) == 0]{...}
`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment