adm-poc-backend/bogda/CLMT/query/problems.clmt

<templet>
	<version>1.0</version>
	<procedure _name="target">
		<parameters>
			<ref_parameter>
				<comment_id>2</comment_id>
				<name>floorId</name>
				<ref>resource/params.floorId</ref>
			</ref_parameter>
			<parameter>
				<comment_id>3</comment_id>
				<name>spaceId</name>
				<description>空间id</description>
				<format></format>
			</parameter>
		</parameters>
		<elements>
			<table_query>
				<name>query</name>
				<dataSource>poc</dataSource>
				<table>space_problem</table>
				<fields1>
					<bogda_item>
						<bogda_item>id</bogda_item>
						<bogda_null/>
					</bogda_item>
					<bogda_item>
						<bogda_item>spaceId</bogda_item>
						<bogda_null/>
					</bogda_item>
					<bogda_item>
						<bogda_item>content</bogda_item>
						<bogda_null/>
					</bogda_item>
					<bogda_item>
						<bogda_item>position</bogda_item>
						<bogda_null/>
					</bogda_item>
					<bogda_item>
						<bogda_item>floorId</bogda_item>
						<bogda_null/>
					</bogda_item>
				</fields1>
				<fieldsWhere>
					<floorId>=nvl(floorId, $disabled)</floorId>
					<spaceId>=nvl(spaceId, $disabled)</spaceId>
					<state>='1'</state>
				</fieldsWhere>
			</table_query>
		</elements>
		<output>
			<variable>
				<name>rtn</name>
				<assignment>query</assignment>
			</variable>
		</output>
	</procedure>
	<comments>
		<next_id>4</next_id>
		<list>
			<comment>
				<id>0</id>
				<items>
					<comment_item>
						<content>查询空间核查问题</content>
						<update_time>2021-6-9 12:52</update_time>
					</comment_item>
				</items>
			</comment>
			<comment>
				<id>1</id>
				<items>
					<comment_item>
						<content>不传递的话不生效</content>
						<update_time>2021-6-9 12:53</update_time>
					</comment_item>
				</items>
			</comment>
			<comment>
				<id>2</id>
				<items>
					<comment_item>
						<content>为空时过滤条件不生效</content>
						<update_time>2021-6-9 12:53</update_time>
					</comment_item>
				</items>
			</comment>
			<comment>
				<id>3</id>
				<items>
					<comment_item>
						<content>为空时过滤条件不生效</content>
						<update_time>2021-6-9 12:53</update_time>
					</comment_item>
				</items>
			</comment>
		</list>
	</comments>
	<comment_id>0</comment_id>
</templet>