<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="io.metersphere.plan.mapper.ExtTestPlanMapper">

    <select id="selectByParentId" resultType="java.lang.String">
        SELECT id FROM test_plan WHERE parent_id = #{parentId}
    </select>
    <select id="selectByParentIdList" resultType="java.lang.String">
        SELECT id FROM test_plan WHERE parent_id IN
        <foreach collection="list" item="item" open="(" separator="," close=")">
            #{item}
        </foreach>
    </select>
</mapper>