I want to generate a data grid using a stored procedure that returns multiple rows of data based on the argument that was passed. My stored procedure is filtering the data based on the argument passed and returns rows of data gathered from multiple tables. I would like to be able to sort and search the grid columns based on the results from my stored procedure.
I think a db "view" in this case is a better option than a stored procedure. I can now use an ActiveRecord model in yii2 to interact directly with my view just like if it was a table.
