none
Set criteria RRS feed

  • Question

  • 2 object types - user and sponsorship. Each user has a sponsor and a sponsorship.

    I am trying to create a set of those sponsorships, the sponsor of which has an active sponsorship (future termination date).

    I have the first set as

    Now I am trying to create the set that I want as below:

    But this one is not producing correct result. I am getting some sponsorships in the set which have inactive sponsor(sponsorship of the sponsor expired).

    Any help please?


    • Edited by _Sourav_ Friday, October 28, 2016 4:32 PM
    Friday, October 28, 2016 4:27 PM

All replies

  • Some clarification,

    Sponsor and Sponsorship are not objects by attributes of a user? True/False?

    So if sponsor is set to true or false, then the first set "All users with an active sponsorship" is working, right?

    Then, what is the purpose of the second set?

    Can you elaborate a little, please.


    Nosh Mernacaj, Identity Management Specialist


    Friday, October 28, 2016 4:40 PM
  • Sponsor is reference variable and bound with a sponsorship object.

    The first set is working correctly.

    The first set returns the users while I want the set of sponsorships. More specifically, I want the set of sponsorships having active sponsors.

    Friday, October 28, 2016 5:00 PM
  • So I am not getting the full picture still. What are sponsor and sponsorships, attributes of user or custom objects?   I am not seeing the correction clearly.


    Nosh Mernacaj, Identity Management Specialist

    Friday, October 28, 2016 5:18 PM
  • Sponsorship is a custom object and sponsor is one of it's attributes.
    Friday, October 28, 2016 5:39 PM
  • In the first set you have all users whose sponsor =TRUE. This is a Boolean not Reference. 

    In the second set you are trying to say all Sponsorship members in the set of users.  I don't see how you are relating the 2.  You are saying all "Sponsorship" instances who are in the set of Users. 


    Nosh Mernacaj, Identity Management Specialist

    Friday, October 28, 2016 7:48 PM
  • I must be wrong somewhere, but this is what I meant to do:

    In the first set, checking the Boolean attribute, I am getting all the active users, which is Reference and some of those users are sponsors/managers.

    In the second set, I am trying to get all Sponsorships that has a Sponsor (Reference) who belongs to the first set.

    In another words, I am trying to say:

    Select all Sponsorship where Sponsorship.Sponsor IN First_Set.

    • Edited by _Sourav_ Friday, October 28, 2016 8:11 PM
    Friday, October 28, 2016 8:01 PM
  • I must be wrong somewhere, but this is what I meant to do:

    --Definitely

    In the first set, checking the Boolean attribute, I am getting all the active users, which is Reference and some of those users are sponsors/managers.

    --What is the reference here?  It is either a Boolean or reference, not both. So which one is it?

    In the second set, I am trying to get all Sponsorships that has a Sponsor (Reference) who belongs to the first set.

    --Sorry but this makes no sense to the ones who are not familiar with your solution. 

    In another words, I am trying to say:

    Select all Sponsorship where Sponsorship.Sponsor IN First_Set.

    -- Fine but you have not told us what ties Sponsorship and User objects.  To use your line of reasoning, what is the foreign key?


    Nosh Mernacaj, Identity Management Specialist

    Friday, October 28, 2016 11:26 PM