Foren

Home » Liferay Portal » English » 3. Development

Kombinierte Ansicht Flache Ansicht Baumansicht
Threads [ Zurück | Nächste ]
toggle
Abhi Ed
database call in navigation.vm
17. Juli 2012 01:19
Antwort

Abhi Ed

Rang: Regular Member

Nachrichten: 118

Eintrittsdatum: 4. Juni 2012

Neue Beiträge

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
17. Juli 2012 03:02
Antwort

Muzakir Khan

Rang: Regular Member

Nachrichten: 112

Eintrittsdatum: 14. März 2012

Neue Beiträge

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
17. Juli 2012 03:05
Antwort

Abhi Ed

Rang: Regular Member

Nachrichten: 118

Eintrittsdatum: 4. Juni 2012

Neue Beiträge

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
17. Juli 2012 03:14
Antwort

Muzakir Khan

Rang: Regular Member

Nachrichten: 112

Eintrittsdatum: 14. März 2012

Neue Beiträge

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
17. Juli 2012 03:52
Antwort

Abhi Ed

Rang: Regular Member

Nachrichten: 118

Eintrittsdatum: 4. Juni 2012

Neue Beiträge

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
17. Juli 2012 08:23
Antwort

Priyanka Dhingra

Rang: Liferay Master

Nachrichten: 501

Eintrittsdatum: 19. Dezember 2011

Neue Beiträge

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
14. August 2012 03:30
Antwort

Aravinth Raj Raju

Rang: Junior Member

Nachrichten: 26

Eintrittsdatum: 3. Oktober 2011

Neue Beiträge

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
14. August 2012 06:09
Antwort

David H Nebinger

Community Moderator

Rang: Liferay Legend

Nachrichten: 11046

Eintrittsdatum: 1. September 2006

Neue Beiträge

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.