Look up articles based on custom field value?

richtestani · 2010-01-04 16:35:27

Is there a way to find articles using a ‘where’ style search?
I want to find articles on a custom field with a certain value.
How can I do this?

Thanks
Rich

Bloke · 2010-01-04 16:39:12

richtestani wrote:

I want to find articles on a custom field with a certain value.

Admin side: smd_where_used
Public side: smd_query

:-)

richtestani · 2010-01-04 16:58:36

Hi Stef – I notice your calendar plugin.

With that plugin, would I be able to output just the events (articles) by date/time in my own layout outside of a calendar layout?
I have date based articles that need to be sorted by date then time and im wondering if this would be an easier option than a custom query.

Thanks
Rich
So Ill need to find articles on this day and sort them by a time from a custom field (or does it work by posted date?)

Bloke · 2010-01-04 17:13:00

richtestani wrote:

would I be able to output just the events (articles) by date/time in my own layout outside of a calendar layout?

You can use smd_article_events, yes, which works like article_custom. However…

I have date based articles that need to be sorted by date then time…

You can use <txp:article /> and <txp:article_custom /> to sort by a custom field. Might be better than a plugin.

sort them by a time from a custom field (or does it work by posted date?)

With smd_calendar you can nominate a custom field to hold your articles’ posted dates and sort by that. But check out the native tag solution first and see if it works before trying the plugin.

richtestani · 2010-01-04 17:39:14

the problem i was having with the native tag, was i couldn’t search for articles based on values in a custom field. I could sort on it, but not search based on it.

I thought of using the posted date as the event date – but if events are in the future, and I set the posted date in the future, they wont display until that date – so future events are unknown until today.

els · 2010-01-04 17:41:17

Is there a reason you can’t use time="future"?

richtestani · 2010-01-04 17:45:58

No reason – only because im unaware of this.
Is this in an article_custom tag?
How is this used?
Thanks
Rich

richtestani · 2010-01-04 17:50:21

Ok – i looked it up in the tag reference.
I think this may just do what I need.

Thanks
Rich

els · 2010-01-04 17:51:49

Both article and article_custom can have the time attribute. Values can be past, future or any. Wouldn’t know what else to explain ;)
Since the sort works for the entire posted date, it will also consider the time, not only the date. So no need for a custom field :)

Edit: ah, you found it :)

Last edited by els (2010-01-04 17:52:14)

Textpattern CMS

Textpattern CMS support forum

#1 2010-01-04 16:35:27

Look up articles based on custom field value?

#2 2010-01-04 16:39:12

Re: Look up articles based on custom field value?

#3 2010-01-04 16:58:36

Re: Look up articles based on custom field value?

#4 2010-01-04 17:13:00

Re: Look up articles based on custom field value?

#5 2010-01-04 17:39:14

Re: Look up articles based on custom field value?

#6 2010-01-04 17:41:17

Re: Look up articles based on custom field value?

#7 2010-01-04 17:45:58

Re: Look up articles based on custom field value?

#8 2010-01-04 17:50:21

Re: Look up articles based on custom field value?

#9 2010-01-04 17:51:49

Re: Look up articles based on custom field value?

Board footer