OFBiz › OFBiz - User

Generating a Nested Menu

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

14 messages Options

Naveen Kumar-3

Generating a Nested Menu

Hi all,

My project spec requires that I need to create an ofbiz menu the following
way in a nested <ul> <li> structure:

...
PARTY
PROJECT
*SFA** ** (class="active")*
Main
Accounts
Contacts
* Leads** ** (class="active")*
Create New
*Create Lead From vCard ** (class="active")*
Competitors & Partners
Events
Documents
Forecast
Opportunities
Preferences
BUSINESS INTELLIGENCE
EBAY
...

The main-menu, app-menu and the button tabs ALL should come within a SINGLE
NESTED unordered list with specific classes (like <li class="active"> for
the current active APP/SCREEN). This single nested list should be
dynamically generated.

Is this possible to create such a list? If "yes", please suggest me some
ways to implement this (in code).

Thank you,
Naveen.

BJ Freeman

Re: Generating a Nested Menu

have you looked at the source code of a page, say for parytmgr, using
the different themes.
you will find your answer.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man

Naveen Kumar sent the following on 12/13/2010 5:53 AM:

> Hi all,
>
> My project spec requires that I need to create an ofbiz menu the following
> way in a nested<ul> <li> structure:
>
>
> ...
> PARTY
> PROJECT
> *SFA** ** (class="active")*
> Main
> Accounts
> Contacts
> * Leads** ** (class="active")*
> Create New
> *Create Lead From vCard ** (class="active")*
> Competitors& Partners
> Events
> Documents
> Forecast
> Opportunities
> Preferences
> BUSINESS INTELLIGENCE
> EBAY
> ...
>
>
>
> The main-menu, app-menu and the button tabs ALL should come within a SINGLE
> NESTED unordered list with specific classes (like<li class="active"> for
> the current active APP/SCREEN). This single nested list should be
> dynamically generated.
>
> Is this possible to create such a list? If "yes", please suggest me some
> ways to implement this (in code).
>
> Thank you,
> Naveen.
>

Bruno Busco

Re: Generating a Nested Menu

Hi Naveen,
unfortunately the multilevel menu is not completely implemented in the menu
widget.

We have had some discussion about it but not yet implemented.

You can find something interesting here:
https://issues.apache.org/jira/browse/OFBIZ-2104
https://issues.apache.org/jira/browse/OFBIZ-3373

Any contribution in this area will be greatly appreciated.

Regards,
Bruno

2010/12/14 BJ Freeman <[hidden email]>

> have you looked at the source code of a page, say for parytmgr, using the
> different themes.
> you will find your answer.
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat Y! messenger: bjfr33man
>
> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>
>
>
> Hi all,
>>
>> My project spec requires that I need to create an ofbiz menu the following
>> way in a nested<ul> <li> structure:
>>
>>
>> ...
>> PARTY
>> PROJECT
>> *SFA** ** (class="active")*
>> Main
>> Accounts
>> Contacts
>> * Leads** ** (class="active")*
>> Create New
>> *Create Lead From vCard ** (class="active")*
>> Competitors& Partners
>> Events
>> Documents
>> Forecast
>> Opportunities
>> Preferences
>> BUSINESS INTELLIGENCE
>> EBAY
>> ...
>>
>>
>>
>> The main-menu, app-menu and the button tabs ALL should come within a
>> SINGLE
>> NESTED unordered list with specific classes (like<li class="active"> for
>> the current active APP/SCREEN). This single nested list should be
>> dynamically generated.
>>
>> Is this possible to create such a list? If "yes", please suggest me some
>> ways to implement this (in code).
>>
>> Thank you,
>> Naveen.
>>
>>

Scott Gray-2

Re: Generating a Nested Menu

Hi Bruno,

Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this a couple of years ago...

Regards
Scott

On 14/12/2010, at 7:50 PM, Bruno Busco wrote:

> Hi Naveen,
> unfortunately the multilevel menu is not completely implemented in the menu
> widget.
>
> We have had some discussion about it but not yet implemented.
>
> You can find something interesting here:
> https://issues.apache.org/jira/browse/OFBIZ-2104
> https://issues.apache.org/jira/browse/OFBIZ-3373
>
> Any contribution in this area will be greatly appreciated.
>
> Regards,
> Bruno
>
> 2010/12/14 BJ Freeman <[hidden email]>
>
>> have you looked at the source code of a page, say for parytmgr, using the
>> different themes.
>> you will find your answer.
>>
>> =========================
>> BJ Freeman
>> Strategic Power Office with Supplier Automation <
>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>> Specialtymarket.com <http://www.specialtymarket.com/>
>> Systems Integrator-- Glad to Assist
>>
>> Chat Y! messenger: bjfr33man
>>
>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>
>>
>>
>> Hi all,
>>>
>>> My project spec requires that I need to create an ofbiz menu the following
>>> way in a nested<ul> <li> structure:
>>>
>>>
>>> ...
>>> PARTY
>>> PROJECT
>>> *SFA** ** (class="active")*
>>> Main
>>> Accounts
>>> Contacts
>>> * Leads** ** (class="active")*
>>> Create New
>>> *Create Lead From vCard ** (class="active")*
>>> Competitors& Partners
>>> Events
>>> Documents
>>> Forecast
>>> Opportunities
>>> Preferences
>>> BUSINESS INTELLIGENCE
>>> EBAY
>>> ...
>>>
>>>
>>>
>>> The main-menu, app-menu and the button tabs ALL should come within a
>>> SINGLE
>>> NESTED unordered list with specific classes (like<li class="active"> for
>>> the current active APP/SCREEN). This single nested list should be
>>> dynamically generated.
>>>
>>> Is this possible to create such a list? If "yes", please suggest me some
>>> ways to implement this (in code).
>>>
>>> Thank you,
>>> Naveen.
>>>
>>>

smime.p7s (3K) Download Attachment

Scott Gray-2

Re: Generating a Nested Menu

It looks like nested menu items are supported but not nesting other menus.

Regards
Scott

On 14/12/2010, at 9:14 PM, Scott Gray wrote:

> Hi Bruno,
>
> Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this a couple of years ago...
>
> Regards
> Scott
>
> On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
>
>> Hi Naveen,
>> unfortunately the multilevel menu is not completely implemented in the menu
>> widget.
>>
>> We have had some discussion about it but not yet implemented.
>>
>> You can find something interesting here:
>> https://issues.apache.org/jira/browse/OFBIZ-2104
>> https://issues.apache.org/jira/browse/OFBIZ-3373
>>
>> Any contribution in this area will be greatly appreciated.
>>
>> Regards,
>> Bruno
>>
>> 2010/12/14 BJ Freeman <[hidden email]>
>>
>>> have you looked at the source code of a page, say for parytmgr, using the
>>> different themes.
>>> you will find your answer.
>>>
>>> =========================
>>> BJ Freeman
>>> Strategic Power Office with Supplier Automation <
>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>> Specialtymarket.com <http://www.specialtymarket.com/>
>>> Systems Integrator-- Glad to Assist
>>>
>>> Chat Y! messenger: bjfr33man
>>>
>>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>>
>>>
>>>
>>> Hi all,
>>>>
>>>> My project spec requires that I need to create an ofbiz menu the following
>>>> way in a nested<ul> <li> structure:
>>>>
>>>>
>>>> ...
>>>> PARTY
>>>> PROJECT
>>>> *SFA** ** (class="active")*
>>>> Main
>>>> Accounts
>>>> Contacts
>>>> * Leads** ** (class="active")*
>>>> Create New
>>>> *Create Lead From vCard ** (class="active")*
>>>> Competitors& Partners
>>>> Events
>>>> Documents
>>>> Forecast
>>>> Opportunities
>>>> Preferences
>>>> BUSINESS INTELLIGENCE
>>>> EBAY
>>>> ...
>>>>
>>>>
>>>>
>>>> The main-menu, app-menu and the button tabs ALL should come within a
>>>> SINGLE
>>>> NESTED unordered list with specific classes (like<li class="active"> for
>>>> the current active APP/SCREEN). This single nested list should be
>>>> dynamically generated.
>>>>
>>>> Is this possible to create such a list? If "yes", please suggest me some
>>>> ways to implement this (in code).
>>>>
>>>> Thank you,
>>>> Naveen.
>>>>
>>>>
>

smime.p7s (3K) Download Attachment

Bruno Busco

Re: Generating a Nested Menu

Yes,
I think this is what the sub-menu attribute of the menu-item tag should be
for.
It is not implemented yet.

Regards,
Bruno

2010/12/14 Scott Gray <[hidden email]>

> It looks like nested menu items are supported but not nesting other menus.
>
> Regards
> Scott
>
> On 14/12/2010, at 9:14 PM, Scott Gray wrote:
>
> > Hi Bruno,
> >
> > Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this a
> couple of years ago...
> >
> > Regards
> > Scott
> >
> > On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
> >
> >> Hi Naveen,
> >> unfortunately the multilevel menu is not completely implemented in the
> menu
> >> widget.
> >>
> >> We have had some discussion about it but not yet implemented.
> >>
> >> You can find something interesting here:
> >> https://issues.apache.org/jira/browse/OFBIZ-2104
> >> https://issues.apache.org/jira/browse/OFBIZ-3373
> >>
> >> Any contribution in this area will be greatly appreciated.
> >>
> >> Regards,
> >> Bruno
> >>
> >> 2010/12/14 BJ Freeman <[hidden email]>
> >>
> >>> have you looked at the source code of a page, say for parytmgr, using
> the
> >>> different themes.
> >>> you will find your answer.
> >>>
> >>> =========================
> >>> BJ Freeman
> >>> Strategic Power Office with Supplier Automation <
> >>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> >>> Specialtymarket.com <http://www.specialtymarket.com/>
> >>> Systems Integrator-- Glad to Assist
> >>>
> >>> Chat Y! messenger: bjfr33man
> >>>
> >>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
> >>>
> >>>
> >>>
> >>> Hi all,
> >>>>
> >>>> My project spec requires that I need to create an ofbiz menu the
> following
> >>>> way in a nested<ul> <li> structure:
> >>>>
> >>>>
> >>>> ...
> >>>> PARTY
> >>>> PROJECT
> >>>> *SFA** ** (class="active")*
> >>>> Main
> >>>> Accounts
> >>>> Contacts
> >>>> * Leads** ** (class="active")*
> >>>> Create New
> >>>> *Create Lead From vCard ** (class="active")*
> >>>> Competitors& Partners
> >>>> Events
> >>>> Documents
> >>>> Forecast
> >>>> Opportunities
> >>>> Preferences
> >>>> BUSINESS INTELLIGENCE
> >>>> EBAY
> >>>> ...
> >>>>
> >>>>
> >>>>
> >>>> The main-menu, app-menu and the button tabs ALL should come within a
> >>>> SINGLE
> >>>> NESTED unordered list with specific classes (like<li class="active">
> for
> >>>> the current active APP/SCREEN). This single nested list should be
> >>>> dynamically generated.
> >>>>
> >>>> Is this possible to create such a list? If "yes", please suggest me
> some
> >>>> ways to implement this (in code).
> >>>>
> >>>> Thank you,
> >>>> Naveen.
> >>>>
> >>>>
> >
>
>

prashant punekar

Sub queries using entity engine !

Hi All,

Can we write a sub query using entity engine ?
Here is the query which is to be generated using entity engine.

Thanks in advance.

Regards,
Prashant

SELECT
pc.category_name
,COUNT(DISTINCT p.product_id)

FROM product_category_member pcm INNER JOIN
product_category pc
ON pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
(
SELECT p.product_id
FROM product p INNER JOIN
inventory_item ii
ON p.product_id = ii.product_id

GROUP BY p.product_id
HAVING SUM(ii.AVAILABLE_TO_PROMISE_TOTAL) > 0 /***no inventory**/) AS p

ON pcm.product_id = p.product_id
GROUP BY pc.category_name

________________________________

http://www.mindtree.com/email/disclaimer.html

BJ Freeman

Re: Sub queries using entity engine !

what was the entity or entity view that created this sql.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man

Prashant Punekar sent the following on 12/14/2010 11:16 AM:

> Hi All,
>
> Can we write a sub query using entity engine ?
> Here is the query which is to be generated using entity engine.
>
> Thanks in advance.
>
> Regards,
> Prashant
>
>
> SELECT
> pc.category_name
> ,COUNT(DISTINCT p.product_id)
>
> FROM product_category_member pcm INNER JOIN
> product_category pc
> ON pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
> (
> SELECT p.product_id
> FROM product p INNER JOIN
> inventory_item ii
> ON p.product_id = ii.product_id
>
> GROUP BY p.product_id
> HAVING SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)> 0 /***no inventory**/) AS p
>
> ON pcm.product_id = p.product_id
> GROUP BY pc.category_name
>
> ________________________________
>
> http://www.mindtree.com/email/disclaimer.html
>

Naveen Kumar-3

Re: Generating a Nested Menu

In reply to this post by Bruno Busco

Hi All,

I'm interested in developing this nested menu thing. Can you please give me
directions on how to proceed with this?

Regards,
Naveen.

On Tue, Dec 14, 2010 at 11:31 PM, Bruno Busco <[hidden email]> wrote:

> Yes,
> I think this is what the sub-menu attribute of the menu-item tag should be
> for.
> It is not implemented yet.
>
> Regards,
> Bruno
>
> 2010/12/14 Scott Gray <[hidden email]>
>
> > It looks like nested menu items are supported but not nesting other
> menus.
> >
> > Regards
> > Scott
> >
> > On 14/12/2010, at 9:14 PM, Scott Gray wrote:
> >
> > > Hi Bruno,
> > >
> > > Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this
> a
> > couple of years ago...
> > >
> > > Regards
> > > Scott
> > >
> > > On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
> > >
> > >> Hi Naveen,
> > >> unfortunately the multilevel menu is not completely implemented in the
> > menu
> > >> widget.
> > >>
> > >> We have had some discussion about it but not yet implemented.
> > >>
> > >> You can find something interesting here:
> > >> https://issues.apache.org/jira/browse/OFBIZ-2104
> > >> https://issues.apache.org/jira/browse/OFBIZ-3373
> > >>
> > >> Any contribution in this area will be greatly appreciated.
> > >>
> > >> Regards,
> > >> Bruno
> > >>
> > >> 2010/12/14 BJ Freeman <[hidden email]>
> > >>
> > >>> have you looked at the source code of a page, say for parytmgr, using
> > the
> > >>> different themes.
> > >>> you will find your answer.
> > >>>
> > >>> =========================
> > >>> BJ Freeman
> > >>> Strategic Power Office with Supplier Automation <
> > >>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> > >>> Specialtymarket.com <http://www.specialtymarket.com/>
> > >>> Systems Integrator-- Glad to Assist
> > >>>
> > >>> Chat Y! messenger: bjfr33man
> > >>>
> > >>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
> > >>>
> > >>>
> > >>>
> > >>> Hi all,
> > >>>>
> > >>>> My project spec requires that I need to create an ofbiz menu the
> > following
> > >>>> way in a nested<ul> <li> structure:
> > >>>>
> > >>>>
> > >>>> ...
> > >>>> PARTY
> > >>>> PROJECT
> > >>>> *SFA** ** (class="active")*
> > >>>> Main
> > >>>> Accounts
> > >>>> Contacts
> > >>>> * Leads** ** (class="active")*
> > >>>> Create New
> > >>>> *Create Lead From vCard ** (class="active")*
> > >>>> Competitors& Partners
> > >>>> Events
> > >>>> Documents
> > >>>> Forecast
> > >>>> Opportunities
> > >>>> Preferences
> > >>>> BUSINESS INTELLIGENCE
> > >>>> EBAY
> > >>>> ...
> > >>>>
> > >>>>
> > >>>>
> > >>>> The main-menu, app-menu and the button tabs ALL should come within a
> > >>>> SINGLE
> > >>>> NESTED unordered list with specific classes (like<li class="active">
> > for
> > >>>> the current active APP/SCREEN). This single nested list should be
> > >>>> dynamically generated.
> > >>>>
> > >>>> Is this possible to create such a list? If "yes", please suggest me
> > some
> > >>>> ways to implement this (in code).
> > >>>>
> > >>>> Thank you,
> > >>>> Naveen.
> > >>>>
> > >>>>
> > >
> >
> >
>

BJ Freeman

Re: Generating a Nested Menu

to clarify
the menu widget does do nested menus.
the part missing is if you have other menu widget you can not attach
them to a current menu widget and have them nested.

is the attachment of other menu widget what you are reffering to?

=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man
Naveen Kumar sent the following on 12/15/2010 6:18 AM:

> Hi All,
>
> I'm interested in developing this nested menu thing. Can you please give me
> directions on how to proceed with this?
>
> Regards,
> Naveen.
>
>
> On Tue, Dec 14, 2010 at 11:31 PM, Bruno Busco<[hidden email]> wrote:
>
>> Yes,
>> I think this is what the sub-menu attribute of the menu-item tag should be
>> for.
>> It is not implemented yet.
>>
>> Regards,
>> Bruno
>>
>> 2010/12/14 Scott Gray<[hidden email]>
>>
>>> It looks like nested menu items are supported but not nesting other
>> menus.
>>>
>>> Regards
>>> Scott
>>>
>>> On 14/12/2010, at 9:14 PM, Scott Gray wrote:
>>>
>>>> Hi Bruno,
>>>>
>>>> Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this
>> a
>>> couple of years ago...
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
>>>>
>>>>> Hi Naveen,
>>>>> unfortunately the multilevel menu is not completely implemented in the
>>> menu
>>>>> widget.
>>>>>
>>>>> We have had some discussion about it but not yet implemented.
>>>>>
>>>>> You can find something interesting here:
>>>>> https://issues.apache.org/jira/browse/OFBIZ-2104
>>>>> https://issues.apache.org/jira/browse/OFBIZ-3373
>>>>>
>>>>> Any contribution in this area will be greatly appreciated.
>>>>>
>>>>> Regards,
>>>>> Bruno
>>>>>
>>>>> 2010/12/14 BJ Freeman<[hidden email]>
>>>>>
>>>>>> have you looked at the source code of a page, say for parytmgr, using
>>> the
>>>>>> different themes.
>>>>>> you will find your answer.
>>>>>>
>>>>>> =========================
>>>>>> BJ Freeman
>>>>>> Strategic Power Office with Supplier Automation<
>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>>>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>>>>> Systems Integrator-- Glad to Assist
>>>>>>
>>>>>> Chat Y! messenger: bjfr33man
>>>>>>
>>>>>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hi all,
>>>>>>>
>>>>>>> My project spec requires that I need to create an ofbiz menu the
>>> following
>>>>>>> way in a nested<ul> <li> structure:
>>>>>>>
>>>>>>>
>>>>>>> ...
>>>>>>> PARTY
>>>>>>> PROJECT
>>>>>>> *SFA** ** (class="active")*
>>>>>>> Main
>>>>>>> Accounts
>>>>>>> Contacts
>>>>>>> * Leads** ** (class="active")*
>>>>>>> Create New
>>>>>>> *Create Lead From vCard ** (class="active")*
>>>>>>> Competitors& Partners
>>>>>>> Events
>>>>>>> Documents
>>>>>>> Forecast
>>>>>>> Opportunities
>>>>>>> Preferences
>>>>>>> BUSINESS INTELLIGENCE
>>>>>>> EBAY
>>>>>>> ...
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> The main-menu, app-menu and the button tabs ALL should come within a
>>>>>>> SINGLE
>>>>>>> NESTED unordered list with specific classes (like<li class="active">
>>> for
>>>>>>> the current active APP/SCREEN). This single nested list should be
>>>>>>> dynamically generated.
>>>>>>>
>>>>>>> Is this possible to create such a list? If "yes", please suggest me
>>> some
>>>>>>> ways to implement this (in code).
>>>>>>>
>>>>>>> Thank you,
>>>>>>> Naveen.
>>>>>>>
>>>>>>>
>>>>
>>>
>>>
>>
>

prashant punekar

RE: Sub queries using entity engine !

In reply to this post by BJ Freeman

Freeman,

This query is not generated. I want to generate this query using DynamicViewEntity object.
Is it possible to use the sub-query as the table alias and then do left outer join on it?

Regards,
Prashant

-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: Tuesday, December 14, 2010 11:25 AM
To: [hidden email]
Subject: Re: Sub queries using entity engine !

what was the entity or entity view that created this sql.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr33man

Prashant Punekar sent the following on 12/14/2010 11:16 AM:

David E. Jones-2

Re: Sub queries using entity engine !

You can do a nested query using the EntityWhereClause condition, just mix it in with other conditions you need as part of your condition tree. It won't be part of the entity definition, but rather the code that does the query.

-David

On Dec 15, 2010, at 1:55 PM, Prashant Punekar wrote:

> Freeman,
>
> This query is not generated. I want to generate this query using DynamicViewEntity object.
> Is it possible to use the sub-query as the table alias and then do left outer join on it?
>
> Regards,
> Prashant
>
>
> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Tuesday, December 14, 2010 11:25 AM
> To: [hidden email]
> Subject: Re: Sub queries using entity engine !
>
> what was the entity or entity view that created this sql.
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat Y! messenger: bjfr33man
>
>
> Prashant Punekar sent the following on 12/14/2010 11:16 AM:
>> Hi All,
>>
>> Can we write a sub query using entity engine ?
>> Here is the query which is to be generated using entity engine.
>>
>> Thanks in advance.
>>
>> Regards,
>> Prashant
>>
>>
>> SELECT
>> pc.category_name
>> ,COUNT(DISTINCT p.product_id)
>>
>> FROM product_category_member pcm INNER JOIN
>> product_category pc
>> ON pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
>> (
>> SELECT p.product_id
>> FROM product p INNER JOIN
>> inventory_item ii
>> ON p.product_id = ii.product_id
>>
>> GROUP BY p.product_id
>> HAVING SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)> 0 /***no inventory**/) AS p
>>
>> ON pcm.product_id = p.product_id
>> GROUP BY pc.category_name
>>
>> ________________________________
>>
>> http://www.mindtree.com/email/disclaimer.html
>>
>

David E. Jones-2

Re: Sub queries using entity engine !

Sorry, it's "EntityWhereString", not "EntityWhereClause".

-David

On Dec 15, 2010, at 3:49 PM, David E Jones wrote:

>
> You can do a nested query using the EntityWhereClause condition, just mix it in with other conditions you need as part of your condition tree. It won't be part of the entity definition, but rather the code that does the query.
>
> -David
>
>
> On Dec 15, 2010, at 1:55 PM, Prashant Punekar wrote:
>
>> Freeman,
>>
>> This query is not generated. I want to generate this query using DynamicViewEntity object.
>> Is it possible to use the sub-query as the table alias and then do left outer join on it?
>>
>> Regards,
>> Prashant
>>
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:[hidden email]]
>> Sent: Tuesday, December 14, 2010 11:25 AM
>> To: [hidden email]
>> Subject: Re: Sub queries using entity engine !
>>
>> what was the entity or entity view that created this sql.
>>
>> =========================
>> BJ Freeman
>> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>> Specialtymarket.com <http://www.specialtymarket.com/>
>> Systems Integrator-- Glad to Assist
>>
>> Chat Y! messenger: bjfr33man
>>
>>
>> Prashant Punekar sent the following on 12/14/2010 11:16 AM:
>>> Hi All,
>>>
>>> Can we write a sub query using entity engine ?
>>> Here is the query which is to be generated using entity engine.
>>>
>>> Thanks in advance.
>>>
>>> Regards,
>>> Prashant
>>>
>>>
>>> SELECT
>>> pc.category_name
>>> ,COUNT(DISTINCT p.product_id)
>>>
>>> FROM product_category_member pcm INNER JOIN
>>> product_category pc
>>> ON pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
>>> (
>>> SELECT p.product_id
>>> FROM product p INNER JOIN
>>> inventory_item ii
>>> ON p.product_id = ii.product_id
>>>
>>> GROUP BY p.product_id
>>> HAVING SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)> 0 /***no inventory**/) AS p
>>>
>>> ON pcm.product_id = p.product_id
>>> GROUP BY pc.category_name
>>>
>>> ________________________________
>>>
>>> http://www.mindtree.com/email/disclaimer.html
>>>
>>
>

Naveen Kumar-3

Re: Generating a Nested Menu

In reply to this post by BJ Freeman

Hi BJ,

Yes, it is *the attachment of other menu widget into a menu widget* that I'm
referring to. If the current menu widget does not support this, is there
any other way to do this?

Thanks,

Naveen

On Wed, Dec 15, 2010 at 10:45 PM, BJ Freeman <[hidden email]> wrote:

> to clarify
> the menu widget does do nested menus.
> the part missing is if you have other menu widget you can not attach them
> to a current menu widget and have them nested.
>
> is the attachment of other menu widget what you are reffering to?
>
>
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat Y! messenger: bjfr33man
> Naveen Kumar sent the following on 12/15/2010 6:18 AM:
>
>
> Hi All,
>>
>> I'm interested in developing this nested menu thing. Can you please give
>> me
>> directions on how to proceed with this?
>>
>> Regards,
>> Naveen.
>>
>>
>> On Tue, Dec 14, 2010 at 11:31 PM, Bruno Busco<[hidden email]>
>> wrote:
>>
>> Yes,
>>> I think this is what the sub-menu attribute of the menu-item tag should
>>> be
>>> for.
>>> It is not implemented yet.
>>>
>>> Regards,
>>> Bruno
>>>
>>> 2010/12/14 Scott Gray<[hidden email]>
>>>
>>> It looks like nested menu items are supported but not nesting other
>>>>
>>> menus.
>>>
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 14/12/2010, at 9:14 PM, Scott Gray wrote:
>>>>
>>>> Hi Bruno,
>>>>>
>>>>> Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this
>>>>>
>>>> a
>>>
>>>> couple of years ago...
>>>>
>>>>>
>>>>> Regards
>>>>> Scott
>>>>>
>>>>> On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
>>>>>
>>>>> Hi Naveen,
>>>>>> unfortunately the multilevel menu is not completely implemented in the
>>>>>>
>>>>> menu
>>>>
>>>>> widget.
>>>>>>
>>>>>> We have had some discussion about it but not yet implemented.
>>>>>>
>>>>>> You can find something interesting here:
>>>>>> https://issues.apache.org/jira/browse/OFBIZ-2104
>>>>>> https://issues.apache.org/jira/browse/OFBIZ-3373
>>>>>>
>>>>>> Any contribution in this area will be greatly appreciated.
>>>>>>
>>>>>> Regards,
>>>>>> Bruno
>>>>>>
>>>>>> 2010/12/14 BJ Freeman<[hidden email]>
>>>>>>
>>>>>> have you looked at the source code of a page, say for parytmgr, using
>>>>>>>
>>>>>> the
>>>>
>>>>> different themes.
>>>>>>> you will find your answer.
>>>>>>>
>>>>>>> =========================
>>>>>>> BJ Freeman
>>>>>>> Strategic Power Office with Supplier Automation<
>>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>>>>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>
>>>>>>> Chat Y! messenger: bjfr33man
>>>>>>>
>>>>>>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Hi all,
>>>>>>>
>>>>>>>>
>>>>>>>> My project spec requires that I need to create an ofbiz menu the
>>>>>>>>
>>>>>>> following
>>>>
>>>>> way in a nested<ul> <li> structure:
>>>>>>>>
>>>>>>>>
>>>>>>>> ...
>>>>>>>> PARTY
>>>>>>>> PROJECT
>>>>>>>> *SFA** ** (class="active")*
>>>>>>>> Main
>>>>>>>> Accounts
>>>>>>>> Contacts
>>>>>>>> * Leads** ** (class="active")*
>>>>>>>> Create New
>>>>>>>> *Create Lead From vCard ** (class="active")*
>>>>>>>> Competitors& Partners
>>>>>>>> Events
>>>>>>>> Documents
>>>>>>>> Forecast
>>>>>>>> Opportunities
>>>>>>>> Preferences
>>>>>>>> BUSINESS INTELLIGENCE
>>>>>>>> EBAY
>>>>>>>> ...
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> The main-menu, app-menu and the button tabs ALL should come within a
>>>>>>>> SINGLE
>>>>>>>> NESTED unordered list with specific classes (like<li class="active">
>>>>>>>>
>>>>>>> for
>>>>
>>>>> the current active APP/SCREEN). This single nested list should be
>>>>>>>> dynamically generated.
>>>>>>>>
>>>>>>>> Is this possible to create such a list? If "yes", please suggest me
>>>>>>>>
>>>>>>> some
>>>>
>>>>> ways to implement this (in code).
>>>>>>>>
>>>>>>>> Thank you,
>>>>>>>> Naveen.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>
>>>>
>>>>
>>>
>>