I have an issue where all my questions do not show the filters (as per picture shown below):
All questions come from a custom SQL query
SELECT
T.fecha AS Fecha,
CONCAT( P.apellidos, ' ',P.nombre ) AS Paciente,
CONCAT( A.apellidos, ' ', A.nombre ) AS Doctor,
L.nombre AS Laboratorio,
IF(PD.liberado=1, "1", "") as Lib,
IF(PD.pagado=1, "1", "") as P,
ABS(PD.saldo - PD.abono - PD.desc) + PD.abono as Ventas,
F.abreviatura as TPago,
PD.empresa as Emp,
(
SELECT CONCAT( M.apellidos, ' ', M.nombre )
FROM adm_user M
WHERE M.id = B.id_vendedor
) AS Vendedor,
C.porcentaje AS Porcentaje,
ABS(ROUND((PD.saldo - PD.desc)*(C.porcentaje/100),2)) AS Comision
FROM test_completo T
INNER JOIN pagos_detalles PD ON PD.id_test_completo = T.id
INNER JOIN adm_empresa L ON T.id_empresa = L.id
INNER JOIN adm_user A ON T.id_doctor = A.id
INNER JOIN adm_user_doctor B ON A.id = B.id
INNER JOIN comisiones C ON C.id = B.id_comisiones
INNER JOIN pacientes P ON P.id = T.id_paciente
INNER JOIN adm_empresa E ON E.id= T.id_empresa
INNER JOIN forma_pago F ON F.idformapago = PD.tipopago
INNER JOIN registro_pagos R ON R.id_pagos_detalles = PD.id
ORDER BY Doctor ASC
Is there something missing on the SQL query? a bug?
