× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Dinamic SQL-WHERE Expression

More
9 years 2 months ago - 9 years 2 months ago #3136 by yolaqr
Dinamic SQL-WHERE Expression was created by yolaqr
Hi,
I want to have a diferent SQL-WHERE Expression depending on the article id where I have the buttom that fires the catalog view. I only found the option to put the SQL-WHERE Expression in the menu item, but you can only put an static value, I need it to be dinamic.

There is a petition (article) to be signed. I have a module with a buttom who points to the menu item that opens the catalog view of the table with the signatures of that article. In the SQL-WHERE Expression I have "idManifiesto = 69" where 69 is the article id. As new articles to be signed will be created and I do not want to create a menu item each time I need a way to make the SQL-WHERE Expression dinamic.

You can watch it at www.pemm.es/
The buttom is: "Ver os firmantes"

Thanx
Last edit: 9 years 2 months ago by yolaqr.

Please Log in to join the conversation.

Moderators: Dirkjoest