Our site displays multiple Authors (Channel) and their associated Articles (Channel). The articles are related to the authors using Playa:
Channel Articles - Playa Field {article-author} (in this way the author can have multiple articles, but an article can only have one author)
**Our authors MUST import articles via CSV on a monthly basis and identify via a date field which day the post “goes live”. The site not only makes the author’s “Today” post available for viewing, but also Tomorrow’s.
Based on a thread in the Importer forum, we now know that we cannot import article entries via CSV (if using your Calendar module to control when entries are displayed)
We decided to try and stick with straight channel entries (using a EE date field for the day the article is to be viewed), and understood that Date Field Filter would allow us to dictate when an entry is displayed. However, because of the way we are using Playa it has seemed to complicate things.
Here is a simplified version of our TODAY template (and what we are trying to do)
{exp:channel:entries channel="authors" limit="1"}
{author-name}, {author-location}
<h2>Todays Article</h2>
<p> {exp:playa:parents field="article-author" limit="1"}<br />
{title}<br />
{article-date} (*this should only show todays or tomorrows entry*) <br />
{article-text}<br />
{/exp:playa:parents}<br />
{/exp:channel:entries}The issue is that when a full month’s worth of entries are created, we need to identify which article to display (the template above shows the last entered entry) - thus the need for record filtering on a date field.
The question then is, how do we make the template display the correct article for that author based on the {article-date} (EE Date Field) field on the article entry?
We have attempted to use Date Field Filter to solve this, but the inclusion of Playa makes it difficult. I has been suggested that we use PHP or Stash (in conjunction with DFF) to solve this - can anyone provide an example, or help with this?
Thanks so much!