TOPIC:

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

gdpodesta
Topic Author
Offline
Senior Member
Posts: 75
Thank you received: 8

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.

Where in the generated code can I specify to list UNpublished records in the list?
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 Offline 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.076 seconds

“

”

Hi All just wanted to add one more "thank you" voice to all those who discovered the value of this amazing application. The website I was working on went to production few days ago and I do not want to even try to imagine what would it take to build it without j-cook. So - endless thanks keep it running and evolving I believe it deserves to be the core tool for any joomla application! Thanks!
Michael (bmk028 - Forum)

TOPIC:

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

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

Get Started

Newsletter