Jump to content
Sign in to follow this  
Rob P

construct (a.k.a. the conditional relationship)

Recommended Posts

I need to create what is a union of 2 equi-joins in a single portal. Can it be done? The conditions are mutually exclusive under normal circumstances.

On one side of the relationship I can select either a type OR an id. The purpose is that when I select a type, I am creating a grouping that will be assigned an id. Once I assign an id, I can only view those records in the portal by selecting it's id.

Now I have to be able to edit that set assigned the id which could mean adding or removing records from that group. That means I have to be able to view the records from that ID AND distinctly the available records of that TYPE.

Creating a separate portal to do this will muck up the interface and it will not be as user friendly than if I do it in a single portal.

Edited by Guest
quotes don't work in Subject line

Share this post


Link to post
Share on other sites

Thank you Søren, I'll look at that and see if I can implement it. Looks like the solution though.

Share this post


Link to post
Share on other sites

Your solution effectively answer the "OR" but it does not answer the conditional. There are 3 possible lists I want.

Lets say in your list everyone is Mike, Pat or Bessie.

Some of these records have a last name.

1) I want to see all Bessie's that don't have a last name.

2) I want to see all last names that are Ford. It is understood that all Fords also have a first name of Bessie but I don't want to see any Bessies that don't have a last name.

3) I want to combine list 1 & 2 - All Bessie's that don't have a last name AND ALL Bessie Ford's.

The problem is that 1 & 2 cancel each other out for list 3.

Share this post


Link to post
Share on other sites

Ah! an XOR relation (pretty exiting), I have to poke down in my math litterature ...it has gone time for some family life, could you await until tomorrow.

Alright you can give it try yourself meanwhile:

F = ¬AxB+Ax¬B

¬ = not

x = OR

+ = AND

--sd

Share this post


Link to post
Share on other sites

Take care of the family! I'll have to proceed with a 2 portal solution but it's not as elegant or user friendly so if you have a solution I'd gladly integrate it.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.