Process monitoring graphs in [1] were proposed to give some level of top to bottom analysis. For example, a business analyst may first identify slow performing processes using the graph number 2. Then he can analyze bottleneck tasks of those slow processes from the graph number 10, where he has to generate graph 10 for each slow process. Then he can further analyze the users who performed bottleneck tasks frequently by generating graph number 11 for each slow task. Therefore, ability to execute parameterized queries is critical for these process monitoring features.
a.) Is that possible in DAS side ? > > eg: SELECT processDefinitionId, COUNT(processInstanceId) AS > processInstanceCount, AVG(duration) AS avgExecutionTime FROM > BPMNProcessInstances WHERE date BETWEEN *"fromDate" *AND* "toDate" *GROUP > BY processDefinitionId; > (here *fromDate* and *toDate* are variables that need to be passed at > runtime) > > b.) If not we can store the summarized data with primary and secondary > filters which mentioned in [1] on DAS and then we can fetch them through > DAS REST API by passing appropriate parameters. > Isuru, I think the approach (b) does not scale. There can be hundreds of processes and thousands of tasks (in all processes). Therefore, it is not practical to pre-compute data for all graphs. Ability to execute parameterized queries or to provide queries at runtime through an API would be helpful to solve this problem. [1] https://docs.google.com/a/wso2.com/spreadsheets/d/1pQAK6x4-rL-hQA7-NOaoT2llyjxv_nfc_vUarwUr74w/edit?usp=sharing Regards, Chathura
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
