(Belong to the employee) AND (<has a="" greater="" level=""> OR <{has a level equal} AND has a greater sublevl}>)</has>
<where> <and> <eq> <fieldref name="AssignedTo" /> <value type="User"> <userid /> </value> </eq> <or> <gt> <fieldref name="Skill_x002d_Set_x0020_Level" /> <value type="Lookup">"+strEmpsSkillLvl+@"</value> </gt> <and> <eq> <fieldref name="Skill_x002d_Set_x0020_Level" /> <value type="Lookup">"+strEmpsSkillLvl+@"</value> </eq> <geq> <fieldref name="Station_x0020_Number" /> <value type="Number">"+strEmpsStationNumber+@"</value> </geq> </and> </or> </and> </where>
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>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)