I am migrating an existing application to ColdBox (a bit of a learning curve). The existing application uses stored procedure to retrieve data from MS SQL for searches. Then for filters, same stored procedure is called passing different parameters. With that said, the DB is being hit as many times as filters are selected. I would like to hit the DB once and then subquery of the returned results.
I saw a QueryHelper containing methods that might be useful for what I’m trying to do; however, there are no examples. Could someone shred some lights on how best to achieve the above function quickly and effiencinetly in ColdBox?
We are not using beans…so no ORM and such… simply using a Service class to make the stored procedure call.
I appreciate your thoughts.