how to see data in view table?

[CaseT]

Hi,

I'd like to see what's in the OrderReportSalesGroupByProduct table.
Can't do it via WebTools->Entity Data Maintenance
Can't do via postgres.
I'm trying to track down why my productReportList is not being populated.
On my dev server everything works fine but on my production server I get the
OrderNoOrderFound which is the <#else for the
<#if productReportList?has_content...

TIA, Case

---
Case Torres
[hidden email]

[BJ Freeman]

Case:
Entity Data Maintenance
of you do a find on the entity, and there is data.
sounds like your doing some customization.
what version of the trunk are you using?


Case Torres sent the following on 6/10/2008 2:41 PM:

> Hi,
>
> I'd like to see what's in the OrderReportSalesGroupByProduct table.
> Can't do it via WebTools->Entity Data Maintenance
> Can't do via postgres.
> I'm trying to track down why my productReportList is not being populated.
> On my dev server everything works fine but on my production server I get the
> OrderNoOrderFound which is the <#else for the
> <#if productReportList?has_content...
>
> TIA, Case
>
> ---
> Case Torres
> [hidden email]
>
>
>

[CaseT]

I'm using Release 4
For that particular view entity no data shows.
Some of the view entities are like that I guess.
I must have accidentally did something but I can't find it.
I guess I'm wondering how best to troubleshoot this.
For some reason the productReportList has no content yet the
ReportScreens.xml file looks identical to my dev server.
I'll just keep at it.

Thanks,

Case Torres
[hidden email]

 

> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Tuesday, June 10, 2008 4:25 PM
> To: [hidden email]
> Subject: Re: how to see data in view table?
>
> Case:
> Entity Data Maintenance
> of you do a find on the entity, and there is data.
> sounds like your doing some customization.
> what version of the trunk are you using?
>
>
> Case Torres sent the following on 6/10/2008 2:41 PM:
> > Hi,
> >
> > I'd like to see what's in the OrderReportSalesGroupByProduct table.
> > Can't do it via WebTools->Entity Data Maintenance Can't do via
> > postgres.
> > I'm trying to track down why my productReportList is not
> being populated.
> > On my dev server everything works fine but on my production
> server I
> > get the OrderNoOrderFound which is the <#else for the <#if
> > productReportList?has_content...
> >
> > TIA, Case
> >
> > ---
> > Case Torres
> > [hidden email]
> >
> >
> >
>

[Rishi Solanki]

Hello Case Torres,

One case I know that in which the datas are not shown in the web tools in
view entity. When ever you are using a group-by
in view entity definition.For example the "AcctgTransAndEntries" is working
fine while the "FinAccountTransSum" is not displying the records when its
member entity have. same is true for your case i.e.
"OrderReportSalesGroupByProduct".
The Webtools screen doesn't work properly with view entities with both
aggregate and normal fields because by default that screen selects all
fields.

Thanks and Regards
[Rishi Solanki]

On Wed, Jun 11, 2008 at 9:28 AM, Case Torres <[hidden email]>
wrote:

> I'm using Release 4
> For that particular view entity no data shows.
> Some of the view entities are like that I guess.
> I must have accidentally did something but I can't find it.
> I guess I'm wondering how best to troubleshoot this.
> For some reason the productReportList has no content yet the
> ReportScreens.xml file looks identical to my dev server.
> I'll just keep at it.
>
> Thanks,
>
> Case Torres
> [hidden email]
>
>
>
> > -----Original Message-----
> > From: BJ Freeman [mailto:[hidden email]]
> > Sent: Tuesday, June 10, 2008 4:25 PM
> > To: [hidden email]
> > Subject: Re: how to see data in view table?
> >
> > Case:
> > Entity Data Maintenance
> > of you do a find on the entity, and there is data.
> > sounds like your doing some customization.
> > what version of the trunk are you using?
> >
> >
> > Case Torres sent the following on 6/10/2008 2:41 PM:
> > > Hi,
> > >
> > > I'd like to see what's in the OrderReportSalesGroupByProduct table.
> > > Can't do it via WebTools->Entity Data Maintenance Can't do via
> > > postgres.
> > > I'm trying to track down why my productReportList is not
> > being populated.
> > > On my dev server everything works fine but on my production
> > server I
> > > get the OrderNoOrderFound which is the <#else for the <#if
> > > productReportList?has_content...
> > >
> > > TIA, Case
> > >
> > > ---
> > > Case Torres
> > > [hidden email]
> > >
> > >
> > >
> >
>
>