Web Service SDK; Access to SI_AGGREGATE_COUNT?

[Former Member]

I am porting some code from .Net Enterprise SDK to the Web Service SDK (given the lack of .Net support in XI 3.0) and cannot see how to get hold of properties...

Example:

This code gets a count of InfoObjects in a given folder, it uses a helper function XI_GetObjectSet that runs the query and returns the result but I am looking at how I would get the SI_AGGREGATE_COUNT property and then the SI_ID value using the WS-SDK

Dim QRY As String = "select COUNT(SI_ID) from CI_INFOOBJECTS where SI_KIND='Folder' and SI_PARENTID=" + FolderID.ToString()
Dim ObjList As InfoObjects = XI_GetObjectSet(QRY)
Dim prop As [Property] = ObjList(1).Properties.Item("SI_AGGREGATE_COUNT")
Dim lCount As Long = CType(prop.Properties("SI_ID").Value, Long)

Any ideas if this sort of thing is possible using the WS-SDK?

[ted_ueda]

Last I tested, I was not able to run aggregate queries - get either a collection of COUNT(*) GenericInfoObject with wrong SI_AGGREGATE_COUNT value in the custom properties or a GET exception.

Redesign would be to just get the InfoObjects collection - you can page through it using the ResponseHolder.PagingDetails to get the number of pages and total number of records returned on first request.

Currently, the XI 3.1 - .NET SDK support - is slated for end of 2008Q3 with general availability next quarter, however, there's currently no official announcement of releaase date from Product.

Sincerely,

Ted Ueda