[
http://mifosforge.jira.com/browse/MIFOS-2851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
johnwoodlock updated MIFOS-2851:
--------------------------------
select child.customer_id, child.status_id, child.display_name,
child.customer_level_id, child.parent_customer_id, childcm.meeting_id,
parent.customer_id, parent.display_name, parent.customer_level_id,
parentcm.meeting_id
from customer child
join customer_meeting childcm on childcm.customer_id = child.customer_id
join meeting childm on childm.meeting_id = childcm.meeting_id
join customer parent on parent.customer_id = child.parent_customer_id
join customer_meeting parentcm on parentcm.customer_id = parent.customer_id
join meeting parentm on parentm.meeting_id = parentcm.meeting_id
where childm.meeting_id <> parentm.meeting_id
order by parent.customer_id
The above (nasty looking) query picks up all customers who have meeting (ids)
which don't match their parent.
Currently looking at
1) doing an update query which will allow the batch job
(RegenerateScheduleTask) to process and fix the errors
2) seeing the the 'old' meeting has been updated to match the new meeting
(might need to notify clients to check this.
3) Enda has lots of situations where the customer's meeting doesnt match its
parents meeting... but it may not matter... need to ask Ryan's advice on the
matter.
Will be updating this later.
> Clean up data falling out from Issue 2652
> -----------------------------------------
>
> Key: MIFOS-2851
> URL: http://mifosforge.jira.com/browse/MIFOS-2851
> Project: mifos
> Issue Type: Bug
> Components: Centers
> Affects Versions: Gazelle C
> Reporter: Kay Chau
> Assignee: Adam Monsen
> Priority: Major
>
> As a result of Issue 2652, opening a separate issue to track the cleaning up
> of existing bad data as a result of the issue
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
