MQSeries.net :: View topic - How to use groupby in a field

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » General Discussion » How to use groupby in a field

How to use groupby in a field

« View previous topic :: View next topic »

Author

Message

Kinjal

Posted: Wed May 25, 2016 4:00 am Post subject: How to use groupby in a field

Newbie

Joined: 24 May 2016
Posts: 1

I want to group by text in a exact field. I'm fundamentally examining a message content field called occurrence. In this occurrence field I am examining for exact error Codes but I want to group by the error codes in the result pages. I cannot to do an removal because the message content is in xml setup and I can't look to extract the exact tag. How to Handle this?
I want to group the results by unique values in my XML tag.?
Help me to resolve this?

Vitor

Posted: Wed May 25, 2016 4:10 am Post subject: Re: How to use groupby in a field

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Kinjal wrote:

I want to group by text in a exact field.

All fields are exact. Unless you're using AI based fuzzy logic. What makes you call this field "exact"?

Kinjal wrote:

I'm fundamentally examining a message content field called occurrence.

I assume you don't mean you're examining the field for it's fundamental sub-atomic structure. From this:

Kinjal wrote:

the message content is in xml setup

I infer that you're taking about a single XML element within a document. Can you confirm this inference?

Kinjal wrote:

In this occurrence field I am examining for exact error Codes but I want to group by the error codes in the result pages.

So are you looking through a list of codes contained in this fundamentally exact field (in some kind of text based list) or an iteration of error codes?

Kinjal wrote:

I cannot to do an removal because the message content is in xml setup and I can't look to extract the exact tag.

This makes no sense. Of course you can extract an "exact" tag from an XML document, even if the location of the tag is uncertain at design time

Kinjal wrote:

I want to group the results by unique values in my XML tag.?

So the output is a DISTINCT list of reason codes culled from the input?

Kinjal wrote:

How to Handle this?

With code. You're describing a fairly straightforward traverse and extract from an XML document.

Kinjal wrote:

Help me to resolve this?

Help us by telling us what you've already tried and why it didn't work for you, so we don't suggest the same solution again.

You should also expand on your problem by answering my points above.
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » General Discussion » How to use groupby in a field

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP