Return to Question

I need to write a Caml where satisfying the below condition:

projectstatus == "hold" OR projectstatus == "obsolete "
AND
  ilprilt not equal to "ilp frozen"

When I run this query, am getting records where

ilprilt not equal to "ilp frozen" and ilprilt not equal to "ilp not frozen"

I am missing something. Please help with the correct query. I believe the placement of AND / OR operator is giving me error

1. **projectstatus** -- list column
2. **ilprilt** -- list column
3. **projectstatus** values -- *hold* / *obsolete*
4. **ilprilt** values --- > *ilp not frozen* /*ilp frozen*

below is my query which isn't giving me correct results:

<Query> <Where> <Or> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Hold</Value> </Eq> <And> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Obsolete</Value> </Eq> <Neq> <FieldRef Name='ILPRILT' /> <Value Type='Choice'>ILP Frozen</Value> </Neq> </And> </Or> </Where> </Query>

  [![wrong-results-in-caml][1]][1]

I need to write a CAML query which satisfies the below condition:

projectstatus == "hold" OR projectstatus == "obsolete "
AND ilprilt not equal to "ilp frozen"

When I run this query, am getting records where

ilprilt not equal to "ilp frozen" and ilprilt not equal to "ilp not frozen"

I am missing something. Please help with the correct query. I believe the placement of AND / OR operator is giving me the error

projectstatus -- list column

Below is my query which isn't giving me correct results:

<Query>
    <Where>
        <Or>
            <Eq>
                <FieldRef Name='ProjectStatus' />
                <Value Type='Choice'>Hold</Value>
            </Eq>
            <And>
                <Eq>
                    <FieldRef Name='ProjectStatus' />
                    <Value Type='Choice'>Obsolete</Value>
                </Eq>
                <Neq>
                    <FieldRef Name='ILPRILT' />
                    <Value Type='Choice'>ILP Frozen</Value>
                </Neq>
            </And>
        </Or>
    </Where>
</Query>

i need to write a caml where staisfying the below condition: where projectstatus == "hold" OR projectstatus == "obsolete " AND ilprilt not equal to "ilp frozen" when i run this query am getting record where ilprilt not equal to "ilp frozen" and ilprilt not equal to "ilp not frozen" something is missing, where i am unable to find what should be the correct query ? I believe the placement of AND / OR operator is giving me error

1. **projectstatus** -- list column
2. **ilprilt** -- list column

 
1. **projectstatus** values -- *hold* / *obsolete*
2. **ilprilt** values --- > *ilp not frozen* /*ilp frozen*

below is my tried query / thats not giving me correct results:

<Query> <Where> <Or> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Hold</Value> </Eq> <And> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Obsolete</Value> </Eq> <Neq> <FieldRef Name='ILPRILT' /> <Value Type='Choice'>ILP Frozen</Value> </Neq> </And> </Or> </Where> </Query>

  [![wrong-results-in-caml][1]][1]

I need to write a Caml where satisfying the below condition:

projectstatus == "hold" OR projectstatus == "obsolete "
AND
ilprilt not equal to "ilp frozen"

When I run this query, am getting records where

ilprilt not equal to "ilp frozen" and ilprilt not equal to "ilp not frozen"

I am missing something. Please help with the correct query. I believe the placement of AND / OR operator is giving me error

1. **projectstatus** -- list column
2. **ilprilt** -- list column
3. **projectstatus** values -- *hold* / *obsolete*
4. **ilprilt** values --- > *ilp not frozen* /*ilp frozen*

below is my query which isn't giving me correct results:

<Query> <Where> <Or> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Hold</Value> </Eq> <And> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Obsolete</Value> </Eq> <Neq> <FieldRef Name='ILPRILT' /> <Value Type='Choice'>ILP Frozen</Value> </Neq> </And> </Or> </Where> </Query>

  [![wrong-results-in-caml][1]][1]

i need to write a caml where staisfying the below condition: where projectstatus == "hold" OR projectstatus == "obsolete " AND ilprilt not equal to "ilp frozen" when i run this query am getting record where ilprilt not equal to "ilp frozen" and ilprilt not equal to "ilp not frozen" something is missing, where i am unable to find what should be the correct query ?

1. **projectstatus** -- list column
2. **ilprilt** -- list column

1. **projectstatus** values -- *hold* / *obsolete*
2. **ilprilt** values --- > *ilp not frozen* /*ilp frozen*

below is my tried query / thats not giving me correct results:

<Query> <Where> <Or> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Hold</Value> </Eq> <And> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Obsolete</Value> </Eq> <Neq> <FieldRef Name='ILPRILT' /> <Value Type='Choice'>ILP Frozen</Value> </Neq> </And> </Or> </Where> </Query>

  [![wrong-results-in-caml][1]][1]

i need to write a caml where staisfying the below condition: where projectstatus == "hold" OR projectstatus == "obsolete " AND ilprilt not equal to "ilp frozen" when i run this query am getting record where ilprilt not equal to "ilp frozen" and ilprilt not equal to "ilp not frozen" something is missing, where i am unable to find what should be the correct query ? I believe the placement of AND / OR operator is giving me error

1. **projectstatus** -- list column
2. **ilprilt** -- list column

1. **projectstatus** values -- *hold* / *obsolete*
2. **ilprilt** values --- > *ilp not frozen* /*ilp frozen*

below is my tried query / thats not giving me correct results:

<Query> <Where> <Or> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Hold</Value> </Eq> <And> <Eq> <FieldRef Name='ProjectStatus' /> <Value Type='Choice'>Obsolete</Value> </Eq> <Neq> <FieldRef Name='ILPRILT' /> <Value Type='Choice'>ILP Frozen</Value> </Neq> </And> </Or> </Where> </Query>

  [![wrong-results-in-caml][1]][1]