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

TOPIC: [ADDED] Multiselect on FK single select list filter

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

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

In the Filter Tab, drag&drop 'List' object in your collection, that's all :)
The administrator has disabled public write access.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
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
The administrator has disabled public write access.

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

  • jonathanbell
  • jonathanbell's Avatar
  • Offline
  • Premium Member
  • Posts: 147
  • Thank you received: 5
  • Karma: 1
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
The administrator has disabled public write access.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
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
The administrator has disabled public write access.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
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
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.067 seconds

Get Started