Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: Milestone 1.3
    • Fix Version/s: Milestone 1.3
    • Component/s: CEQ Core
    • Labels:
      None

      Description

      add Equity Flag to existing top people, top information, top country* widget

      set.equity=contribution (default), participation, total**

      • need to check if we have PQ values for countries
        • total is contribution+participation

        Activity

        Hide
        DmitryRyashchentsev added a comment -

        We maybe need to split this ticket.

        1.Top people participators means:
        person.PERSON_ID = person_ceq.PERSON_ID
        order by person_ceq.PERSON_PQ

        Top people contributors:
        person.PERSON_ID = person_ceq.PERSON_ID
        order by person_ceq.PERSON_CQ

        2. Top countries - the same with COUNTRY_CEQ table

        3. For information we have PQ (Participation Equity) and IQ (Information Equity). We count that people CQ(contribution equity) is sum of his infos IQs, i.e. IQ is related to CQ.

        Show
        DmitryRyashchentsev added a comment - We maybe need to split this ticket. 1.Top people participators means: person.PERSON_ID = person_ceq.PERSON_ID order by person_ceq.PERSON_PQ Top people contributors: person.PERSON_ID = person_ceq.PERSON_ID order by person_ceq.PERSON_CQ 2. Top countries - the same with COUNTRY_CEQ table 3. For information we have PQ (Participation Equity) and IQ (Information Equity). We count that people CQ(contribution equity) is sum of his infos IQs, i.e. IQ is related to CQ.
        Hide
        thbruhin added a comment -

        But, what I have to do, when filtering for a Tag?

        ------- no tag:
        Person participation value =
        person_ceq.PERSON_PQ where
        person.PERSON_ID = person_ceq.PERSON_ID

        Person contribution value =
        person_ceq.PERSON_CQ where
        person.PERSON_ID = person_ceq.PERSON_ID

        ------- filtering with a tag:
        Person participation value =
        sum(person_tag_ceq.PQ)
        where person.PERSON_ID = person_tag_ceq.AUTHOR_ID
        group by PERSON_ID

        Person contribution value =
        sum(person_tag_ceq.TQ)
        where person.PERSON_ID = person_tag_ceq.AUTHOR_ID
        group by PERSON_ID

        Is this correct?

        Show
        thbruhin added a comment - But, what I have to do, when filtering for a Tag? ------- no tag: Person participation value = person_ceq.PERSON_PQ where person.PERSON_ID = person_ceq.PERSON_ID Person contribution value = person_ceq.PERSON_CQ where person.PERSON_ID = person_ceq.PERSON_ID ------- filtering with a tag: Person participation value = sum(person_tag_ceq.PQ) where person.PERSON_ID = person_tag_ceq.AUTHOR_ID group by PERSON_ID Person contribution value = sum(person_tag_ceq.TQ) where person.PERSON_ID = person_tag_ceq.AUTHOR_ID group by PERSON_ID Is this correct?
        Hide
        DmitryRyashchentsev added a comment -

        Yes. Correct.

        Show
        DmitryRyashchentsev added a comment - Yes. Correct.
        Hide
        thbruhin added a comment -

        Done for Top people

        Show
        thbruhin added a comment - Done for Top people
        Hide
        PRE added a comment -

        closed all ticket for Milestone Release 1.3

        Show
        PRE added a comment - closed all ticket for Milestone Release 1.3

          People

          • Assignee:
            thbruhin
            Reporter:
            PRE
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 12 hours
              12h