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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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