AnsweredAssumed Answered

Sorting by 2 different sort parameters concurrently

Question asked by JohhnyHilly on Sep 19, 2014
Latest reply on Sep 21, 2014 by philmodjunk

Title

Sorting by 2 different sort parameters concurrently

Post

I am wanting to sort records based on 2 parameters in the following order but can't quite get it:

1. By Property name; then
2. on whether a bill has the status of Paid or Unpaid

The script to show all bills for a single property works well, but my script for the Paid and Unpaid shows ALL bills (paid or unpaid) for all properties, not the one selected. What step do I need to put in here to take the bills from the property selected?

Go to Layout [Bills (Bills)]
Enter Find Mode[]
Set Field [Bills::Status; "Paid"]
Set Error Capture [On]
Perform Find[]
Sort Records

Outcomes