Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC:

Multiselect on FK single select list filter 06 Jul 2017 06:06 #15237

  • liubov
  • liubov's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 279
  • Thank you received: 36
Yes there is a Filter List working with Foreigh keys.

In the Filter Tab, drag&drop 'List' object in your collection, that's all :)

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

Multiselect on FK single select list filter 06 Jul 2017 12:52 #15238

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
You need to instance the "List" filter from the toolbox on the left.
Then drop your FK field inside.
Coding is now a piece of cake

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

Multiselect on FK single select list filter 06 Jul 2017 19:06 #15239

Ah, I read the original post wrong. I thought this was talking about being able to select multiple items in a FK on an entry form , not the filter. I was looking to be able to multi select like you can when assigning users to a group in Joomla. e.g. you can select both Registered and Publisher or what ever etc . Happy to start a new discussion / question on this Chef

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

Multiselect on FK single select list filter 07 Jul 2017 10:27 #15244

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Make use of the Relations.
www.j-cook.pro/index.php/r/relations

Many to One
or
Many to Many

it depends what you want to do.
XREF nodes are opposite of FK node.
Then, the relation depends of the field you pick up from the tree.
When you drop in a form, you gonna get your multiselect input. With chosen...

The docs are coming. It is a long way...
Coding is now a piece of cake

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

Multiselect on FK single select list filter 07 Jul 2017 10:31 #15245

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Be aware if you want a N:m relation, you need to create a Pivot table,
and then instance the relation dragging the field node to the brick of your choice (form, fly, grid, filters,...)

If you do not have pivot, only N:1 relation is possible. (Reverse of 1:n).
You gonna see the difference in the fields tree. A pivot table adds a sub node level. Logic.
Coding is now a piece of cake

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

  • Page:
  • 1
  • 2
Time to create page: 0.142 seconds

Real time saver and great Component Builder tool ! I have been developing with J-Cook Pro Component Builder for several months now and can say with all honesty that this product/service is second to none. The product is feature rich and is being improved and added to all the time. Do yourself a favor if you need to build a Joomla! Component then you can do no wrong in trying the product. You will save on time and effort while being able to deliver your project on time. J-Cook pro does the hard work for you you then have the freedom to fully customise the end result for your own needs. 

One word: Awesome.
Edwardcox (JED)
         

Get Started