WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. lok1728
    Member
    Posted 1 year 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 1 year 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 1 year 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

About this Topic

Tags

No tags yet.