how to change query with function on DB::table?
Hi, I have function create function imam_id() returns INTEGER DETERMINISTIC NO SQL return @imam_id
and view CREATE VIEW data_kitab AS SELECT a.id id, a.id_imam, a.id_kitab, a.kitab_indonesia, a.kitab_arabic, b.total_bab, c.total_hadits, c.min_row, c.max_row FROM hadits_kitab a INNER JOIN ( SELECT a.id_kitab, COUNT(1) total_bab FROM hadits_kitab a INNER JOIN hadits_bab b ON a.id_imam = b.id_imam AND a.id_kitab = b.id_kitab WHERE a.id_imam = imam_id() GROUP BY a.id_kitab ) b ON a.id_kitab = b.id_kitab INNER JOIN ( SELECT a.id_kitab, COUNT(1) total_hadits, MIN(b.id) min_row, MAX(b.id) max_row FROM hadits_bab a INNER JOIN hadits_detail b ON a.id_imam = b.id_imam AND a.id_kitab = b.id_kitab AND a.id_bab = b.id_bab WHERE a.id_imam = imam_id() GROUP BY a.id_kitab ) c ON a.id_kitab = c.id_kitab WHERE a.id_imam = imam_id()
to call the view with parameters using a function, I use query select s.* from (select @imam_id:=1 p) parm , data_kitab s
I'm having trouble changing the query to DB::table
Please or to participate in this conversation.