Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Coding inside your component
Filtering form List from Foreign Table
  • Page:
  • 1

TOPIC:

Filtering form List from Foreign Table 20 Nov 2012 20:46 #5520

I have a form that use a list of values from one of the other tables. For reasons discussed elsewhere, all records in that table are unpublished, and will always remain so, however, I need a list of them on the form I'm working on.
  1. Where in the generated code can I specify to list UNpublished records in the list?
  2. Where in the generated code can I add an additional WHERE clause to further filter that list?
With Cook V2,
My Source config is: jQuery, Condensed, Maximum, No
My "Advanced Custom" is Table, 20 seconds

Please Log in or Create an account to join the conversation.

Re: Filtering form List from Foreign Table 03 Jan 2013 20:29 #6347

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
You need to target the prepareQuery() function in the concerned model to add both where clauses. You'll be able to see exactly how by looking at the existing code.

Hope it helps,

Gez
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Coding inside your component
Filtering form List from Foreign Table
Time to create page: 0.075 seconds
“
”

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started

Log In Sign In