Sorting Values based on a certain Field Name and then Rendering to Table

Sorting Values based on a certain Field Name and then Rendering to Table

I have a table that is getting all the correct values, and the only thing I want to do is sort this table when rendered by the Date_of_Invoice. I cannot figure out for the life of me how to do this or where to begin. Any help would be appreciated. Here is the code:


  2. <div class="divTableHeading3">Section C: Trust Distribution Payments</div>
  3. <div class="divTable1">
  4. <div class="divTableBody">
  5. <div class="divTableRow">
  6. <div class="divTableCellB">Trust</div>
  7. <div class="divTableCellB">Amount from Trust</div>
  8. <div class="divTableCellB">Attorney Fees</div>
  9. <div class="divTableCellB">Amount to Client Expenses</div>
  10. <div class="divTableCellB">Medicare</div>
  11. <div class="divTableCellB">Disb. to Client</div>
  12. <div class="divTableCellB">Date of Check</div>
  13. </div>
  14. <%
  15. TrustDistinct = Finances[Display_Name == searchParam && Line_Item.containsIgnoreCase("Trust")].distinct(Line_Item);
  16. // fetchDates = Finances[Display_Name == searchParam && Line_Item.containsIgnoreCase("Trust")].Date_of_Invoice;
  17. // Sorting by name of trust, need sorting by date of check/invoice
  18. for each  Expense in TrustDistinct
  19. {
  20. // Add all of same trust together to get total for each field
  21. DisbursementFromTrust = Finances[Display_Name == searchParam && Line_Item == Expense].sum(Amount);
  22. DisbursementFromTrustFormatted = "$ " + DisbursementFromTrust.round(2);
  23. //TMCo is equal to Trust Management Company
  24. AttorneyFees = Finances[Display_Name == searchParam && Type == "Attorney Fees" && Line_Item == Expense].sum(Amount);
  25. AttorneyFeesFormatted = "$ " + AttorneyFees.round(2);
  26. AmountToClientExpenses = Finances[Display_Name == searchParam && Type == "Client Expenses" && Line_Item == Expense].sum(Amount);
  27. AmountToClientExpensesFormatted = "$ " + AmountToClientExpenses.round(2);
  28. DisbursementToClient = Finances[Display_Name == searchParam && Type == "Disbursement to Client" && Line_Item == Expense].sum(Amount);
  29. DisbursementToClientFormatted = "$ " + DisbursementToClient.round(2);
  30. DisbursementToMedicare = Finances[Display_Name == searchParam && Type == "Medicare / Medicaid Liens" && Line_Item == Expense].sum(Amount);
  31. DisbursementToMedicareFormatted = "$ " + DisbursementToMedicare.round(2);
  32. DisbursementDateFromTrust = Finances[Display_Name == searchParam && Line_Item == Expense].Date_of_Check;
  33. //Check No. Need to configure
  34. //DateOfDisbursement = Finances[Display_Name == searchParam && Type == "Disbursement to Client" && Line_Item == Expense];
  35. //Trust = Finances[Display_Name == searchParam && Type == "Disbursement to Client"];
  36. %>
  37. <div class="divTableRow">
  38. <div class="divTableCell1"><%=Expense%></div>
  39. <div class="divTableCell1"><%=DisbursementFromTrustFormatted%></div>
  40. <div class="divTableCell1"><%=AttorneyFeesFormatted%></div>
  41. <div class="divTableCell1"><%=AmountToClientExpensesFormatted%></div>
  42. <div class="divTableCell1"><%=DisbursementToMedicareFormatted%></div>
  43. <div class="divTableCell1"><%=DisbursementToClientFormatted%></div>
  44. <div class="divTableCell1"><%=DisbursementDateFromTrust%></div>
  45. </div>
  46. <%
  47. }
  48. %>