← Back to team overview

dhis2-devs team mailing list archive

Re: Can't view data value in pivot table

 

Hi Knut,
i tried clear google chrome cache and re run analytic and datamart already.
i check the log it fine. But when i tried generate detail section with
pivot it still show blank to me.
----
* INFO  2014-10-10 15:26:37,415 Time: 38238 micros: Analytics SQL: select
"de","
quarterly","co", sum(value) as value from analytics_2014 where "de" in
('gKwRVc5
UoPS') and "quarterly" in ('2014Q3') and ( "uidlevel4" in ('dOfq5Zel7JX',
'pqiEm
gwvCBH') ) group by "de","quarterly","co" (Timer.java
[SimpleAsyncTaskExecutor-9
2])
* INFO  2014-10-10 15:26:37,416 Time: 109576 micros: Got aggregated values
for q
uery group (Timer.java [http-bio-8090-exec-24])
* INFO  2014-10-10 15:26:37,417 Time: 110660 micros: Got aggregated values
(Time
r.java [http-bio-8090-exec-24])
------
[image: Inline image 1]


On Fri, Oct 10, 2014 at 2:39 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> You mean you CAN NOT view in Pivot Table? Did you clear your browser cache?
>
> On Fri, Oct 10, 2014 at 9:32 AM, <rin.channara@xxxxxxxxx> wrote:
>
>>  Hi Jan,
>> I tried to download the link below:
>> *https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war*
>> <https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war>
>> to check the fix with pivot table, when after I update and I run
>> maintenance, resource table and run analytic and data mart. I still can
>> view data value with detail in pivot table. IT WORK FINE IN DATA VISUALIZE
>>
>> *From:* Jan Henrik Øverland <janhenrik.overland@xxxxxxxxx>
>> *Sent:* ‎Tuesday‎, ‎October‎ ‎07‎, ‎2014 ‎3‎:‎25‎ ‎Evening
>> *To:* channara rin <rin.channara@xxxxxxxxx>
>> *Cc:* Knut Staring <knutst@xxxxxxxxx>, DHIS 2 Users list
>> <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list
>> <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>
>> Ok, I have checked and this bug has been fixed in the 2.16 branch. So
>> please just update the war file to the "most stable" version of 2.16:
>>
>>
>> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>>
>> On Tue, Oct 7, 2014 at 9:42 AM, Jan Henrik Øverland <
>> janhenrik.overland@xxxxxxxxx> wrote:
>>
>>> I mean I understand what the problem is now.
>>>
>>> The link I gave you is *not* the development version (trunk). It is
>>> 2.16 with small fixes to issues that have been discovered after the
>>> release. So I recommend using it anyway.
>>>
>>> On Tue, Oct 7, 2014 at 9:32 AM, <rin.channara@xxxxxxxxx> wrote:
>>>
>>>>  If so, it is great, and By the way, the link below is the stable
>>>> version. I am afraid of problem of development version.
>>>> And what you mean misunderstood problem? you mean you don’t understand
>>>> my problem?
>>>>
>>>> Thank you
>>>> CHANNARA
>>>>
>>>> *From:* Jan Henrik Øverland <janhenrik.overland@xxxxxxxxx>
>>>> *Sent:* ‎Tuesday‎, ‎October‎ ‎07‎, ‎2014 ‎2‎:‎26‎ ‎Evening
>>>> *To:* Knut Staring <knutst@xxxxxxxxx>
>>>> *Cc:* channara rin <rin.channara@xxxxxxxxx>, DHIS 2 Users list
>>>> <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list
>>>> <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>>>
>>>> Hi, I just got login credentials from Knut to your server. I
>>>> misunderstood the problem. Will have a closer look at this.
>>>>
>>>> On Tue, Oct 7, 2014 at 9:19 AM, Jan Henrik Øverland <
>>>> janhenrik.overland@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Rin,
>>>>>
>>>>> I think this will work for you with the latest 2.16 build:
>>>>>
>>>>> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>>>>>
>>>>> Jan
>>>>>
>>>>> On Tue, Oct 7, 2014 at 6:06 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>>>
>>>>>> Unfortunately, I dont. Any messages in the Chrome console (F12)?
>>>>>>
>>>>>> On 7 Oct 2014 04:58, <rin.channara@xxxxxxxxx> wrote:
>>>>>> >
>>>>>> > Hi knut,
>>>>>> > If I view datavalue in “detail” with “Data Visualizer”, It work
>>>>>> fine. But if I view datavalue in “detail” with “Pivot Table”, it shows
>>>>>> blank.
>>>>>> >
>>>>>> > Do you know that problem?
>>>>>> >
>>>>>> > CHANNARA
>>>>>> >
>>>>>> > From: channara rin
>>>>>> > Sent: ‎Monday‎, ‎October‎ ‎06‎, ‎2014 ‎4‎:‎53‎ ‎Evening
>>>>>> > To: Knut Staring
>>>>>> >
>>>>>> > Cc: DHIS 2 Developers list, DHIS 2 Users list
>>>>>> >
>>>>>> > YES, sure. I has.
>>>>>> > -DHIS2 v2.16
>>>>>> > -Build:16317
>>>>>> > -DB: Postgresql
>>>>>> >
>>>>>> > Sent from Windows Mail
>>>>>> >
>>>>>> > From: Knut Staring
>>>>>> > Sent: ‎Monday‎, ‎October‎ ‎06‎, ‎2014 ‎4‎:‎48‎ ‎Evening
>>>>>> > To: channara rin
>>>>>> > Cc: DHIS 2 Developers list, DHIS 2 Users list
>>>>>> >
>>>>>> > Do you have a categoryoption combo other than Default attached to
>>>>>> this data element?
>>>>>> >
>>>>>> > The "Detail" view is meant for when you have breakdowns by Male and
>>>>>> Female or something like that.
>>>>>> >
>>>>>> > Knut
>>>>>> >
>>>>>> > On Mon, Oct 6, 2014 at 11:35 AM, <rin.channara@xxxxxxxxx> wrote:
>>>>>> >>
>>>>>> >> Hi all Dev,
>>>>>> >> I can’t view data value of data element in “detail” level at pivot
>>>>>> table. but I can view data value of data element in “total” at pivot table
>>>>>> only.
>>>>>> >> DO you know what is the problem
>>>>>> >>
>>>>>> >> Thank you
>>>>>> >> CHANNARA
>>>>>> >>
>>>>>> >> _______________________________________________
>>>>>> >> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> >> More help   : https://help.launchpad.net/ListHelp
>>>>>> >>
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> > --
>>>>>> > Knut Staring
>>>>>> > Dept. of Informatics, University of Oslo
>>>>>> > +4791880522
>>>>>> > Skype: knutstar
>>>>>> > http://dhis2.org
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> Skype: knutstar
> http://dhis2.org
>

PNG image


References