Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Design your application
Dynamic list with foreign key
  • Page:
  • 1

TOPIC:

Dynamic list with foreign key 15 May 2012 19:46 #2357

  • msr43
  • msr43's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 0
Unable to generate a dynamic list field using the foreign key.It shows up a simple textbox instead of the combo box with the values from the foreign table.

Regards
MSR

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

Re: Dynamic list with foreign key 16 May 2012 03:47 #2360

  • msr43
  • msr43's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 0
Finally I figured it out...It works great...

Only issue is that it pulls up all the data from the foreign key table.Even with rows mentioned as UnPublished in the foreign key table but it honors with view access level.

Also, Can I pull up only a subset of value from the foreign key table by using a where clause?

Usecase:

For Example all the reusable lists in enterprise application comes from one table and we call it as a lookup table.When querying the data for the specific list, we will add the where clause dynamically to filter the data.

Regards
MSR

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

Re: Dynamic list with foreign key 19 May 2012 11:14 #2380

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
The preparation of the data is processed in the View File.

Directly in the view, you can add a Where statement to the model that is queriing the datas.

For instance :
$myModel->addWhere('a.foo = ' . (int)$myValue );
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Design your application
Dynamic list with foreign key
Time to create page: 0.077 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