| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Combining WHERE clause in MQSC command |
« View previous topic :: View next topic » |
| Author |
Message
|
| hughson |
 Posted: Mon Nov 05, 2018 8:42 pm Post subject: |
 |
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
| bruce2359 wrote: |
The equivalent of MQSC WHERE is filters in the MQExplorer and MQCONSOLE.
I don't have access to an image right now, so I can't valudate that filters work with QSTATUS, but they certainly works with Queues, queue managers, and other objects.
MQExplorer filters are discussed in IBM official curriculum. |
Yes indeed, "Filters" is indeed the MQ Explorer name for "the WHERE clause".
I can confirm that MQ Explorer filters work with QSTATUS just as the MQSC WHERE clause does (they are the same thing after all, one in PCF and one in MQSC spelling). I just brought up an MQ Explorer to double check.
You said that MQ Explorer filters could do ANDs and ORs though (like the OP wanted) - that's what I was asking you to clarify. I don't believe that is true. Maybe that wasn't what you were trying to say?
Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
 |
| krypton |
| Posted: Tue Nov 06, 2018 8:05 am Post subject: |
|
|
Disciple
Joined: 14 Mar 2010
Posts: 186
|
Hi Morgan,
I just checked MQ Explorer again (V and I can confirm that the FILTERS doesn't work with QSTATUS parameters( like IPPROCS, OPPROCS, APPTAG, LEGTTIME and so on..)
it only works with Queue attributes like (BOThreshold, Usage , get /put enabled etc etc).
If you have find that it works with Qstatus, let me know where I can look for it.
| hughson wrote: |
| bruce2359 wrote: |
The equivalent of MQSC WHERE is filters in the MQExplorer and MQCONSOLE.
I don't have access to an image right now, so I can't valudate that filters work with QSTATUS, but they certainly works with Queues, queue managers, and other objects.
MQExplorer filters are discussed in IBM official curriculum. |
Yes indeed, "Filters" is indeed the MQ Explorer name for "the WHERE clause".
I can confirm that MQ Explorer filters work with QSTATUS just as the MQSC WHERE clause does (they are the same thing after all, one in PCF and one in MQSC spelling). I just brought up an MQ Explorer to double check.
You said that MQ Explorer filters could do ANDs and ORs though (like the OP wanted) - that's what I was asking you to clarify. I don't believe that is true. Maybe that wasn't what you were trying to say?
Cheers,
Morag |
_________________
Dreams are not something which you watch when you are asleep,it is something which doesn't let you sleep. |
|
| Back to top |
|
|
| hughson |
| Posted: Tue Nov 06, 2018 1:01 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
| krypton wrote: |
| If you have find that it works with Qstatus, let me know where I can look for it. |
- Open up a Queue Status list
Right click on the Queues folder in the Navigator pane and choose Status... from the context menu
- Open up the filter to edit
Just above the list of queues shown in the Queue Status list, you should see "Filter: Standard for Queue Status". At the far right of that text is a down arrow. Click on that down arrow and select, "Edit Current Filter..."
- Add the attribute you wish to filter on
Click the check box next to "-AND", press the "Select..." button and choose the attribute you wish, e.g. "Open input count", and set the rest of the expression. Click on OK when done.
If this isn't clear, please let me know which part doesn't work.
P.S. Please note that not all the attributes appear to be available as a filter in this way - i.e. the Put/Get Date/Time attributes don't appear in the list which was where this thread began, and please also note that you cannot add more than one filter with an AND or OR between it, regardless of what @bruce2359 says. Also, it would appear you cannot filter on the handles, only on the queue status. MQSC can give you more than MQ Explorer in this case.
Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
|
| krypton |
| Posted: Tue Nov 06, 2018 1:19 pm Post subject: |
|
|
Disciple
Joined: 14 Mar 2010
Posts: 186
|
Found it, thank you. earlier I was not looking at the navigator pane..
| hughson wrote: |
| krypton wrote: |
| If you have find that it works with Qstatus, let me know where I can look for it. |
- Open up a Queue Status list
Right click on the Queues folder in the Navigator pane and choose Status... from the context menu
- Open up the filter to edit
Just above the list of queues shown in the Queue Status list, you should see "Filter: Standard for Queue Status". At the far right of that text is a down arrow. Click on that down arrow and select, "Edit Current Filter..."
- Add the attribute you wish to filter on
Click the check box next to "-AND", press the "Select..." button and choose the attribute you wish, e.g. "Open input count", and set the rest of the expression. Click on OK when done.
If this isn't clear, please let me know which part doesn't work.
P.S. Please note that not all the attributes appear to be available as a filter in this way - i.e. the Put/Get Date/Time attributes don't appear in the list which was where this thread began, and please also note that you cannot add more than one filter with an AND or OR between it, regardless of what @bruce2359 says. Also, it would appear you cannot filter on the handles, only on the queue status. MQSC can give you more than MQ Explorer in this case.
Cheers,
Morag |
_________________
Dreams are not something which you watch when you are asleep,it is something which doesn't let you sleep. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Tue Nov 13, 2018 7:09 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9472
Location: US: west coast, almost. Otherwise, enroute.
|
I stand corrected. I finally have a v9 image, and no filter support in the explorer for qstatus. must have been optimism or meds.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| hughson |
| Posted: Tue Nov 13, 2018 2:08 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
| bruce2359 wrote: |
| I stand corrected. I finally have a v9 image, and no filter support in the explorer for qstatus. must have been optimism or meds. |
Please see my previous post in this thread. There IS filtering for QSTATUS in MQ Explorer, but there is no AND/OR which was the original question.
Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
