我有一个表上,有一个水平以下的查询,并在每个级别都有分层次,我想找到任何记录用户的水平/综盈。这个我想找到的所有记录:
(Belong to the employee) AND (<has a="" greater="" level=""> OR <{has a level equal} AND has a greater sublevl}>)</has>
这是我目前的查询:(使用问题),但它返回的记录,甚至不属于用户输入
{C}
*编辑
Yes list*
also by levels i'm refering to the data
I have a set of record of skills
with levels and parts ie:
-Level1
-part1
-part2
-part3
-Level1
-part1
-part2
-part3.
Also I have used CAML builder - however I seemed to have some issues getting the or encompassing the correct elements from what I have seen
Builder gives me the following which returns the wrong information still:
<pre><query>
<where>
<and>
<eq>
<fieldref name="AssignedTo" />
<value type="User"><userid /></value>
</eq>
<or>
<and>
<eq>
<fieldref name="Skill_x002d_Set_x0020_Level" />
<value type="Lookup">"+strEmpsSkillLvl+@"</value>
</eq>
<gt>
<fieldref name="Station_x0020_Number" />
<value type="Number">"+strEmpsStationNumber+@"</value>
</gt>
</and>
<gt>
<fieldref name="Skill_x002d_Set_x0020_Level" />
<value type="Lookup">" + strEmpsSkillLvl + @"</value>
</gt>
</or>
</and>
</where>
<orderby>
<fieldref name="Skill_x002d_Set_x0020_Level" ascending="True" />
<fieldref name="Station_x0020_Number" ascending="True" />
<fieldref name="Status" ascending="True" />
</orderby></query>
(也显示调试字符串不包含正确的价值观。