Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Design your application
Limit results in a n:n pivot table based on value
  • Page:
  • 1

TOPIC:

Limit results in a n:n pivot table based on value 10 Aug 2016 11:48 #14413

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
I have a table called

table1

and another two tables called

regions,
territories

territories all have a FK of region (i.e territories belong to a region)

Table1 has two cross reference tables

table1 - regions (n:n)
table1 - territories (n:)

and using the pivot method built into J-Cook builder by default

I want to make it so that a person chooses REGIONS first when completing table1 (multiselect, entries go into table1region XRef table), but then in the next field, rather than being able to multselect ALL TERRITORIES, they are only presented with those that belong to any selected regions.

I can obviously fire an auto save when a user adds regions, but quite sure what model to alter to build in the complex join for the territories XRef

Any advise greatly appreciated
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla

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

Last edit: by MorganL.
  • Page:
  • 1
Forum
Support forum
Design your application
Limit results in a n:n pivot table based on value
Time to create page: 0.068 seconds
“
”

Awards for the best Joomla app. This product is gonna win an award for this amazing job. Cook Self Service is the the best application from all over the Joomla universe ! It brings Joomla to a professional level really advanced for developers. It is a real fun to develop with it. The ACL part and security checks implementation are just... so much hours saved. I can now concentrate myself more on the design part and the creative works. Thank you so much. Guys I offer you all my congratulation ! Keep up the works because Joomla is needing it to increase the quality of extensions availables on the JED. I also learned a lot because I can see how to code at the proper place and I found all my answers reading the forum.
lack_hanson (JED)
          

Get Started

Log In Sign In