#734 Enhance pagination and search functionality for nodes in JSON endpoints Pull request opened by zhuoyuan-liu #635 This PR: • Implemented paginated retrieval of nodes by environment with target filters. • Added counting methods for total nodes and filtered search results. • Updated front-end to forward ordering parameters for server-side handling. For now, the query speed is about 10,000× faster than before with 10K nodes, and we can clearly see changes in both the database queries and the request URLs

[2.572ms] [rows:25] SELECT * FROM "osquery_nodes" WHERE environment = 'dev' AND "osquery_nodes"."deleted_at" IS NULL ORDER BY last_seen DESC LIMIT 25

[image](https://private-user-images.githubusercontent.com/117184318/500974978-548b0a6c-097e-4f67-a1b0-b53fe7f402fa.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjA0ODIyNjQsIm5iZiI6MTc2MDQ4MTk2NCwicGF0aCI6Ii8xMTcxODQzMTgvNTAwOTc0OTc4LTU0OGIwYTZjLTA5N2UtNGY2Ny1hMWIwLWI1M2ZlN2Y0MDJmYS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUxMDE0JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MTAxNFQyMjQ2MDRaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hYjIxMGFiM2VmMjg0NzNiM2FhNmFhMDdlYWM2ZTA0YzhhYWI4MDY1MjU1MzQwMGMyMDkwOGZkZTM2OWIyMjE1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.agLtwzAfU_lYlIdvw2VlmRunnJxGEmzQyPF-L5_iJCw) jmpsec/osctrl