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]> 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]
> 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]
https://lists.sourceforge.net/lists/listinfo/mifos-users
