Thanks John,
This is all very helpful (as usual :)
Right now, we am having some stability issues on the 2.1.6 site (even with
single user testing) , and having to start and stop Tomcat about every 30 mins
of user time. That’s my #1 concern, but…as soon as we get stability, I will
move on over to wanting the warehouse and Pentahoe if my technical team thinks
we can manage that in Amazon EC2 (where we currently host). Will keep you
posted.
I will likely log the stability issues over in the Mifos-Dev list.
I am trying to get a more specific and re-createable set of errors.
Stephen
From: John Woodlock <[email protected]<mailto:[email protected]>>
Reply-To: Mifos User
<[email protected]<mailto:[email protected]>>
Date: Sat, 1 Oct 2011 09:58:24 +1000
To: Mifos User
<[email protected]<mailto:[email protected]>>
Subject: Re: [Mifos-users] Filtering Client by attributes such as Male and
Female?
Stephen
As far as I know the client search only searches on name (and a couple of other
specific fields like account/client number and government id). So that would
be a 'no' for fancy searches in mifos.
I can't recall any out of the box mifos report that does for example, %of male
/ female active clients. One pentaho report does show %women by branch but
you'd have to have pentaho and the data warehouse bits set up.
So, it would be a 'customised' thing. I don't know what reporting type
software you have available to you and that you are comfortable with but if you
have access to the mysql command line or any gui that connects to mysql... that
is one way of getting quick answers to stuff that isn't needed operationally in
mifos (i.e. you don't absolutely have to have it in report format or accessible
thru the mifos pages)
Maybe some MFI has already got this customised report? In case it helps, the
sql for counts of males/females in mifos is
select lv.lookup_name, count(*)
from customer c
join customer_detail cd on cd.customer_id = c.customer_id
join lookup_value lv on lv.lookup_id = cd.gender
where c.customer_level_id = 1 /* client */
and c.status_id = 3 /* active */
/*other status for client are 1 (partial), 2 (pending), 4 (on hold), 5
(cancelled), 6 (closed) */
group by lv.lookup_name
John
On Sat, Oct 1, 2011 at 2:26 AM, Stephen Kaufman
<[email protected]<mailto:[email protected]>> wrote:
I had gotten this thread tangled with another. Just to keep them separate
and less confusing, here is the question again.
Question:
Is there an easy way to get a list of male clients vs. female? Is that a
report or is there any way to filter reaches in the search box using some
psuedo sql?
For example, I can search for all client by entering "%"
Is there any way to type say "% +male - inactive" to get a smaller set of
found clients?
If not is this a custom report?
Thanks again.
Stephen Kaufman
VP International Aid Services - America
------------------------------------------------------------------------------
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-d2dcopy2
_______________________________________________
Mifos-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
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-d2dcopy2_______________________________________________
Mifos-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
