WordPress.org

Forums

Exports and Reports
[resolved] Filter Functions? (3 posts)

  1. lok1728
    Member
    Posted 2 years ago #

    How would I go about truncating a field such as the excerpt? I am using the following:
    SELECT ID,post_title,post_name,post_date,post_status,post_content,post_excerpt, LEFT(post_excerpt, 20) FROM wp_posts WHERE (post_type='post') AND (post_status='publish') AND (post_date BETWEEN '2012-08-01' AND '2012-08-31')
    The LEFT obviously will not work for the fields or the export. Is there a way to limit the characters on this field in the filter functions? Some help on how to do this would be awesome!
    Thanks!!

    http://wordpress.org/extend/plugins/exports-and-reports/

  2. lok1728
    Member
    Posted 2 years ago #

    I figured it out...
    I removed the post_excerpt but kept the LEFT(post_excerpt, 20) and then in my field I just used the LEFT(post_excerpt, 20) and that works!

    Awesome plugin btw!

  3. Scott Kingsley Clark
    Member
    Plugin Author

    Posted 2 years ago #

    Great, and thanks! Hope I get some more time to give this one a bit of love, I've got a full set of features planned along with a new UI I've already implemented in my primary project, Pods Framework.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Exports and Reports
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.