Dashboard question

[former_member206885]

Hello Everyone,

In dashboard view the count of job chains is showing: 123

The result of the below sql query is giving 125

select count(*) from JobChain

If I do the manual count of job chains, the count is 119.

Can you please help me in understanding why is the difference of count in all these scenarios.

Regards,

Tinku

[former_member206885]

I am sorry. One correction to the above question.

Dashboard is now updated. It is showing the count as 125 which is equal to the count of sql query. But the update of dashboard is not instant. Not sure why it is taking long time to update.

But still the manual count and dashboard count is different.

Regards,

Tinku

[gmblom]

It is possible that you have branched versions.

Try the following sql:

select count(*) from JobChain jc, JobDefinition jd where jc.JobDefinition = jd.UniqueId and jd.BranchedLLPVersion = -1

Regards Gerben

[former_member206885]

Thank you for the query Gerben. As you said, dashboard is listing all the jobchains including the branched ones. Is there any way that we can configure Dashboard to give only the count of master job chains or master job definitions without branched ones?

Regards,

Tinku