Test if POJO property exists

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Test if POJO property exists

Steven Nobile
Here is a snippet of code that I am having the issue with.
The employeeIdList may be present in the parameter or not.
This used to be in =iBatis as <isPropertyAvailable> and I am in the process of converting.  Much can be cleaned, but at this point I have just finished the Find/Replace using regular expressions.

I tried adding a parameterType="map" and then _parameter.containsKey("employeeIdList")
I tried <if test="_parameter.employeeIdList != null">

Any help would be greatly appreciated...Thanks

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
            <if test="groupIdList != null">
                <if test="groupIdList != null and trim(groupIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{groupIdList[]}), 9)
                    </foreach>           
                </if>
               </if>
            <if test="employeeIdList != null">
                <if test="employeeIdList != null and trim(employeeIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{employeeIdList[]}), 9)
                    </foreach>           
                </if>
            </if>

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Test if POJO property exists

Guy Rouillier-2
I would use the <if test> approach.  Your usage doesn't look correct. 
 
(1) You are testing "groupIdList != null" in the outer <if test>, but then do the same test again in a nested <if test>.  Why?
 
(2) You are test trim(groupIdList). trim() is a string function, not a collection function.  You probably want to be testing "groupIdList.size > 0"
 
(3) Inside the foreach loop, you are currently using "(#{groupIdList[]}".  You should be using #{item}.
 
Let us know if you continue to have issues after making those corrections.
 
--
Guy Rouillier
 
 
 
------ Original Message ------
From: "Steven Nobile" <[hidden email]>
To: "mybatis-user" <[hidden email]>
Sent: 4/28/2016 1:11:05 PM
Subject: Test if POJO property exists
 
Here is a snippet of code that I am having the issue with.
The employeeIdList may be present in the parameter or not.
This used to be in =iBatis as <isPropertyAvailable> and I am in the process of converting.  Much can be cleaned, but at this point I have just finished the Find/Replace using regular expressions.

I tried adding a parameterType="map" and then _parameter.containsKey("employeeIdList")
I tried <if test="_parameter.employeeIdList != null">

Any help would be greatly appreciated...Thanks

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
            <if test="groupIdList != null">
                <if test="groupIdList != null and trim(groupIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{groupIdList[]}), 9)
                    </foreach>           
                </if>
               </if>
            <if test="employeeIdList != null">
                <if test="employeeIdList != null and trim(employeeIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{employeeIdList[]}), 9)
                    </foreach>           
                </if>
            </if>

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.

Virus-free. www.avast.com

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Test if POJO property exists

Steven Nobile
OK.  Thanks for the insight.  This SQL was originally in iBatis 2 and after the conversion (basically first pass with Find and Replace) what you see is what was left.
I made the changes as you sugessted but I am getting this error:

### Error querying database.  Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'employeeIdList' in 'class mil.ndms.taa.af.business.tabledto.EmployeeGroup'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'employeeIdList' in 'class mil.ndms.taa.af.business.tabledto.EmployeeGroup'

Which is correct, we pass in pojos that may or maynot contain that property, hence the use of <isPropertyAvailable>

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
           
                <if test="groupIdList != null and groupIdList.size > 0">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{item}), 9)
                    </foreach>           
                </if>
                <if test="employeeIdList != null and employeeIdList.siz > 0">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{item}), 9)
                    </foreach>           
                </if>

On Friday, April 29, 2016 at 12:44:08 AM UTC-4, Guy Rouillier wrote:
I would use the <if test> approach.  Your usage doesn't look correct. 
 
(1) You are testing "groupIdList != null" in the outer <if test>, but then do the same test again in a nested <if test>.  Why?
 
(2) You are test trim(groupIdList). trim() is a string function, not a collection function.  You probably want to be testing "groupIdList.size > 0"
 
(3) Inside the foreach loop, you are currently using "(#{groupIdList[]}".  You should be using #{item}.
 
Let us know if you continue to have issues after making those corrections.
 
--
Guy Rouillier
 
 
 
------ Original Message ------
From: "Steven Nobile" <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="MM3Cr072BQAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">steven...@...>
To: "mybatis-user" <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="MM3Cr072BQAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">mybati...@...>
Sent: 4/28/2016 1:11:05 PM
Subject: Test if POJO property exists
 
Here is a snippet of code that I am having the issue with.
The employeeIdList may be present in the parameter or not.
This used to be in =iBatis as <isPropertyAvailable> and I am in the process of converting.  Much can be cleaned, but at this point I have just finished the Find/Replace using regular expressions.

I tried adding a parameterType="map" and then _parameter.containsKey("employeeIdList")
I tried <if test="_parameter.employeeIdList != null">

Any help would be greatly appreciated...Thanks

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
            <if test="groupIdList != null">
                <if test="groupIdList != null and trim(groupIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{groupIdList[]}), 9)
                    </foreach>           
                </if>
               </if>
            <if test="employeeIdList != null">
                <if test="employeeIdList != null and trim(employeeIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{employeeIdList[]}), 9)
                    </foreach>           
                </if>
            </if>

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="MM3Cr072BQAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">mybatis-user...@googlegroups.com.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

<a href="https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient&amp;utm_term=icon" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dicon\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGdgn6XHtGdGX0_ztl7zsznn9rycA&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dicon\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGdgn6XHtGdGX0_ztl7zsznn9rycA&#39;;return true;"> Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient&amp;utm_term=link" style="color:#4453ea" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dlink\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEBTW1oVO7X9WxlATGseHnM8Gn-HQ&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dlink\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEBTW1oVO7X9WxlATGseHnM8Gn-HQ&#39;;return true;">www.avast.com

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re[2]: Test if POJO property exists

Guy Rouillier-2
Not sure if this will address the issue you are having, but I see a typo:
 
<if test="employeeIdList != null and employeeIdList.siz > 0">
That should be size.
 
--
Guy Rouillier
 
 
 
------ Original Message ------
From: "Steven Nobile" <[hidden email]>
To: "mybatis-user" <[hidden email]>
Sent: 4/29/2016 9:25:55 AM
Subject: Re: Test if POJO property exists
 
OK.  Thanks for the insight.  This SQL was originally in iBatis 2 and after the conversion (basically first pass with Find and Replace) what you see is what was left.
I made the changes as you sugessted but I am getting this error:

### Error querying database.  Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'employeeIdList' in 'class mil.ndms.taa.af.business.tabledto.EmployeeGroup'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'employeeIdList' in 'class mil.ndms.taa.af.business.tabledto.EmployeeGroup'

Which is correct, we pass in pojos that may or maynot contain that property, hence the use of <isPropertyAvailable>

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
           
                <if test="groupIdList != null and groupIdList.size > 0">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{item}), 9)
                    </foreach>           
                </if>
                <if test="employeeIdList != null and employeeIdList.siz > 0">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{item}), 9)
                    </foreach>           
                </if>

On Friday, April 29, 2016 at 12:44:08 AM UTC-4, Guy Rouillier wrote:
I would use the <if test> approach.  Your usage doesn't look correct. 
 
(1) You are testing "groupIdList != null" in the outer <if test>, but then do the same test again in a nested <if test>.  Why?
 
(2) You are test trim(groupIdList). trim() is a string function, not a collection function.  You probably want to be testing "groupIdList.size > 0"
 
(3) Inside the foreach loop, you are currently using "(#{groupIdList[]}".  You should be using #{item}.
 
Let us know if you continue to have issues after making those corrections.
 
--
Guy Rouillier
 
 
 
------ Original Message ------
From: "Steven Nobile" <<A href="javascript:" rel=nofollow gdf-obfuscated-mailto="MM3Cr072BQAJ">steven...@...>
To: "mybatis-user" <<A href="javascript:" rel=nofollow gdf-obfuscated-mailto="MM3Cr072BQAJ">mybati...@...>
Sent: 4/28/2016 1:11:05 PM
Subject: Test if POJO property exists
 
Here is a snippet of code that I am having the issue with.
The employeeIdList may be present in the parameter or not.
This used to be in =iBatis as <isPropertyAvailable> and I am in the process of converting.  Much can be cleaned, but at this point I have just finished the Find/Replace using regular expressions.

I tried adding a parameterType="map" and then _parameter.containsKey("employeeIdList")
I tried <if test="_parameter.employeeIdList != null">

Any help would be greatly appreciated...Thanks

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
            <if test="groupIdList != null">
                <if test="groupIdList != null and trim(groupIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{groupIdList[]}), 9)
                    </foreach>           
                </if>
               </if>
            <if test="employeeIdList != null">
                <if test="employeeIdList != null and trim(employeeIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{employeeIdList[]}), 9)
                    </foreach>           
                </if>
            </if>

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <A href="javascript:" rel=nofollow gdf-obfuscated-mailto="MM3Cr072BQAJ">mybatis-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Virus-free. www.avast.com

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Re[2]: Test if POJO property exists

Steven Nobile
No that's not it.
It seems like it is testing the value of the property and not the property for null.
<isPropertyAvailable > checked to see if the property was there. 
<if test="property == null"> is testing the value of the property and fails if the property is not available.

On Saturday, April 30, 2016 at 3:00:02 AM UTC-4, Guy Rouillier wrote:
Not sure if this will address the issue you are having, but I see a typo:
 
<if test="employeeIdList != null and employeeIdList.siz > 0">
That should be size.
 
--
Guy Rouillier
 
 
 
------ Original Message ------
From: "Steven Nobile" <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="c9mcxk1MBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">steven...@...>
To: "mybatis-user" <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="c9mcxk1MBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">mybati...@...>
Cc: <a href="javascript:" target="_blank" gdf-obfuscated-mailto="c9mcxk1MBgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">guy.ro...@...
Sent: 4/29/2016 9:25:55 AM
Subject: Re: Test if POJO property exists
 
OK.  Thanks for the insight.  This SQL was originally in iBatis 2 and after the conversion (basically first pass with Find and Replace) what you see is what was left.
I made the changes as you sugessted but I am getting this error:

### Error querying database.  Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'employeeIdList' in 'class mil.ndms.taa.af.business.tabledto.EmployeeGroup'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'employeeIdList' in 'class mil.ndms.taa.af.business.tabledto.EmployeeGroup'

Which is correct, we pass in pojos that may or maynot contain that property, hence the use of <isPropertyAvailable>

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
           
                <if test="groupIdList != null and groupIdList.size > 0">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{item}), 9)
                    </foreach>           
                </if>
                <if test="employeeIdList != null and employeeIdList.siz > 0">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{item}), 9)
                    </foreach>           
                </if>

On Friday, April 29, 2016 at 12:44:08 AM UTC-4, Guy Rouillier wrote:
I would use the <if test> approach.  Your usage doesn't look correct. 
 
(1) You are testing "groupIdList != null" in the outer <if test>, but then do the same test again in a nested <if test>.  Why?
 
(2) You are test trim(groupIdList). trim() is a string function, not a collection function.  You probably want to be testing "groupIdList.size > 0"
 
(3) Inside the foreach loop, you are currently using "(#{groupIdList[]}".  You should be using #{item}.
 
Let us know if you continue to have issues after making those corrections.
 
--
Guy Rouillier
 
 
 
------ Original Message ------
From: "Steven Nobile" <[hidden email]>
To: "mybatis-user" <[hidden email]>
Sent: 4/28/2016 1:11:05 PM
Subject: Test if POJO property exists
 
Here is a snippet of code that I am having the issue with.
The employeeIdList may be present in the parameter or not.
This used to be in =iBatis as <isPropertyAvailable> and I am in the process of converting.  Much can be cleaned, but at this point I have just finished the Find/Replace using regular expressions.

I tried adding a parameterType="map" and then _parameter.containsKey("employeeIdList")
I tried <if test="_parameter.employeeIdList != null">

Any help would be greatly appreciated...Thanks

<select id="getEmployeeGroup" resultType="employeeGroup">
        SELECT    
                rtrim(ta_user_group_tbl.emplid)        as employeeId,
                rtrim(ta_user_group_tbl.groupid)    as groupId,
                rtrim(ta_user_group_tbl.startdate)    as startDate,
                rtrim(ta_user_group_tbl.enddate)    as enddate,
                rtrim(ta_user_group_tbl.rollover)    as rollover,
                rtrim(ta_group_tbl.groupname)        as groupName
       
        FROM    ta_user_group_tbl, ta_group_tbl
       
        WHERE    (ta_user_group_tbl.groupid = ta_group_tbl.groupid)
       
            <if test="groupIdList != null">
                <if test="groupIdList != null and trim(groupIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="groupIdList" open="(" close=")">
                        OR ta_user_group_tbl.groupid = rpad(rtrim(#{groupIdList[]}), 9)
                    </foreach>           
                </if>
               </if>
            <if test="employeeIdList != null">
                <if test="employeeIdList != null and trim(employeeIdList) != ''">
                    AND
                    <foreach item="item" index="index" collection="employeeIdList" open="(" close=")">
                        OR ta_user_group_tbl.emplid = rpad(rtrim(#{employeeIdList[]}), 9)
                    </foreach>           
                </if>
            </if>

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.
For more options, visit <a href="https://groups.google.com/d/optout" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

<a href="https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient&amp;utm_term=icon" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dicon\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGdgn6XHtGdGX0_ztl7zsznn9rycA&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dicon\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGdgn6XHtGdGX0_ztl7zsznn9rycA&#39;;return true;"> Virus-free. <a style="COLOR:#4453ea" href="https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=emailclient&amp;utm_term=link" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dlink\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEBTW1oVO7X9WxlATGseHnM8Gn-HQ&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient%26utm_term%3Dlink\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEBTW1oVO7X9WxlATGseHnM8Gn-HQ&#39;;return true;">www.avast.com

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.