Group by

  • jens_wp

    (@jens_wp)


    9 years ago

    I love this plugin. Thanks.
    Simple question I hope:
    How do I group two rows in my database that looks like this:

    Name Value1 Value2 (Headers)
    User1 100
    User1               200

    I would like the shortcode to output this:

    Name Value1 Value2 Difference (Headers)
    user1 100       200       100

    Is this possible with this wonderfull plugin?
    If so, could you please list the shortcode?

    Regards Jens

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years ago

    You would do this with a transform. There is a “group by“-like transform. I don’t think that quite does what you want. Alternatively you would need to write a transform class.

    Thread Starter jens_wp

    (@jens_wp)

    9 years ago

    OK.
    But I am not advanced enough to write a transform class.
    I will try if I can use the “group by”-like example.

    /Jens

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

Tags