Using PowerShell variables in CAML Queries?

Question

I'm trying to reconfigure scripts I made to move list items from one list to another. At the time the list were not going to change so all the variables were hard coded.

Is it possible to use a PowerShell variable in a CAML query?

for example

$IDNum = 2

$query = '<query>
<where>
<eq>
<FieldRef Name="ID"
<Value Type="Number">$IDNum</value>
</eq>
</where>
</query>'

Aanchal · Accepted Answer · 2014-09-16 15:04:08Z

2

Double quoted string expand variables and single quoted strings do not. Use like this:

$query = "<query>
<where>
<eq>
<FieldRef Name="ID"
<Value Type="Number">$IDNum</value>
</eq>
</where>
</query>"

http://blogs.msdn.com/b/powershell/archive/2006/07/15/variable-expansion-in-strings-and-herestrings.aspx

answered Sep 16, 2014 at 15:04

Aanchal

7,8851 gold badge17 silver badges20 bronze badges

I've always seen it as $($IDNum), did not know the parentheses were not needed. Learned something new today :)

wjervis
– wjervis

2014-09-16 15:08:57 +00:00
Commented Sep 16, 2014 at 15:08

Add a comment |

Stack Exchange Network

Using PowerShell variables in CAML Queries?

1 Answer 1

Your Answer

Hot Network Questions

Using PowerShell variables in CAML Queries?

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions