[
http://mifosforge.jira.com/browse/MIFOSADMIN-188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62930#action_62930
]
Sumit Shah commented on MIFOSADMIN-188:
---------------------------------------
Both the following queries, return empty sets, which would indicate that the
testing-keef database does not need to be cleaned up:
Query A (slightly modified):
select child.customer_id, child.status_id as status, child.display_name,
child.customer_level_id as Level, child.parent_customer_id, parent.status_id as
ParentStatus, parent.display_name as ParentDisplayName,
parent.customer_level_id as ParentLevel, childcm.meeting_id as ChildMeetingId,
childm.meeting_place, childrd.recur_after, childr.days, parentcm.meeting_id as
ParentMeetingId, parentm.meeting_place, parentrd.recur_after, parentr.days from
customer child join customer_meeting childcm on childcm.customer_id =
child.customer_id join meeting childm on childm.meeting_id = childcm.meeting_id
left join recurrence_detail childrd on childrd.meeting_id = childm.meeting_id
left join recur_on_day childr on childr.details_id = childrd.details_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 left join
recurrence_detail parentrd on parentrd.meeting_id = parentm.meeting_id left
join recur_on_day parentr on parentr.details_id = parentrd.details_id where
childm.meeting_id <> parentm.meeting_id order by parent.customer_id
Query B:
select oldstructure.status_id as "Old Structure Status",
oldstructure.customer_id as "Old Structure Parent Id",
oldstructure.display_name as "Old Structure Parent Name",
oldstructure.customer_level_Id as "Old Structure Parent Level",
oldstructureparent.customer_id as "Next Level Up Parent Id",
oldstructureparent.display_name as "Next Level Up Parent Name",
oldstructureparent.customer_level_Id as "Next Level Up Parent Level" from
customer child join customer_meeting childcm on childcm.customer_id =
child.customer_id join meeting childm on childm.meeting_id = childcm.meeting_id
left join recurrence_detail childrd on childrd.meeting_id = childm.meeting_id
left join recur_on_day childr on childr.details_id = childrd.details_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 left join
recurrence_detail parentrd on parentrd.meeting_id = parentm.meeting_id left
join recur_on_day parentr on parentr.details_id = parentrd.details_id left join
customer_hierarchy ch on ch.customer_id = child.customer_id and ch.status = 0
left join customer oldstructure on oldstructure.customer_id = ch.parent_id left
join customer oldstructureparent on oldstructureparent.customer_id =
oldstructure.parent_customer_id where childm.meeting_id <> parentm.meeting_id
group by oldstructure.customer_id order by oldstructure.display_name;
> Need to run clean-up script for SEARCH IDs for KEEF instance
> ------------------------------------------------------------
>
> Key: MIFOSADMIN-188
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-188
> Project: mifos administration
> Issue Type: Task
> Components: Cloud Instances
> Reporter: Ryan Whitney
> Assignee: Sumit Shah
> Fix For: Cloud Release A, Cloud Release A - Iteration 1
>
>
> Currently, KEEF is seeing a behavior that when they create new groups, they
> are being pre-populated with existing members. This is most likely due to:
> http://mifosforge.jira.com/browse/MIFOS-2851
> We need to take the clean-up scripts from this fix and run in KEEF instance.
> Clean up scripts
> http://mifosforge.jira.com/wiki/display/MIFOS/Fix+centers+or+groups+with+wrong+meeting+dates+due+to+moving+clients
--
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
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
