Keyword

Batch : Adding Tags

  • STEPHAN HERBY
  • STEPHAN HERBY's Avatar Topic Author
  • Offline
  • Premium Member
More
4 years 3 months ago - 4 years 3 months ago #174312 by STEPHAN HERBY
Batch : Adding Tags was created by STEPHAN HERBY
Hi guys,
I have a websites with more then K2 5 000 items.
Some of them have a Tag "A" and some others a Tag "B". Some of them have both "A" and "B".

Today I need to create a page with all items Tagged with "A", "B" or both...
The link available in Menu for K2 allow to select only 1 tag (or did I miss something ?)

So, I decided to add a third tag on every item tagged with "A" or "B" called for example Tag "C", so I can create the link in my menu for the tag "C". I wanted to do that by SQL with "DB Replacer" from Regular Lab.
But the way Tags are managed in the database don't allow me to do that (or said in an other way : I don't know how to :-)

Does any one have an idea to go through this ?
Any advice would be really welcome.
Thanks in advance...
Last edit: 4 years 3 months ago by STEPHAN HERBY.

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

More
4 years 3 months ago #174315 by JoomlaWorks
Replied by JoomlaWorks on topic Batch : Adding Tags
This could be dealt in 2 ways in K2. Either allow creating a menu item to multiple tags or offer a way to batch add one or more tags to a set of items. Or both.

I can surely evaluate both options for future versions of K2.

But to do that now it would require running direct SQL queries to manually insert the new tag (C) on all items with tags A and B. Let me know if you'd want me to prepare them for you.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • STEPHAN HERBY
  • STEPHAN HERBY's Avatar Topic Author
  • Offline
  • Premium Member
More
4 years 3 months ago - 4 years 3 months ago #174316 by STEPHAN HERBY
Replied by STEPHAN HERBY on topic Batch : Adding Tags
Hi Fotis,
I'm sure that your solution "offer a way to batch add one or more tags to a set of items" will be welcome in K2 community. I have, on my side, met this situation several times :-)
For now, I probably need to run it through the direct SQL query.
But when i think about it, it is a SQL level i don't handle. If you could suggest me an SQL query in example, it would be really great...
Last edit: 4 years 3 months ago by STEPHAN HERBY.

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

More
4 years 3 months ago #174320 by JoomlaWorks
Replied by JoomlaWorks on topic Batch : Adding Tags
Will you need to add tag C *only* on items with tags A and B?

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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


Powered by Kunena Forum