dhis2-devs team mailing list archive

[Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>]

Hi KA,

May I suggest a bad way for solving this issue? Just in template at this
time.

*First, you must have the permission in that database.*

Then, you can use this query for testing the duplicated indicator name in
database (or the name is exists in).
*
SELECT NAME FROM INDICATOR
WHERE NAME ilike = '<insert_your_text_here>'*

(*ilike*: in-case sensitive in like)

Select the name and then pressing Ctrl U to change it to lower case in query
statement.
Very very uncomfortable but how is it going?

On Tue, Mar 30, 2010 at 2:56 PM, Kim Anh Vo <catakim@xxxxxxxxx> wrote:

> so... it's not public pug... How come and how to fix it, can you check it
> out?
> What the difference of functions actually between using databases with
> diff. language in logic?
>
> --
> Validate duplication of indicator name when added
> https://bugs.launchpad.net/bugs/551393
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
>
> Status in DHIS 2 - District Health Information Software: Fix Committed
>
> Bug description:
> Currently, when adding a new indicator... there is no validation/check-ups
> the availability of indicator name.
> As a result of this, when a duplication occurs, it links to an exception
> page....
>
> "An exception occurred
>
> Sorry! The system failed to execute the operation. Usually, no data is lost
> and you can continue working by going back to the previous page. If you wish
> to report the incident, please save this page by choosing "File -> Save
> (page as)" in your browser and include the saved page in the report. The
> problem details are listed below.
>
> [+] Exception (org.hibernate.exception.ConstraintViolationException): Could
> not execute JDBC batch update
>
>  ... "
>
> This is very confusing to users. With the experienced-user they can click
> the "Go Back" button to re-edit the ind-name but the normal users... if they
> link to the other pages... without clicking the button, the sys.is crashed
> with Indicator Management function...!
>
> Suggestion: add the checking scripts at/nearby the ind-name box on the page
> of adding new ind to check availability of the ind-name (like normal
> registration account on web: Yahoo, Gmail, etc.)
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Hieu.HISPVietnam
Good Health !