<?xml version="1.0" encoding="UTF-8"?>
<query-mapping package='Atlas.Microblog.Models'>
    <description>
      List of microblog messages
    </description>
    <class name="Atlas.Microblog.Models.List_Info" bean="yes">
        <comment>The list of microblogs.</comment>
        <property type='Identifier' name="id">
            <comment>the mblog identifier.</comment>
        </property>
        <property type='String' name="message">
            <comment>the microblog message.</comment>
        </property>
        <property type='Date' name="create_date">
            <comment>the microblog creation date.</comment>
        </property>
        <property type='String' name="name">
            <comment>the author's name.</comment>
        </property>
        <property type='String' name="email">
            <comment>the author's email address.</comment>
        </property>
    </class>
    <query name='list'>
       <comment>Get the list of blogs that the current user can update</comment>
       <sql>
    SELECT
      mblog.id,
      mblog.message,
      mblog.create_date,
      user.name,
      email.email
    FROM mblog AS mblog
    INNER JOIN user ON mblog.author_id = user.id
    INNER JOIN email ON mblog.author_id = email.user_id
    ORDER BY mblog.create_date ASC
       </sql>
    </query>
</query-mapping>

Add a query to list the microblogs
Add a query to list the microblogs
