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.073 seconds
“
”

Freakin' Awesome!!! J-Cook is simply awesome - whether you're a highly experienced developer or complete novice whether you're building a small inventory component or a complete community solution! The beauty comes from a fast slick and reliable platform that readily provides developers with everything they'll need to build the backbone of a solid and secure component with wizards for authoring access publishing aliasing created/modified by dates... you name it COOK provides it! J-Cook really surpasses all of the 'competition' as far as MVC tools are concerned! Try love it and get cooking!
learnthrusong (JED)
          

Get Started

Log In Sign In