CI4: stored procedures/functions for Select / Drop down list

@Ahmed Haroon,

They both work (don't forget about database views either). Pick one and go with it.  I personally prefer either straight query calls or database view calls.  I don't think there is a best practice as much as a preference of how you wish to obtain the data.

thanks @php_rocs for your input and sharing your experience. 
regards