Forums

Home » Liferay Portal » English » 3. Development

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Abhi Ed
database call in navigation.vm
July 17, 2012 1:19 AM
Answer

Abhi Ed

Rank: Regular Member

Posts: 118

Join Date: June 4, 2012

Recent Posts

hello,
In my theme i have a requirement that one of the navigation links will contain the list that will be dynamically populated after querying the database.
Can we make a database call in navigation.vm ?
Muzakir Khan
RE: database call in navigation.vm
July 17, 2012 3:02 AM
Answer

Muzakir Khan

Rank: Regular Member

Posts: 112

Join Date: March 14, 2012

Recent Posts

Abhi Ed:
hello,

Can we make a database call in navigation.vm ?

Think so yes, we can make a database call in navigation.vm using javascript..

Regards
Khan
Abhi Ed
RE: database call in navigation.vm
July 17, 2012 3:05 AM
Answer

Abhi Ed

Rank: Regular Member

Posts: 118

Join Date: June 4, 2012

Recent Posts

Muzakir Khan:
Abhi Ed:
hello,

Can we make a database call in navigation.vm ?

Think so yes, we can make a database call in navigation.vm using javascript..

Regards
Khan


Thanks Muzakir, Can u explain how this call can be performed by any example which can clarify this?
Muzakir Khan
RE: database call in navigation.vm
July 17, 2012 3:14 AM
Answer

Muzakir Khan

Rank: Regular Member

Posts: 112

Join Date: March 14, 2012

Recent Posts

Abhi Ed:

Thanks Muzakir, Can u explain how this call can be performed by any example which can clarify this?


I am sorry, you have to include the javascript code(onclick) for calling the database in your portal_normal.vm of your theme..
You just google javascript code for the same, u will get it..
Abhi Ed
RE: database call in navigation.vm
July 17, 2012 3:52 AM
Answer

Abhi Ed

Rank: Regular Member

Posts: 118

Join Date: June 4, 2012

Recent Posts

Muzakir Khan:
Abhi Ed:

Thanks Muzakir, Can u explain how this call can be performed by any example which can clarify this?


I am sorry, you have to include the javascript code(onclick) for calling the database in your portal_normal.vm of your theme..
You just google javascript code for the same, u will get it..



I don't know, how practical ur solution is,Muzakir.However,thanks for ur time.

The question stands open yet.If anyone has done like this before,please share ur ideas.
Priyanka Dhingra
RE: database call in navigation.vm
July 17, 2012 8:23 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

Hi,
Please check the following link
https://www.liferay.com/community/forums/-/message_boards/message/10559868
I think editing the velocityvariable class will give you access to your database and then you can access the variable with a $ in your init-custom.vm
I didnt tried anyways but that can be a possible solution(an idea).
Aravinth Raj Raju
RE: database call in navigation.vm
August 14, 2012 3:30 AM
Answer

Aravinth Raj Raju

Rank: Junior Member

Posts: 27

Join Date: October 3, 2011

Recent Posts

Hi,

I too have similar requirement, to load menus after querying from a custom table.
Plz post your ideas.

Thanks,
Aravinth Raj R.
David H Nebinger
RE: database call in navigation.vm
August 14, 2012 6:09 AM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 13224

Join Date: September 1, 2006

Recent Posts

Abhi Ed:
Can we make a database call in navigation.vm ?


Yes, although you shouldn't do things this way.

Navigation.vm is a velocity script, and tweaking the velocity context to include necessary stuff to run the query would not be good.

Instead you should wrap the logic into a Spring bean. Register the bean in the portal's Spring context, then use $utilLocator.findUtil("my spring bean") to get access to the spring bean in navigation.vm, call the bean, and handle the results.

Participate in the State of Liferay Community 2017. Help the community and even win some prizes!