Hi Andre Luiz,
Though there is no direct subqueries support in expressions package,
here is a solution to your problem:
http://objectstyle.org/cayenne/faq/develop.html#not-query
Andrus
On Monday, July 21, 2003, at 09:46 AM, Andr� Luiz N Sousa wrote:
> Hello, Andrus,
> �
> �
> ��� ��� I'm having some doubts about how to build a query with a
> subquery using the Cayenne.�Let's see if someone could help me.
> �
> ��� ��� Given the following scenario:
> �
> Entity:�
> ��� ��� Escotista��� ��� (DB Table: TB01_ESCOTISTA)
> ��� ��� =======
> ��� ��� ideEscotista���������� (PK) - it wasn't mapped by the Cayenne
> Modeller
> ��� ��� nomEscotista��� ��� String
> ��� ��� dthNascimento���� Date
> ������� .... (a lot of another fields...)
> ������� MembroPatrulhaArray��� ��� 'To-Many' relationship to entity
> "MembroPatrulha"
> �
> Entity:
> ��� ��� MembroPatrulha� ��� (DB Table: TB36_MEMBRO_PATRULHA)
> ��� ��� =============
> ��� ��� idePatrulhaFk35��� ��� Integer��� (PK)
> ��� ��� ideEscotistaFk01��� ��Integer��� (PK)
> ��������dthAdmissao�������������Date
> ��� ��� dthDesligamento����� Date
> ��� ��� indCargoAtual��� ��� ��� String
> ��� ��� toEscotista��� ��� ��� ���� 'To-One' relationship to entity
> "Escotista"
> �
> �
> ��� ��� Suppose that I have the "idePatrulhaFk35" value and�I'd like
> to list all the records of the "Escotista" entity that don't exist
> yet�in the "MembroPatrulha" for the given "idePatrulhaFk35" value.
> �
> ��� ��� The pure SQL would be something like this:
> ��� ��� ��� "select T01.*
> ����������������from TB01_ESCOTISTA As T01
> ��� ��� ����� where T01.IDE_ESCOTISTA not in (select
> T02.IDE_ESCOTISTA_FK01
> �����������������������������������������������������������������������
> �����������from TB36_MEMBRO_PATRULHA As T02
> �����������������������������������������������������������������������
> ��������where T02.IDE_PATRULHA_FK35 = X);"
> �
> ��� ��� The question is: How can I do that query using the Cayenne
> syntax (Expression, ExpressionFactory, etc...) ???
> �
> �
> ��� ��� Thanks for the attention,
> �
> �
> Andr� Luiz do Nascimento Sousa
> System Analist
> Bras�lia - Brazil
> �
> �
> �
> �
> �
> �
> �
> �
> �
> �
> �
> �
> ��� ��� ���
> �
> �
>
This archive was generated by hypermail 2.0.0 : Mon Jul 21 2003 - 10:28:54 EDT