返回首页

我有一个表上,有一个水平以下的查询,并在每个级别都有分层次,我想找到任何记录用户的水平/综盈。这个我想找到的所有记录:

(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>

(也显示调试字符串不包含正确的价值观。

回答

评论会员:标记Nischalke 时间:2012/02/06
尝试,如使用工具,以协助您建立的CAML。这将告诉你什么是错的(很多事情)这个查询
评论会员:Craig_ 时间:2012/02/06
晴我查询,我觉得感觉有点傻(左边的标签,在我的代码)

,虽然标记的链接: