× 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

Initial Database Select/where clause

More
8 years 5 months ago #3610 by jcolls
Initial Database Select/where clause was created by jcolls
Hi There,

Is it possible, when setting up the database connection or elsewhere to set an overarching select and where clause.

I have found the where statement on the menu item which works well. However I have noticed that the general joomla search does not take this in to account and returns all DB entries. Also, if known/guessed, then the urls can retrieve all entries.

Thanks

Please Log in to join the conversation.

More
8 years 4 months ago #3676 by tiberius
Replied by tiberius on topic Initial Database Select/where clause
try this:

.......?option=com_joodb&view=catalog&format=html&reset=false&ordering=&orderby=&Itemid=210&task=&search=xxxxxxx&searchfield=xxxxxx
The following user(s) said Thank You: jcollsabc

Please Log in to join the conversation.

Moderators: Dirkjoest