Keyword

Module display item according field value

  • Com3elles
  • Com3elles's Avatar Topic Author
  • Offline
  • New Member
More
5 months 3 weeks ago #174910 by Com3elles
hello i search a module to display item according same value in specific field
like a level field
regards

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

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
5 months 3 weeks ago #174915 by Fotis
Replied by Fotis on topic Module display item according field value
Can you re-phrase the question please?

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Com3elles
  • Com3elles's Avatar Topic Author
  • Offline
  • New Member
More
5 months 3 weeks ago #174919 by Com3elles
Replied by Com3elles on topic Module display item according field value
Sorry i mean
I have à sélect field with value for item
And i want to display à list of item where have the same value

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

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
5 months 2 weeks ago #174923 by Fotis
Replied by Fotis on topic Module display item according field value
Again, search getk2.org/extend for something that matches your needs.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Com3elles
  • Com3elles's Avatar Topic Author
  • Offline
  • New Member
More
5 months 2 weeks ago #174930 by Com3elles
Replied by Com3elles on topic Module display item according field value
but i didn't found anything all works only via tags ...
maybe i can add a function inside my template ...
but can you help me with sql request ?
SELECT * FROM XXX_k2_items WHERE extra_fields = 'MYVALUE'
i didn't find a good way to search inside extra_fields
regards

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

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
5 months 2 weeks ago #174946 by Fotis
Replied by Fotis on topic Module display item according field value
Can you give me a practical example of what you want to do? As detailed as possible please...

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Com3elles
  • Com3elles's Avatar Topic Author
  • Offline
  • New Member
More
5 months 2 weeks ago #174955 by Com3elles
Replied by Com3elles on topic Module display item according field value
hello my goal is to display a list of item where have same value in extra field like display 5 item with same value in price field
i try to create a sql request
like this
SELECT * FROM `x6072_k2_items`
where json_contains(extra_fields,'{"id":"7","Transferts inclus"}','$')=1 LIMIT 0, 25

an exemple of my value in k2 extra_fields
[{"id":"1","value":"0000 €"},
{"id":"2","value":" Des requins marteaux en abondance"},
{"id":"3","value":" images/Forfaits/c6bo-voyages-plongee-croisiere-plongee-a*-l-ile-coco-avec-la-flotte-sea-hunter"},
{"id":"4","value":""},
{"id":"5","value":""},
{"id":"6","value":""},
{"id":"7","value":"Transferts inclus"},
{"id":"8","value":""},
{"id":"9","value":""},
{"id":"10","value":"De décembre à*avril "},
{"id":"11","value":"bancs de requins marteaux, raies mantas "},
{"id":"12","value":"Niveau 2 / Advanced Open Water avec 50 plongées minimum, Deep Diver recommandé"},
{"id":"13","value":"7"},
{"id":"14","value":"5"},
{"id":"15","value":"1"}]

=> that reply
#3141 - Invalid JSON text in argument 1 to function json_contains: "Invalid escape character in string." at position 846.

maybe you have a better way ?

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

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
5 months 2 weeks ago - 5 months 2 weeks ago #174962 by Fotis
Replied by Fotis on topic Module display item according field value
JSON_CONTAINS() is not the proper function to use in such cases because K2 extra fields are an array of JSON objects.

Actually, it's better to use a simpler string search query like:
SELECT * FROM `#__k2_items` WHERE extra_fields LIKE '%{"id":"7","value":"Transferts inclus"}%' LIMIT 0, 25;

If you need to resort to such filtering, I would seriously recommend looking into K2 plugins. With a K2 plugin you can have your own DB table to store additional info and map that content with your K2 items. See my other post on using the example K2 plugin.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member
Last edit: 5 months 2 weeks ago by Fotis.

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

  • Com3elles
  • Com3elles's Avatar Topic Author
  • Offline
  • New Member
More
5 months 1 week ago #174988 by Com3elles
Replied by Com3elles on topic Module display item according field value
ok coool !
thanks

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

  • Fotis
  • Fotis's Avatar
  • Away
  • Administrator
  • JoomlaWorks Support Team
More
5 months 1 week ago #175003 by Fotis
Replied by Fotis on topic Module display item according field value
You're welcome.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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


Powered by Kunena Forum