← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 567080] [NEW] dataset-section-no-sorting

 

Hi Ola,

Here is what i am trying to do. I have a paper data collection form
that i am implementing as a custom data entry screen. Pretty simple in
practice, but is laborious to implement because 1) We do not have
multidimensional/category combo type data elements here and 2) The
sort order of the data elements is all jumbled up.


 I want to break up the dataset, which is rather large, into sections
that correspond to two separate pages of the paper aggregation form.
Why? Well, it is not entirely necessary I guess, since I am using a
custom data entry form, but some users actually prefer to use the
"default" form instead of the custom form. I want to be sure that the
data elements are ordered properly and they have appropriate sections.
Thus, I figured that the data set sections would do this for me.
Perhaps this is totally unnecessary, but it still does not mean that
this bug is not valid. The list remains totally unordered, so if
people want to have a data set section for whatever reason, it should
be presented in some form that makes sense. Seems Bob may have already
figured it out.

>Why would that be important if it has nothing to do with the order in the
>form?
>And again, why use the section at all?

Well, maybe you can enlighten us then as to the use of data set
sections? I assumed that it was for the purpose I am trying to
achieve, but perhaps not.

If you take a look at the datasetmembers table, there is no sortorder
field, unlike DHIS1.4. DHIS 1.4 has both a sort order in the data
elements table, as well as the equivalent of the datasetmembers table.
It would just be very useful to be able to resort the data elements
(and all objects for that matter) in the browser itself. Sort by name
(Ascending, descending), sort by code, sort by sort order, etc. When I
was in Tajikistan, I thought that Murod has sent some code for server
side filtering and ordering. Not sure what happened to it, but that is
exactly what would be useful to have in these situations.

Regards,
Jason


On Tue, Apr 20, 2010 at 11:29 AM, Ola Hodne Titlestad
<olatitle@xxxxxxxxx> wrote:
> Jason,
>
> What are you trying to achieve using the dataset sections?
>
>
> Ola Hodne Titlestad |Technical Officer|
> Health Metrics Network (HMN) | World Health Organization
> Avenue Appia 20 |1211 Geneva 27, Switzerland | Email:
> titlestado@xxxxxxx|Tel: +41 788216897
> Website: www.healthmetricsnetwork.org
>
> Better Information. Better Decisions. Better Health.
>
>
> On 20 April 2010 11:19, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:
>>
>> Sounds good, but I need to fix this now. Will have a look myself and
>> see what can be done in the interim. Creating a dataset section is
>> nigh impossible with several hundred elements unsorted.
>>
>> On 4/20/10, Ola Hodne Titlestad <olatitle@xxxxxxxxx> wrote:
>> > Hi,
>> >
>> > Note that there is a planned revamp of the whole forms/dataset model
>> > quite
>> > soon and this blueprint for 2.0.5 covers at least improved functionality
>> > in
>> > terms of defining the layout of default forms, incl. sort order:
>> > https://blueprints.launchpad.net/dhis2/+spec/improved-forms
>> >
>> > The goal is to be able to use the default tabular forms as much as
>> > possible,
>> > since that will save us all a lot of time.
>> > These default tabular forms should be (as it they are today) generated
>> > off a
>> > data set with data elements and one or more category combos,  but we
>> > need to
>> > provide the form designers with more options in terms of disabling
>> > certain
>> > fields, sort order of data elements, pivoting of the table (option to
>> > have
>> > data elements on columns and categories on rows).
>> >
>> > The idea is to use custom forms (which take a lot more time to design)
>> > only
>> > when its not possible to generate the form off the data set and some
>> > additional (and not too complicated) layout choices.
>> > Most tabular forms should be possible to auto generate.
>> >
>> > Feel free to add to the blueprint.
>> >
>> > Ola Hodne Titlestad |Technical Officer|
>> > Health Metrics Network (HMN) | World Health Organization
>> > Avenue Appia 20 |1211 Geneva 27, Switzerland | Email:
>> > titlestado@xxxxxxx|Tel:
>> > +41 788216897
>> > Website: www.healthmetricsnetwork.org
>> >
>> > Better Information. Better Decisions. Better Health.
>> >
>> >
>> > On 20 April 2010 10:31, Jason Pickering <jason.p.pickering@xxxxxxxxx>
>> > wrote:
>> >
>> >> This may actually be a problem due to the way that the data elements
>> >> were sorted in DHIS 1.4. 1.4 allows you to specify both a sorting
>> >> order in the dataelement table, as well as the equivalent of the
>> >> datasetmembers table. A global (system) setting allows one to chose
>> >> how they should be displayed in lists. Our data elements were sorted
>> >> correctly according to the dataset,  but as far as I can tell,  DHIS2
>> >> does not support sorting of data elements by data set (at least there
>> >> is no field in datasetmembers that would support this)
>> >>
>> >> On  the datasetsection page, the ordering that is presented to me, is
>> >> not in alphabetical order the SECOND time I enter the page. The first
>> >> time, everything is ordered alphabetically (user setting), the second
>> >> time around, the ordering is completely mixed up. I would expect it to
>> >> follow the user setting (alphabetical) but this does not seem to be
>> >> the case.
>> >>
>> >> I agree that it should probably be a system setting, similar to
>> >> DHIS1.4.
>> >>
>> >>
>> >>
>> >> On Tue, Apr 20, 2010 at 10:16 AM, Ola Hodne Titlestad
>> >> <olatitle@xxxxxxxxx> wrote:
>> >> > Hi,
>> >> >
>> >> > My understanding of this is that you can apply the system wide custom
>> >> sort
>> >> > order to data elements in a data set section.
>> >> >
>> >> > In user settings you can set the sort order to be custom and then go
>> >> > to
>> >> > Maintenance>Data Elements and sort the elements in the full list
>> >> > there.
>> >> >
>> >> > Then the data elements in the data set section (or data set) will be
>> >> sorted
>> >> > according to their global sort order when listed in a default data
>> >> > entry
>> >> > form.
>> >> >
>> >> > My only concern with this is that the sort order is a user setting
>> >> > and
>> >> not a
>> >> > system setting so different users doing data entry might experience
>> >> > different sort order, which may not be desired in data entry forms.
>> >> >
>> >> >
>> >> > Ola Hodne Titlestad |Technical Officer|
>> >> > Health Metrics Network (HMN) | World Health Organization
>> >> > Avenue Appia 20 |1211 Geneva 27, Switzerland | Email:
>> >> > titlestado@xxxxxxx|Tel: +41 788216897
>> >> > Website: www.healthmetricsnetwork.org
>> >> >
>> >> > Better Information. Better Decisions. Better Health.
>> >> >
>> >> >
>> >> > On 20 April 2010 10:08, Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
>> >> wrote:
>> >> >>
>> >> >> Dear Jason,
>> >> >>
>> >> >> Actually, this ordering is completely belongs to your action during
>> >> >> on
>> >> >> sorting data elements in the selected list.
>> >> >> For example;
>> >> >>
>> >> >> Assuming that, there are five data elements such as: A, B, C, D and
>> >> >> E
>> >> >> in
>> >> >> the available list. Then, if select each element following the
>> >> >> ordering
>> >> >> likes B, D, A, C in the selected list. So after coming back to edit
>> >> >> that
>> >> >> data section you will see the selected list of this one, which is
>> >> >> not
>> >> >> ordered alphabetically in expecting on.
>> >> >>
>> >> >> On Tue, Apr 20, 2010 at 2:12 PM, jason.p.pickering
>> >> >> <jason.p.pickering@xxxxxxxxx> wrote:
>> >> >>>
>> >> >>> Public bug reported:
>> >> >>>
>> >> >>> When creating a data set section, there is no logical ordering
>> >> >>> applied
>> >> >>> to the data elements. The first time I created the dataset section,
>> >> they
>> >> >>> appeared to be ordered alphabetically. When I saved and edited the
>> >> >>> dataset again, the ordering is completely jumbled up.
>> >> >>>
>> >> >>> ** Affects: dhis2
>> >> >>>     Importance: Undecided
>> >> >>>         Status: New
>> >> >>>
>> >> >>> --
>> >> >>> dataset-section-no-sorting
>> >> >>> https://bugs.launchpad.net/bugs/567080
>> >> >>> 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: New
>> >> >>>
>> >> >>> Bug description:
>> >> >>> When creating a data set section, there is no logical ordering
>> >> >>> applied
>> >> to
>> >> >>> the data elements. The first time I created the dataset section,
>> >> >>> they
>> >> >>> appeared to be ordered alphabetically. When I saved and edited the
>> >> dataset
>> >> >>> again, the ordering is completely jumbled up.
>> >> >>>
>> >> >>>
>> >> >>>
>> >> >>> _______________________________________________
>> >> >>> 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 !
>> >> >>
>> >> >> _______________________________________________
>> >> >> 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
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> --
>> >> Jason P. Pickering
>> >> email: jason.p.pickering@xxxxxxxxx
>> >> tel:+260968395190
>> >>
>> >
>>
>>
>> --
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+260968395190
>
>



-- 
--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260968395190



Follow ups

References