Update the getAll... methods to support column-based search and sorting, and add export and statistics functionalities."