Here is XML I have:
Expand|Select|Wrap|Line Numbers
- <CustRef>
- <Contract>
- <ContractId>1</ContractId>
- <SumItem>
- <SumItemResult>
- <AggSetSumItem>
- <Days>1</Days>
- <Service>TT</Service>
- </AggSetSumItem>
- <Charge>
- <Amount>40.00</Amount>
- </Charge>
- </SumItemResult>
- </SumItem>
- <ContractId>1</ContractId>
- <SumItem>
- <SumItemResult>
- <AggSetSumItem>
- <Days>1</Days>
- <Service>TE</Service>
- </AggSetSumItem>
- <Charge>
- <Amount>240.00</Amount>
- </Charge>
- </SumItemResult>
- </SumItem>
- <ContractId>1</ContractId>
- <SumItem>
- <SumItemResult>
- <AggSetSumItem>
- <Service>TT</Service>
- </AggSetSumItem>
- <Charge>
- <Amount>880.00</Amount>
- </Charge>
- </SumItemResult>
- </SumItem>
- </Contract>
- <Contract>
- <ContractId>2</ContractId>
- <SumItem>
- <SumItemResult>
- <AggSetSumItem>
- <Days>1</Days>
- <Service>TT</Service>
- </AggSetSumItem>
- <Charge>
- <Amount>0.50</Amount>
- </Charge>
- </SumItemResult>
- </SumItem>
- <ContractId>2</ContractId>
- <SumItem>
- <SumItemResult>
- <AggSetSumItem>
- <Days>1</Days>
- <Service>TT</Service>
- </AggSetSumItem>
- <Charge>
- <Amount>350.20</Amount>
- </Charge>
- </SumItemResult>
- </SumItem>
- <ContractId>2</ContractId>
- <SumItem>
- <SumItemResult>
- <AggSetSumItem>
- <Service>TZ</Service>
- </AggSetSumItem>
- <Charge>
- <Amount>880.00</Amount>
- </Charge>
- </SumItemResult>
- </SumItem>
- </Contract>
- </CustRef>
1 40
2 400
Using Muenchian method, I can sum the <Amount> for every <ContractId>, but am can't select only these <SumItem> for which <Service> is equal to 'TT' and <Days> is greater than 0.
Any help is appreciated.
10x in advance.
Plamen