topic Re: How to get the total number of items in an array in Splunk AppDynamics

How to get the total number of items in an array

Sean_Davey — Tue, 21 Jul 2020 19:54:44 GMT

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"/>

Re: How to get the total number of items in an array

Morelz — Tue, 21 Jul 2020 22:27:59 GMT

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

Re: How to get the total number of items in an array

Sean_Davey — Wed, 22 Jul 2020 17:46:51 GMT

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

Re: How to get the total number of items in an array

Morelz — Fri, 24 Jul 2020 09:50:53 GMT

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