TOPIC:

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

liubov Offline 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 Offline 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

jonathanbell Offline Premium Member Posts: 147 Thank you received: 5	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 Offline 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 Offline 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

Forum

Ideas & Suggestions

Added functionalities

[ADDED] Multiselect on FK single select list filter

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)