select view via WEBTOOLS/Entity SQL Processor

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

select view via WEBTOOLS/Entity SQL Processor

S.Hage
Hi all,
        I'm trying to visiualize the data in PortalPagePortletView views via WEBTOOLS/Entity SQL Processor, the problem is, when I try this 'select * from Portal_Page_Portlet_View' I get the error:
 
SQL Exception while executing the following:select * from Portal_Page_Portlet_View (Table/View 'PORTAL_PAGE_PORTLET_VIEW' does not exist.)

Any help is appriciated


Saad.
Reply | Threaded
Open this post in threaded view
|

Re: select view via WEBTOOLS/Entity SQL Processor

Adrian Crum
Views are not tables.

-Adrian

On 7/7/2010 11:08 AM, S.Hage wrote:

>
> Hi all,
> I'm trying to visiualize the data in PortalPagePortletView views via
> WEBTOOLS/Entity SQL Processor, the problem is, when I try this 'select *
> from Portal_Page_Portlet_View' I get the error:
>
> SQL Exception while executing the following:select * from
> Portal_Page_Portlet_View (Table/View 'PORTAL_PAGE_PORTLET_VIEW' does not
> exist.)
>
> Any help is appriciated
>
>
> Saad.
Reply | Threaded
Open this post in threaded view
|

Re: select view via WEBTOOLS/Entity SQL Processor

Patrick-4
In reply to this post by S.Hage
Hi Saad,
Go to https://localhost:8443/webtools/control/entityref  scroll down
to ENTITY: PortalPagePortletView  then click "view data"
Patrick


On Wed, Jul 7, 2010 at 1:08 PM, S.Hage <[hidden email]> wrote:

>
> Hi all,
>        I'm trying to visiualize the data in PortalPagePortletView views via
> WEBTOOLS/Entity SQL Processor, the problem is, when I try this 'select *
> from Portal_Page_Portlet_View' I get the error:
>
> SQL Exception while executing the following:select * from
> Portal_Page_Portlet_View (Table/View 'PORTAL_PAGE_PORTLET_VIEW' does not
> exist.)
>
> Any help is appriciated
>
>
> Saad.
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/select-view-via-WEBTOOLS-Entity-SQL-Processor-tp2281297p2281297.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>