Tribune

Home » Liferay Portal » English » 3. Development

Vista Combinata Vista Piatta Vista ad Albero
Discussioni [ Precedente | Successivo ]
toggle
Abhi Ed
database call in navigation.vm
17 luglio 2012 1.19
Risposta

Abhi Ed

Punteggio: Regular Member

Messaggi: 118

Data di Iscrizione: 4 giugno 2012

Messaggi recenti

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 luglio 2012 3.02
Risposta

Muzakir Khan

Punteggio: Regular Member

Messaggi: 112

Data di Iscrizione: 14 marzo 2012

Messaggi recenti

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 luglio 2012 3.05
Risposta

Abhi Ed

Punteggio: Regular Member

Messaggi: 118

Data di Iscrizione: 4 giugno 2012

Messaggi recenti

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 luglio 2012 3.14
Risposta

Muzakir Khan

Punteggio: Regular Member

Messaggi: 112

Data di Iscrizione: 14 marzo 2012

Messaggi recenti

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 luglio 2012 3.52
Risposta

Abhi Ed

Punteggio: Regular Member

Messaggi: 118

Data di Iscrizione: 4 giugno 2012

Messaggi recenti

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 luglio 2012 8.23
Risposta

Priyanka Dhingra

Punteggio: Liferay Master

Messaggi: 501

Data di Iscrizione: 19 dicembre 2011

Messaggi recenti

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 agosto 2012 3.30
Risposta

Aravinth Raj Raju

Punteggio: Junior Member

Messaggi: 27

Data di Iscrizione: 3 ottobre 2011

Messaggi recenti

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 agosto 2012 6.09
Risposta

David H Nebinger

Community Moderator

Punteggio: Liferay Legend

Messaggi: 13222

Data di Iscrizione: 1 settembre 2006

Messaggi recenti

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!