HI Mikael,
You can do it something like this. I have used this and it works:

<result column="object_id" property="objectId"/>
       <!-- discriminators -->
       <discriminator column="active" nullValue="all" javaType="string">
           <subMap value="all"  resultMap="all"/>
           <subMap value="0" resultMap="inactive"/>
            <subMap value="1" resultMap="active"/>
         </discriminator>
   </resultMap>

<resultMap id="all" class="com.main.domain.Children">
       <result column="object_id" property="objectId"/>
       <!-- id translations -->
       <result column="object_id" property="children" select="
namespace.loadAllChildren"/>
   </resultMap>
   <resultMap id="inactive" class="com.main.domain.Children">
       <result column="object_id" property="objectId"/>
       <!-- id translations -->
       <result column="object_id" property="children" select="
namespace.loadInactiveChildren"/>
   </resultMap>
   <resultMap id="active" class="com.main.domain.Children">
       <result column="object_id" property="objectId"/>
       <!-- id translations -->
       <result column="object_id" property="children" select="
namespace.loadActiveChildrenl"/>
   </resultMap>

Thanks
Utkarsh

Reply via email to