ARI Soft - Using Data, ARTICLES can we select articles by TAG

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Smart Content

Using Data, ARTICLES can we select articles by TAG

(1 viewing) (1) Guest

Page: 1

TOPIC: Using Data, ARTICLES can we select articles by TAG

Forum Tools

#64916

Using Data, ARTICLES can we select articles by TAG 5 Years, 6 Months ago	Karma: 0
On the Data builder, where you can select by articles... Can you select the ARTICLES by TAG? Can you choose to display specific CUSTOM FIELDS in the output? thanks!

rusasadmins

The administrator has disabled public write access.

#64919

Re:Using Data, ARTICLES can we select articles by TAG 5 Years, 6 Months ago	Karma: 760
Hello, Sorry, but articles data query builder doesn't support ability to select by tags. About custom fields, could you specify the widget (tabs, accordion or another) which you use the created query? Regards, ARI Soft

admin

The administrator has disabled public write access.

#65011

Re:Using Data, ARTICLES can we select articles by TAG 5 Years, 6 Months ago	Karma: 0
I was hoping to create a 'list view' in smart content, using a table...ideally.. 1. select articles by tag 2. include specific custom fields in the display But since we can't select by tag, at least for now, it doesn't help...although we could probably create the sql statement to build it manually.

rusasadmins

The administrator has disabled public write access.

#65030

Re:Using Data, ARTICLES can we select articles by TAG 5 Years, 6 Months ago Karma: 760

Hello,

The following SQL query can be used if want to select articles with "Red" or "Green" tag:

Code:



SELECT

  C.*

FROM

  #__content C INNER JOIN #__contentitem_tag_map TM

    ON C.id = TM.content_item_id

  INNER JOIN #__tags T

    ON TM.tag_id = T.id

WHERE

  T.path IN ('red', 'green')

GROUP BY

  C.id

It can be used with "DataTable" widget to show articles in a table view. Repeater plugin can be used if you need a custom layout.

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links