Support » Plugin: Exports and Reports » Filter Functions?

  • Resolved lok1728


    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!

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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!

    Plugin Author Scott Kingsley Clark


    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Filter Functions?’ is closed to new replies.