0

Filtering by first record

 

Hi All,

I would appreciate some help with filtering a table view. How can the lines for only the first record of each customer be shown?

thanks

6 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    If the child is Orders and the parent Customers, a table view of Orders can be filtered to only show true records of this formula

    Id = first(Customers.Orders)

    Regards John

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

      John Halls 

       

       

      Hi John,

      Thanks for looking!

      The Parent is Appointment.

      The child is Order.

      The current filter is:

       

      let t := this;

      (select Order)[Appointment = t][Customer]

    • John_Halls
    • 2 yrs ago
    • Reported - view

    Hi Sam

    Does your code work?

    If these are linked you don't need the select statement. I don't understand the two pairs of square brackets. Is Customer a field?

    Regards John

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

      John Halls Our messages were in transit at the same time.

      John Halls I’ll try it as you mentioned without the select 

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

      John Halls yes, customer is a field

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

    John, The return I have is the first Order record only.

    I’ll keep working at it and let you know.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 6Replies
  • 80Views
  • 2 Following