[ 
http://mifosforge.jira.com/browse/MIFOS-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=56852#action_56852
 ] 

jslawinski commented on MIFOS-2711:
-----------------------------------

Is it possible to obtain such large database somehow?

I have only database containing 5k clients, which was generated by 
seedDataManyClients.py script. Generating 5k clients took me many hours.

However, after adding index to government_id column searching by government id 
will take the same time as searching by customer id. This means that 
performance on Search can be maximally decreased by 33%.

> Add ability to search by Government ID
> --------------------------------------
>
>                 Key: MIFOS-2711
>                 URL: http://mifosforge.jira.com/browse/MIFOS-2711
>             Project: mifos
>          Issue Type: New Feature
>          Components: Search
>    Affects Versions: Release 1.4
>            Reporter: Kay Chau
>            Assignee: jslawinski
>
> Currently in Mifos, in the Search box that shows up both under the Home tab 
> and the Clients & Accounts tab, you can search by name, system ID or account 
> number.
> We want to add the ability to search by a client's "Government ID".  This ID 
> can be renamed under "Define Labels" in Mifos.  Currently this ID can be 
> added when you create a client or editing a client that hasn't been active 
> yet.
> For this feature, add searching by that field.  The search results UI should 
> be the same as when you search by client's Mifos system ID currently.
> On the test server, try searching for 0015-000000100 to see what should show 
> up.
> When searching by Government ID, the results should still be:
> x results for <Government ID> in All Branches
> where x is the number of results and <Government ID> is the search term.
> The results that match should show the same as when searching by client ID 
> For example:
> Client: sakuntala behera: ID 0015-000000100
> Status:   Active Loan Officer: siba prasad behera
> Loan: Account # 000100000000311 
> Note that in the search results, the Government ID won't be in the actual 
> search results.  This is fine, and we will add that as a separate enhancement.
> Another thing to note - it is possible that a Government ID could be the same 
> as a Mifos client ID or even loan account since they're not mutually 
> exclusive.  That is fine, and the expected result is that all search results 
> that match that number would be displayed.
> Leave the string that describes the Search box as is.  We'll add another 
> enhancement to update that string correctly.

-- 
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

        

------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to