0

Filter a view by Id

Hi Again,
We need a little help filtering a view.
The view is in an appointment table and selects/views the invoice table lines.
I’m trying to filter only the lines associated with the current Appointment Id.
We do not want to manually perform the filter each time there is a new appointment/invoice.
The results of the code used yields the first Id not the last/current in the line table.
Anyone have an easy fix to this code?

(select AppointmentLine)[Appointment.Id]

Thanks 

2 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    If you are in the appointment table then: 

    let t := this;
(select AppointmentLine)[Appointment = t]

    If you are in some other table then you can just adjust the t to include the path to the Appointment table (a reference field, or dymanic choice/multi choice, etc).

    • Sam.1
    • 3 yrs ago
    • Reported - view

    Works perfect⭐️
    thanks again Fred!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 102Views
  • 2 Following