Un foro de discusión para nuestra comunidad de hispano hablante

Moderator: amosbatto

By fardon
#790855
Hola,

Quisiera saber donde puedo encontrar los siguientes datos en phpmyadmin:
*Procesos en bandeja de entrada.
*Procesos en borrador.
*Procesos completados.
*Total de casos.

Image
User avatar
By amosbatto
#790859
Estos datos son creados por queries en la tabla APPLICATION:
SELECT COUNT(*) FROM APPLICATION WHERE PRO_UID='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' AND APP_STATUS='COMPLETED';
SELECT COUNT(*) FROM APPLICATION WHERE PRO_UID='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' AND APP_STATUS='TO_DO';
SELECT COUNT(*) FROM APPLICATION WHERE PRO_UID='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' AND APP_STATUS='DRAFT';
SELECT COUNT(*) FROM APPLICATION WHERE PRO_UID='xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';

hi all, i am using on a process which is a suppor[…]

Great! It was very helpful! Now I´m looking […]

This solution only works if I have 2 tasks in whic[…]

timing control

I can't reproduce the problem in version 3.2.0 C[…]