Re: Vertical inheritance with relationships

2012-10-09 Thread Andrus Adamchik
Hi Ramiro, based on the model that you sent me earlier, I was able to reproduce another error and identify its cause: https://issues.apache.org/jira/browse/CAY-1746 So slowly getting there... > Maybe I am just doing everything the wrong way, butI am starting to think > that vertical inheritan

Re: How to fetch the Distinct rows based on an attribute.

2012-10-09 Thread Andrus Adamchik
I am going to close the CAY-1730 Jira. Indeed the right place to get help with Cayenne is here on this list (vs. reporting a bug, for which Jira is of course appropriate). So regarding your specific query: > SELECT * FROM t_task_assignment_detail t0 where t0.user_id=112 and exists > (select '

RE: How to fetch the Distinct rows based on an attribute.

2012-10-09 Thread Durchholz, Joachim
Can't help with your distinctness problem since I do not understand what you're trying to achieve. Don't know enough about Cayenne to solve your query problem, but that question definitely belongs into this mailing list, where you're talking to people who're using Cayenne. In JIRA, you're talki

RE: How to fetch the Distinct rows based on an attribute.

2012-10-09 Thread Sampath Uppula
Hi, Thanks for the response. But this is just an example. I have many scenarios, where I have to fetch the distinct rows based on a field (attribute). Can you also please answer the issue# CAY-1730 (https://issues.apache.org/jira/browse/CAY-1730)? Thanks, Sampath Uppula -Original Message-

RE: How to fetch the Distinct rows based on an attribute.

2012-10-09 Thread Durchholz, Joachim
What you want to do does not make sense. If there are rows that have the same user_id but different fields elsewhere, which of these rows should be returned? From: Sampath Uppula [mailto:su0064...@techmahindra.com] Sent: Tuesday, October 09, 2012 10:00 AM To: us