[
http://mifosforge.jira.com/browse/MIFOS-5069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=68048#comment-68048
]
johnwoodlock edited comment on MIFOS-5069 at 6/29/11 8:27 AM:
--------------------------------------------------------------
the problem is as Binny describes.
There is a query in java called
branchReport.extractStaffingLevelSummaryForBranchByTitle which uses
"left join lookup_value_locale lvl on lvl.lookup_value_id = lv.lookup_id"
instead of
"left join lookup_value_locale lvl on lvl.lookup_id = lv.lookup_id"
So, its an easy 'going forward' fix in either F, G release and/or head master.
'going forward' because the data for the report is calculated each day so
everything in the past still has the error (that could be easily fixed also).
So, just a matter of deciding which release it goes in F, G and/or "head master"
was (Author: johnwoodlock):
the problem is as Binny describes.
There is a query in java called
branchReport.extractStaffingLevelSummaryForBranchByTitle which uses
"left join lookup_value_locale lvl on lvl.lookup_value_id = lv.lookup_id"
instead of
"left join lookup_value_locale lvl on lvl.lookup_id = lv.lookup_id"
So, its an easy 'going forward' fix in either F or G release or both if wanted.
'going forward' because the data for the report is calculated each day so
everything in the past still has the error (that could be easily fixed also).
So, just a matter of decided which release it goes in F, G and/or "head master"
> SECDEP: Branch Progress Report - incorrect User Title name in "Branch
> Staffing" section
> ---------------------------------------------------------------------------------------
>
> Key: MIFOS-5069
> URL: http://mifosforge.jira.com/browse/MIFOS-5069
> Project: mifos
> Issue Type: Bug
> Environment: Mifos Cloud - production instance - running 2.1.2
> Reporter: Binny Gopinath Sreevas
> Assignee: johnwoodlock
> Attachments: Secdep_BranchProgressReport_Passi.pdf
>
>
> In Branch Progress report, "Branch Staffing" section has the following:
> # Anoring 7
> # Branch Manager 2
> # Total Staff 9
> The counts are correct. But the label "Anoring" is not correct. It should be
> "Project Officer. There are 7 users with the "Project Officer" user title.
> But for some reason the label is coming as "Anoring" which is the name of a
> province (Ethnicity is configured to be displayed as equivalent for Province
> for Secdep instance).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Mifos-issues mailing list
Mifos-issues@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues
