How to get the total number of items in an array

[Sean.Davey]

I am looking to get the total number of items in an array, so in the example below the data collect would display the number 9.  Does anyone know a good getter chain for this.  So far everything I have tried hasnt worked

Thanks

[<QueryResultSet>
<Metadata>
<Column name="cvcId" type="java.lang.Long"/>
<Column name="owner" type="java.lang.String"/>
<Column name="groupName" type="java.lang.String"/>
<Column name="opsName" type="java.lang.String"/>
<Column name="cvcType" type="java.lang.String"/>
<Column name="claimSystemId" type="java.lang.Long"/>
<Column name="hccClaimNumber" type="java.lang.String"/>
<Column name="receiptDate" type="java.sql.Date"/>
<Column name="claimType" type="java.lang.String"/>

[Mario.Morelli]

Hi

You should be able to use the below

toString().split(Column).length

Just check the value, I will double check but I think this getter chain returns the array count+1 for some reason.

Ciao

[Sean.Davey]

Thanks Mario.

This seems to have worked...How do I get it so that it will only look at that one section of the array and not go to other data being pulled?

Thanks

[Mario.Morelli]

Hi Sean

You will have to provide a bit more context as to what the entire data structure is that will be queried.

Is it always the same data structure, with different values?

Meaning is the array always in a certain section of the returned data, where would be the start and end pieces in the data to better answer your question.

Ciao