SQL - Paginated Filterable Query

[rmartin93]

Need a stored procedure that gets data from a users table, paginates it based on a param, and also has a filter param that allows users to search the table to filter results if they want to.

@claude , can you make a new folder for this in generic and work this out?

[claude]

Claude finished @rmartin93's task in 1m 12s —— View job • claude/issue-2-20260106-1921 • Create PR ➔

---

Tasks

• Review existing SQL structure
• Create generic/paginated-user-query folder
• Write stored procedure with pagination and filtering
• Commit and push changes
• Provide PR link

Summary

Created generic/paginated-user-query/GetUsers.sql with stored procedure that:

• Paginates results via @PageNumber and @PageSize params
• Searches across Username, FirstName, LastName, Email via @SearchTerm param
• Returns @TotalCount output param for pagination metadata
• Validates inputs (page size 1-100)
• Orders by LastName, FirstName

| Branch