Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
InterSystems: MV Community
Home
About this group
Apply for group membership
Within a field group multiple values.
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Carlos F Gonzalez  
View profile  
 More options Feb 7, 8:54 am
From: Carlos F Gonzalez <cgonzalez.g...@gmail.com>
Date: Tue, 7 Feb 2012 05:54:14 -0800 (PST)
Local: Tues, Feb 7 2012 8:54 am
Subject: Within a field group multiple values.
Print | Individual message | Show original | Report this message | Find messages by this author
Hello, my name is Carlos and I have the following problem.

I have a query that returns the following records:

#       ID      MiddleAndLastName       TestAbreviation SampleID

1       29802774        Gonzalez                                  GLU         1
2       7       Torres                            GLU         4
3       7       Torres                            URAT        4

But I need to group it like this:

#       ID      MiddleAndLastName       TestAbreviation SampleID

1       29802774        Gonzalez                                   GLU        1
2       7       Torres                        GLU  URAT       4

Is there a query that does this return?

Sorry for my English, I'm a beginner in Intersystem Cache.

Thank you very much everyone!


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rich Taylor  
View profile  
 More options Feb 7, 9:46 am
From: Rich Taylor <Rich.Tay...@intersystems.com>
Date: Tue, 7 Feb 2012 14:46:58 +0000
Local: Tues, Feb 7 2012 9:46 am
Subject: RE: [InterSystems-MV] Within a field group multiple values.
Print | Individual message | Show original | Report this message | Find messages by this author
Carlos,

What language are you writing this query in?   SQL, CMQL (access)?

If the later, meaning you are coming from a Multivalue environment, can you give use the data dictionary for this file?  It would also be helpful to see the data so if you ED filename 3 and take a screen paint of the relevant area(s) of the data.

Richard S Taylor
Sales Engineer
InterSystems Corporation
Office: 443-340-8614
FAX: 440-815-5805


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jason Warner  
View profile  
 More options Feb 7, 12:08 pm
From: Jason Warner <jas...@brashers.com>
Date: Tue, 07 Feb 2012 10:08:54 -0700
Local: Tues, Feb 7 2012 12:08 pm
Subject: Re: [InterSystems-MV] Re: Within a field group multiple values.
Print | Individual message | Show original | Report this message | Find messages by this author
Based on http://docs.intersystems.com/cache20111/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_list, it looks like you want to re-write your query like:

SELECT rOrders -> RegisterDate ,
    rOrders -> ID1 ,
    rOrders -> rPatients -> PatientID1 ,
    rOrders -> rPatients -> MiddleAndLastName ,
    LIST(DISTINCT rTests -> TestAbbreviation)
FROM tOrderTests
WHERE tOrderTests . Status = 0

Jason

On Tuesday, February 07, 2012 8:27:24 AM, Carlos F Gonzalez wrote:

The query I use is:

SELECT rOrders -> RegisterDate ,
rOrders -> ID1 ,
rOrders -> rPatients -> PatientID1 ,
rOrders -> rPatients -> MiddleAndLastName ,
rTests -> TestAbbreviation
FROM tOrderTests
WHERE tOrderTests . Status = 0

I place this query in a tablePane in the SQL property. In Intersystem
Studio.

I send you a printscreen, by mail.

Unfortunately the database I can not send for terms of Confidentiality

Thank you very much everyone!




On 7 feb, 11:46, Rich Taylor<Rich.Tay...@intersystems.com> wrote:

Carlos,

What language are you writing this query in? SQL, CMQL (access)?

If the later, meaning you are coming from a Multivalue environment, can you give use the data dictionary for this file? It would also be helpful to see the data so if you ED filename 3 and take a screen paint of the relevant area(s) of the data.

Richard S Taylor
Sales Engineer
InterSystems Corporation
Office: 443-340-8614
FAX: 440-815-5805



-----Original Message-----
From: intersystems-mv@googlegroups.com [mailto:intersystems-mv@googlegroups.com] On Behalf Of Carlos F Gonzalez
Sent: Tuesday, February 07, 2012 8:54 AM
To: InterSystems: MV Community
Subject: [InterSystems-MV] Within a field group multiple values.

Hello, my name is Carlos and I have the following problem.

I have a query that returns the following records:

# ID MiddleAndLastName TestAbreviation SampleID

1 29802774 Gonzalez GLU 1
2 7 Torres GLU 4
3 7 Torres URAT 4

But I need to group it like this:

# ID MiddleAndLastName TestAbreviation SampleID

1 29802774 Gonzalez GLU 1
2 7 Torres GLU URAT 4

Is there a query that does this return?

Sorry for my English, I'm a beginner in Intersystem Cache.

Thank you very much everyone!

--
You received this message because you are subscribed to the Google Groups "InterSystems: MV Community" group.
To post to this group, send email to CacheMV@googlegroups.com
To unsubscribe from this group, send email to CacheMV-unsubscribe@googlegroups.com
For more options, visit this group athttp://groups.google.com/group/CacheMV?hl=en- Ocultar texto de la cita -

- Mostrar texto de la cita -


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rich Taylor  
View profile  
 More options Feb 7, 12:51 pm
From: Rich Taylor <Rich.Tay...@intersystems.com>
Date: Tue, 7 Feb 2012 17:51:35 +0000
Local: Tues, Feb 7 2012 12:51 pm
Subject: RE: [InterSystems-MV] Re: Within a field group multiple values.
Print | Individual message | Show original | Report this message | Find messages by this author

Carlos,

Jason beat me to the punch here.   This does look like what you are trying to achieve.    Also, for future reference, InterSystems has  a number on online communities.  There is a general Caché community and one focused on ZEN.  You will probably get better response by including these in your postings also.  This group in particular is focused on the Multivalue aspects of Caché hence my first request to clarify the type of query you were doing.  Here are some links to those other groups

http://groups.google.com/group/intersystems-public-cache?pli=1

http://groups.google.com/group/InterSystems-ZEN

Richard S Taylor
Sales Engineer
InterSystems Corporation
Office: 443-340-8614
FAX: 440-815-5805
[image003]

From: intersystems-mv@googlegroups.com [mailto:intersystems-mv@googlegroups.com] On Behalf Of Jason Warner
Sent: Tuesday, February 07, 2012 12:10 PM
To: intersystems-mv@googlegroups.com
Subject: Re: [InterSystems-MV] Re: Within a field group multiple values.

Based on http://docs.intersystems.com/cache20111/csp/docbook/DocBook.UI.Page.c..., it looks like you want to re-write your query like:

SELECT rOrders -> RegisterDate ,
    rOrders -> ID1 ,
    rOrders -> rPatients -> PatientID1 ,
    rOrders -> rPatients -> MiddleAndLastName ,
    LIST(DISTINCT rTests -> TestAbbreviation)
FROM tOrderTests
WHERE tOrderTests . Status = 0

Jason

On Tuesday, February 07, 2012 8:27:24 AM, Carlos F Gonzalez wrote:

The query I use is:

SELECT rOrders -> RegisterDate ,
rOrders -> ID1 ,
rOrders -> rPatients -> PatientID1 ,
rOrders -> rPatients -> MiddleAndLastName ,
rTests -> TestAbbreviation
FROM tOrderTests
WHERE tOrderTests . Status = 0

I place this query in a tablePane in the SQL property. In Intersystem
Studio.

I send you a printscreen, by mail.

Unfortunately the database I can not send for terms of Confidentiality

Thank you very much everyone!

On 7 feb, 11:46, Rich Taylor<Rich.Tay...@intersystems.com><mailto:Rich.Tay...@intersystems.com> wrote:

Carlos,

What language are you writing this query in? SQL, CMQL (access)?

If the later, meaning you are coming from a Multivalue environment, can you give use the data dictionary for this file? It would also be helpful to see the data so if you ED filename 3 and take a screen paint of the relevant area(s) of the data.

Richard S Taylor
Sales Engineer
InterSystems Corporation
Office: 443-340-8614
FAX: 440-815-5805

  image001.jpg
4K Download

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Carlos F Gonzalez  
View profile  
 More options Feb 7, 1:08 pm
From: Carlos F Gonzalez <cgonzalez.g...@gmail.com>
Date: Tue, 7 Feb 2012 10:08:01 -0800 (PST)
Local: Tues, Feb 7 2012 1:08 pm
Subject: Re: Within a field group multiple values.
Print | Individual message | Show original | Report this message | Find messages by this author
Well, it really helped me and I thank them.

 After Jason's response, and the link PROVIDED BY Richard, I found the
solution as follows:

SELECT rOrders -> RegisterDate ,
    rOrders -> ID1 ,
    rOrders -> rPatients -> PatientID1 ,
    rOrders -> rPatients -> MiddleAndLastName ,

    LIST(DISTINCT rTests -> TestAbbreviation %FOREACH(rOrders ->
ID1 ))

FROM tOrderTests
WHERE tOrderTests . Status = 0

Thank you very much for everything!!

On 7 feb, 14:51, Rich Taylor <Rich.Tay...@intersystems.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2012 Google