Skip to Content
author's profile photo Former Member
Former Member

Intersection between three queries.

Hi All,

i am stuck with a problem where i have data coming from three classes from the same universe.

Three Classes are

1. Member

2. Medical

3. Pharmacy

Here all the Data that i have to show in the report comes from Member class. All three classes have object MemberNumber and incurred dates.

I have to show MemberNumber of Member class that are not in MemberNumber of Medical and Pharmacy class.

basically we can say MemberNumber(Member) Not In MemberNumber (Medical, Pharmacy) based on incurred dates

i am wondering how to do this. Please suggest

Thank You

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 13, 2012 at 04:59 PM

    I would suggest to solve this at query level and try first to use the combine query feature inside query panel. With most probably:

    1. Member being Combined Query 1

    2. Medical Combined Query 2

    3. Pharmacy Combined Query 3

    The button is at the very top of your query panel. Depending on the logical meaning of "and" in "MemberNumber of Medical and Pharmacy" there must be an Intersection or an Union between Query 2 and Query 3. You need to drag your queries on the right hand side to get them at an lower level and to click on union to get intersection or minus:

    If you cannot get the result by only combining the queries like I suggested, there is an operand type which helps getting your results it is called result from another query:


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Michael ,

      You are right i tried it and its working. But again i have one more problem. i have to use a prompt Incurred Date for Member, and Service Date for Pharmacy and Medical.

      and as i know in combined query Data Type should be same.

      Here Incurred Date have different data type and Service Date have different data type, So i am getting error.

      What do you suggest in this case?

      Thank You

  • Posted on Nov 12, 2012 at 08:27 AM

    Hi Malik,

    You can do this in backend query/Universe (MemberNumber(Member) Not In MemberNumber (Medical, Pharmacy)). I think we can't do this filter in report level.

    Thanks

    Suresh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.