--- title: "Create a Most Recent Work Order Query and Aggregation" slug: "create-a-most-recent-work-order-query-and-aggregation" updated: 2026-03-17T19:14:19Z published: 2026-03-17T19:14:19Z canonical: "support.tulip.co/create-a-most-recent-work-order-query-and-aggregation" excludeFromSearch: true --- > ## Documentation Index > Fetch the complete documentation index at: https://support.tulip.co/llms.txt > Use this file to discover all available pages before exploring further. # Create a Most Recent Work Order Query and Aggregation [Embedded content](https://scribehow.com/embed/Create_a_Most_Recent_Work_Order_Query_and_Aggregation__H_x4muk2Q6uQmpDzunqCKg) Learn how to create a new query to find the most recent work order and add an aggregation to display this information. This guide will walk you through setting up sorting and filtering to get the exact data you need. 1. Navigate to your work orders table. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/b11e3d20-e6e4-4133-8ecd-9804d4fef121/ascreenshot_c8a908ca96aa41418f2eba34a7051d23_text_export.jpeg) 2. Click "Queries" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/387ddafb-8166-4999-b4b9-00cb76c6ff68/ascreenshot_5741fddb503c42b586eff66b2564b4cf_text_export.jpeg) 3. Click "Create New Query" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/927a33d2-7222-4f04-9f33-5c616b1d4bc2/ascreenshot_6d4e0d08a9f248a190dc9b4708f1797e_text_export.jpeg) 4. Click the "Query Name" field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/1f5c4634-2c04-419a-9b4b-e5ddde436135/ascreenshot_eaa68e030f6644229b4c4396afade440_text_export.jpeg) 5. Type "Most recent work order" 6. Click "Sort (0)" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/22385949-c933-42f2-9c81-20261eb23c36/ascreenshot_2c81091c36e84f8a96fed2f55317a201_text_export.jpeg) 7. Click "+ Add Sorting Method" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/fdf8282a-d8e2-463c-a8c9-327e451df873/ascreenshot_3ebf611d4748419faa2f84fbbcddeaa3_text_export.jpeg) 8. Click "ID" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/c3a91219-a682-49a5-a2e2-b2ef5303f104/ascreenshot_babc15fa51234052a1dfea557b7bb958_text_export.jpeg) 9. Click "Due Date" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/a97b6072-71aa-4bf7-a567-bea1e6f8cec5/ascreenshot_949b971d1e6d47c09d2ea167f3ee241b_text_export.jpeg) 10. Click "Sort oldest to newest" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/12c432c4-79e4-4f33-9f8d-7b1110962899/ascreenshot_5c635a63c1ef4f96abe28b10ea20c297_text_export.jpeg) 11. Click "Sort newest to oldest" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/4b8f7589-6e1b-414c-9ad1-befbc8871b45/ascreenshot_8c0af6bae28a466297ff03c0381701a2_text_export.jpeg) 12. Click "Sort+ Add Sorting Method" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/1e88b885-88af-40e6-8259-9eaf6184d4b9/ascreenshot_14d346e25e65476083bcacb0efb4f3ee_text_export.jpeg) 13. Click "Limit (1000)" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/db8cc986-f88b-4361-b5f0-1091df70f4a6/ascreenshot_1a191b60191041768b5f664a714fcb3b_text_export.jpeg) 14. Click this text field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/6e2a9ab1-3f53-498c-9ed7-b8c91c379dc7/ascreenshot_4ce466c3c01a4925a504b93b591b2ba7_text_export.jpeg) 15. Type " [[Backspace]] [[Enter]]" 16. Click "1001A test recordMar/11/2026 11:30:00 -04:00" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/5a411acd-7a1d-4043-9c2d-fa4180f62552/ascreenshot_691f9dde552a49a4874e970e4cbe3f1f_text_export.jpeg) 17. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/6b2a5579-f344-41fa-af72-46be3e69d005/ascreenshot_194021ade0084373adadfd41ab0301e5_text_export.jpeg) 18. Click "Aggregations" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/7c85ee96-85a0-4a8d-af27-d7e2b8d253ac/ascreenshot_4dbe97cd52b74f539add93ae078e7d5f_text_export.jpeg) 19. Click "Edit" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/7fd0d65d-7c60-44a4-b33c-5eb91a72b865/ascreenshot_2eb0ed8fc08c4c908c1fc0c23216fbf8_text_export.jpeg) 20. Click "+Add aggregation" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/df0ea1d0-403b-411f-a021-9dd058025017/ascreenshot_9a77dc8e453044db9c9eff50785dc4b3_text_export.jpeg) 21. Click the "Aggregation Name" field. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/712972b8-edec-4465-b5b5-c263bdabe046/ascreenshot_8ef88a9b631a49c0b6ff3a1d45403edb_text_export.jpeg) 22. Type "Most Recent Work Order" 23. Click "Select an option" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/ce26e82e-d50b-4fd5-9ad5-e1c01a2a766e/ascreenshot_c2943dc9d04a4139b1014fdf6adda907_text_export.jpeg) 24. Click "Mode" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/facc9545-c760-4f55-b91f-f1c1a8ce47a1/ascreenshot_06d729b55e934a65b94c4e342738c406_text_export.jpeg) 25. Click "Select an option" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/92e4d2ed-0a70-483c-a633-edf0ae67a973/ascreenshot_286c025a77ba4e5f9961f919396bfa5a_text_export.jpeg) 26. Click "ID" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/eca979af-e430-41ab-9bce-e0f9a15ca34e/ascreenshot_d7978111e6eb43608489c82302ebf82e_text_export.jpeg) 27. Click "Save" ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/fba0ee7b-64c9-4316-b1c5-ce072b2e46d5/ascreenshot_d76da9a6fe43454bb0d22d208fe6f2a4_text_export.jpeg)