0

Query help - pulling list of all staff working on a specific day

I have 2 tables joined by a third table 

  • Event Details - List of all our gigs
  • Staff 
  • event_staff_join

I need to display a list via a View on a page to show me all staff assigned to work on any gig in Event Details that match a specific date. How do I write that select statement? 

1 reply

null
    • Fred
    • 4 hrs ago
    • Reported - view

    You probably have a date field on this page. You probably have a date field in the Event Details table. I think this will work regardless of how many Event records get returned (I don't have time to create a test DB).

    let selectedDate := Date;
(select 'Event Detail' where Date = selectedDate).event_staff_join

    Assuming that you didn't rename the event_staff_join reference link in Event Details. Otherwise change it to match the name.

    If on this page you have the ability to select an Event then you can just use that reference (either through the hard link or a dynamic choice) to get the event_staff_join records.

Login to reply

Content aside

  • 4 hrs agoLast active
  • 1Replies
  • 3Views
  • 2 Following