--- title: "최신 작업 지시서 쿼리 및 집계 생성" slug: "create-a-most-recent-work-order-query-and-aggregation" updated: 2026-10-22T15:40:35Z published: 2026-10-22T15:40:35Z canonical: "support.tulip.co/create-a-most-recent-work-order-query-and-aggregation" --- > ## 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. # 최신 작업 지시서 쿼리 및 집계 생성 가장 최근의 작업 지시를 찾기 위해 새 쿼리를 생성하고, 이 정보를 표시하기 위해 집계 기능을 추가하는 방법을 알아보세요. 이 가이드에서는 필요한 정확한 데이터를 얻기 위해 정렬 및 필터링을 설정하는 과정을 단계별로 안내합니다. 1. 작업 지시서 테이블로 이동합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/b11e3d20-e6e4-4133-8ecd-9804d4fef121/ascreenshot_c8a908ca96aa41418f2eba34a7051d23_text_export.jpeg) 1. “쿼리”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/387ddafb-8166-4999-b4b9-00cb76c6ff68/ascreenshot_5741fddb503c42b586eff66b2564b4cf_text_export.jpeg) 1. “새 쿼리 만들기”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/927a33d2-7222-4f04-9f33-5c616b1d4bc2/ascreenshot_6d4e0d08a9f248a190dc9b4708f1797e_text_export.jpeg) 1. “쿼리 이름” 필드를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/1f5c4634-2c04-419a-9b4b-e5ddde436135/ascreenshot_eaa68e030f6644229b4c4396afade440_text_export.jpeg) 1. “가장 최근 작업 지시서”를 입력합니다. 2. “정렬 (0)”을 클릭하세요. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/22385949-c933-42f2-9c81-20261eb23c36/ascreenshot_2c81091c36e84f8a96fed2f55317a201_text_export.jpeg) 1. “+ 정렬 방법 추가”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/fdf8282a-d8e2-463c-a8c9-327e451df873/ascreenshot_3ebf611d4748419faa2f84fbbcddeaa3_text_export.jpeg) 1. “ID”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/c3a91219-a682-49a5-a2e2-b2ef5303f104/ascreenshot_babc15fa51234052a1dfea557b7bb958_text_export.jpeg) 1. “마감일”을 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/a97b6072-71aa-4bf7-a567-bea1e6f8cec5/ascreenshot_949b971d1e6d47c09d2ea167f3ee241b_text_export.jpeg) 1. "가장 오래된 순서에서 가장 최근 순서대로 정렬"을 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/12c432c4-79e4-4f33-9f8d-7b1110962899/ascreenshot_5c635a63c1ef4f96abe28b10ea20c297_text_export.jpeg) 1. “가장 최근 순으로 정렬”을 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/4b8f7589-6e1b-414c-9ad1-befbc8871b45/ascreenshot_8c0af6bae28a466297ff03c0381701a2_text_export.jpeg) 1. “정렬 + 정렬 기준 추가”를 클릭합니다 ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/1e88b885-88af-40e6-8259-9eaf6184d4b9/ascreenshot_14d346e25e65476083bcacb0efb4f3ee_text_export.jpeg) 1. “제한 (1000)”을 클릭합니다 ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/db8cc986-f88b-4361-b5f0-1091df70f4a6/ascreenshot_1a191b60191041768b5f664a714fcb3b_text_export.jpeg) 1. 이 텍스트 필드를 클릭하세요. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/6e2a9ab1-3f53-498c-9ed7-b8c91c379dc7/ascreenshot_4ce466c3c01a4925a504b93b591b2ba7_text_export.jpeg) 1. “[[Backspace]] [[Enter]]”를 입력하세요 2. “1001A 테스트 레코드 2026년 3월 11일 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) 1. “저장”을 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/6b2a5579-f344-41fa-af72-46be3e69d005/ascreenshot_194021ade0084373adadfd41ab0301e5_text_export.jpeg) 1. “집계”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/7c85ee96-85a0-4a8d-af27-d7e2b8d253ac/ascreenshot_4dbe97cd52b74f539add93ae078e7d5f_text_export.jpeg) 1. “편집”을 클릭하십시오. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/7fd0d65d-7c60-44a4-b33c-5eb91a72b865/ascreenshot_2eb0ed8fc08c4c908c1fc0c23216fbf8_text_export.jpeg) 1. “+ 집계 추가”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/df0ea1d0-403b-411f-a021-9dd058025017/ascreenshot_9a77dc8e453044db9c9eff50785dc4b3_text_export.jpeg) 1. “집계 이름” 필드를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/712972b8-edec-4465-b5b5-c263bdabe046/ascreenshot_8ef88a9b631a49c0b6ff3a1d45403edb_text_export.jpeg) 1. “가장 최근 작업 지시서”를 입력합니다. 2. “옵션 선택”을 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/ce26e82e-d50b-4fd5-9ad5-e1c01a2a766e/ascreenshot_c2943dc9d04a4139b1014fdf6adda907_text_export.jpeg) 1. “모드”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/facc9545-c760-4f55-b91f-f1c1a8ce47a1/ascreenshot_06d729b55e934a65b94c4e342738c406_text_export.jpeg) 1. “옵션 선택”을 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/92e4d2ed-0a70-483c-a633-edf0ae67a973/ascreenshot_286c025a77ba4e5f9961f919396bfa5a_text_export.jpeg) 1. “ID”를 클릭합니다. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/eca979af-e430-41ab-9bce-e0f9a15ca34e/ascreenshot_d7978111e6eb43608489c82302ebf82e_text_export.jpeg) 1. “저장”을 클릭하십시오. ![](https://colony-recorder.s3.amazonaws.com/files/2026-03-11/fba0ee7b-64c9-4316-b1c5-ce072b2e46d5/ascreenshot_d76da9a6fe43454bb0d22d208fe6f2a4_text_export.jpeg)