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.202 seconds

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started