Sep 29, 2008

Select-SPListItem

I've added a new function to my PowerShell Script Profile called Select-SPListItem.  Usually you have to select the SPListItem's columns via the indexer like $item['Title']. This approach doesn't work great with built in cmdlets like select-object, group-object, sort-object, nor with tools like PowerGadgets (out-chart :-). The idea was to built a function similar to select-object, see below. Yo can use it like this:

$list.Items | Select-SPListItem Title, TaskStatus | group-by TaskStatus

image

Another way to work more elegant with SPListItems is using the SPListItemCollection.GetDataTable() method.

$list.Items.GetDataTable() | group-by TaskStatus

The downside of this approach could be that it allocates more memory, usually that doesn't matter. I've found this approach on Jesper M. Christensen's blog - thanks.

15 comments:

Anonymous said...

Is it group-by or Group-Object?

Xj Cheng said...

Finding artist replica shoes requires a agog eye,as abounding knock-offs are of inferior quality.Shop at best food and acreage sales to acquisition replica handbags with admonition from chanel replica a able and claimed angel adviser in this chargeless video on fashion.They are just beating offs that they advertise on the streets,they attending absolute abundant like them but the superior is not traveling to be of advance even abutting to the absolute artist handbags so what I would acclaim is that you in fact go to louis vuitton replica the austerity food or you can go to like louis vuitton replica stores.In the New York streets you can of advance acquisition acceptable replicas but you absolutely charge to attending abutting so that you don't accept like the stitches are not that loose,you can acquisition absolutely acceptable ones if you go to gucci replica like absolutely old food that accept like you apperceive like affair food like,you will acquisition acceptable replicas there.Just abrasion one of these beauties to a affair and see the absorption you will be receiving.You do not accept to access any women.With Rolex replica watches on your wrist,the girls themselves will replica watches uk access you.The watch you are cutting is by itself a appearance account and it tells these women a lot about your taste.Women adopt men who advance their lives asperous and boxy and it is amazing to apperceive that those who abrasion Rolex replica watches on their wrist do arise asperous and tough.You accept hublot replica invested a baronial sum in the clothes you abrasion and to woo the babe of your life,you accept aswell assassin one of the classiest cars but what about the watch? Good and accounted watches are not accessible for appoint and it is at such moments that the Rolex replica watches advice you out of a bound spot.

pdf digital signature said...

You make some great points and I don't think I could have made them any better. Thanks for the good information !

swiss replica watches said...

Quickly these people today were irresistible suites full of international awards along with patents designed for timepiece layout plus advancement across timepiece products. Ditesheim's innovation don't truly Cartier Replica watches start off replica Rolex watches with all the Movado like identify that fake Hermes Birkin 40 bags might means "always within just motion" on Esperanto. The individual name weren't up to now cheap replica Prada Galleria handbags adopted up to the point finally 1905. Until finally todays, many belonging to the runs relating to Movado running watches, such simply because Juro along with Luno can be called belonging to the same speech. An instant check out the majority of Swiss Replica Watches the planet most well liked wrist running watches will tell you the iconic detect. Throughout 1912 an important Movado watch is made, and recognized, by developing an uncommonly classy movement which is 'shaped' to the curvature of any folks limb.

سما احمد said...


شركة تنظيف مساجد بالمدينة المنورة
شركة تنظيف واجهات حجر بالمدينة المنورة
شركة تنظيف واجهات زجاج بالمدينة المنورة
شركة تنظيف بيارات بالمدينة المنورة
شركة تنظيف قصور بالمدينة المنورة
شركة جلي بلاط بالمدينة المنورة
شركة صيانة مسابح بالمدينة المنورة
شركة تنظيف ستائر بالمدينة المنورة
شركة تنظيف اثاث بالمدينة المنورة

شركة عزل اسطح بالمدينة المنورة
شركة عزل خزانات بالمدينة المنورة

سما احمد said...

شركة كشف تسربات المياه بالمدينة المنورة
شركة تسليك مجاري بالمدينة المنورة
شركة تنظيف مسابح بالمدينة المنورة

سما احمد said...

شركة نقل عفش بالمدينة المنورة
شركة تخزين عفش بالمدينة المنورة
شركة مكافحة الفئران جنوب الرياض
كيفيه التخلص من الصراصير الصغيره فى المطبخ
شركة مكافحة الصراصير بالرياض
شركة مكافحة الصراصير شرق الرياض
شركة مكافحة الصراصير شمال الرياض
شركة مكافحة الصراصير غرب الرياض
شركة مكافحة الصراصير جنوب الرياض
شركة مكافحة بق الفراش بالرياض
شركة مكافحة بق الفراش شرق الرياض
شركة مكافحة بق الفراش شمال الرياض

Hug Day said...

happy hug day Images
hug day 2016 Wishes cards greetings
Hug day Gift Ideas For Him/Her
hug day sms for bf

Fangyaya said...

air jordan shoes
air jordan 4
louis vuitton outlet online
kobe shoes 11
louis vuitton outlet stores
toms shoes
air max 95
michael kors outlet clearance
coach outlet
ray ban outlet
louis vuitton outlet
hollister clothing
jordan 3 powder blue
nfl jerseys
louis vuitton outlet
longchamp le pliage
michael kors outlet clearance
kd 7 shoes
michael kors outlet online
louis vuitton
kobe 8
jordan retro 8
lebron james shoes 13
celine bags
nike store
pandora jewelry
louis vuitton purses
kate spade handbags
coach outlet
michael kors outlet online
nike running shoes
ralph lauren outlet
louis vuitton outlet
cheap jordans
coach factory outlet
michael kors purses
gucci belts
louis vuitton outlet stores
adidas yeezy 350
tory burch flats
20168.8chenjinyan

Justin said...

In the event that you don't come clean about these things you may discover later that the insurance agency won't make any installments on your cases, abandoning you to pay all therapeutic and repair costs yourself. aaa1autotitleloans.com/chicago

dada24 Xu said...

coach factory outlet
air jordan retro
coach factory outlet
ugg boots
polo outlet
ugg outlet
louis vuitton outlet
ralph lauren outlet online
adidas yeezy
adidas outlet
2065921caiyan

chenlina said...

chenlina20160923
mont blanc pens
louis vuitton outlet
uggs australia
uggs on sale
adidas trainers
longchamp outlet
nike roshe run
ralph lauren
adidas shoes
coach outlet store online clearances

Meiqing Xu said...

armani exchange
cheap nike shoes
coach outlet
ugg boots canada
kd 9 shoes
christian louboutin sale
michael kors outlet
moncler outlet
uggs
yeezy 350 boost
20161221caiyan

chenmeinv0 said...

louis vuitton
true religion outlet
michael kors outlet online sale
ray ban sunglasses
ray ban sunglasses
louis vuitton
adidas nmd
adidas outlet
michael kors outlet
dallas mavericks jerseys
hzx20170228

dong dong23 said...

michael kors handbags
birkenstock shoes
coach outlet store online clearances
kd 7 shoes
cheap ray ban sunglasses
adidas yeezy boost 350 v2
hermes bags
ecco boots
nike air max
pandora rings
2017.5.11chenlixiang