• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Searching for non-empty toMany relationships...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Searching for non-empty toMany relationships...

  • Subject: Searching for non-empty toMany relationships...
  • From: Louis Demers <email@hidden>
  • Date: Wed, 17 Jul 2013 14:22:10 -0400
Hi,

I'm trying to create an EOQualifer to filter and array where I have only the EOs that have a toMany relationship not empty. I tried many things, including a thread "qualifier to check for empty toMany" of May 11, 2011 without success. My code was 

ERXQ.isNotNull(Transaction.COMPONENT_TRANSACTIONS_KEY + "." + Transaction.PK_KEY)

I then tried what I thought was the most promising  ERXQ.hasAtLeast

ERXQ.hasAtLeast(Transaction.COMPONENT_TRANSACTIONS_KEY, null, 1)

componentTransactions being my modelled toMany relationship. The doc says that the array can be null.



but I get  the following exception at run-time which surprised me a bit. I run latest Wonder (integration) and PostgreSQL as my database. Inspecting the code seems to poin to having a badly defined joins which brings me in my ignorance zone about inner/outer/upper/sideway joins....
Pointers to a tutorial on those would be appreciated.


Even a solution based upon straight SQL would make me happy 8-).


Application:Alexandria
Error:java.lang.RuntimeException: not implemented!!
Reason:not implemented!!
Stack trace:
FileLine#MethodPackage
ERXToManyQualifier.java234sqlStringForSQLExpressioner.extensions.eof.qualifiers
EOQualifierSQLGeneration.java165_sqlStringForSQLExpressioncom.webobjects.eoaccess
EOSQLExpression.java1528sqlStringForArrayOfQualifierscom.webobjects.eoaccess
EOSQLExpression.java1560sqlStringForConjoinedQualifierscom.webobjects.eoaccess
EOQualifierSQLGeneration.java541sqlStringForSQLExpressioncom.webobjects.eoaccess
EOQualifierSQLGeneration.java165_sqlStringForSQLExpressioncom.webobjects.eoaccess
EOSQLExpression.java1528sqlStringForArrayOfQualifierscom.webobjects.eoaccess
EOSQLExpression.java1574sqlStringForDisjoinedQualifierscom.webobjects.eoaccess
EOQualifierSQLGeneration.java578sqlStringForSQLExpressioncom.webobjects.eoaccess
EOQualifierSQLGeneration.java165_sqlStringForSQLExpressioncom.webobjects.eoaccess
EOSQLExpression.java1528sqlStringForArrayOfQualifierscom.webobjects.eoaccess
EOSQLExpression.java1560sqlStringForConjoinedQualifierscom.webobjects.eoaccess
EOQualifierSQLGeneration.java541sqlStringForSQLExpressioncom.webobjects.eoaccess
EOQualifierSQLGeneration.java165_sqlStringForSQLExpressioncom.webobjects.eoaccess
EOSQLExpression.java997prepareSelectExpressionWithAttributescom.webobjects.eoaccess
JDBCExpression.java146prepareSelectExpressionWithAttributescom.webobjects.jdbcadaptor
PostgresqlExpression.java770prepareSelectExpressionWithAttributescom.webobjects.jdbcadaptor
EOSQLExpressionFactory.java225selectStatementForAttributescom.webobjects.eoaccess
JDBCChannel.java213selectAttributescom.webobjects.jdbcadaptor
EODatabaseChannel.java897_selectWithFetchSpecificationEditingContextcom.webobjects.eoaccess
EODatabaseChannel.java234selectObjectsWithFetchSpecificationcom.webobjects.eoaccess
EODatabaseContext.java3055_objectsWithFetchSpecificationEditingContextcom.webobjects.eoaccess
EODatabaseContext.java3195objectsWithFetchSpecificationcom.webobjects.eoaccess
EOObjectStoreCoordinator.java488objectsWithFetchSpecificationcom.webobjects.eocontrol
EOEditingContext.java4069objectsWithFetchSpecificationcom.webobjects.eocontrol
ERXEC.java1308objectsWithFetchSpecificationer.extensions.eof
EOEditingContext.java4444objectsWithFetchSpecificationcom.webobjects.eocontrol
_Transaction.java604fetchTransactionscom.obzerv.eo
Transaction.java112wipTransactionscom.obzerv.eo
PeriodFinancialReportTask.java91callcom.obzerv.task
PeriodFinancialReportTask.java1callcom.obzerv.task
FutureTask.java303innerRunjava.util.concurrent
FutureTask.java138runjava.util.concurrent
ThreadPoolExecutor.java895runTaskjava.util.concurrent
ThreadPoolExecutor.java918runjava.util.concurrent
Thread.java680runjava.lang
NA : Non applicable, JIT activated




Louis Demers eng.
www.obzerv.com

 

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: Searching for non-empty toMany relationships...
      • From: Chuck Hill <email@hidden>
  • Prev by Date: Re: Same value with different precision causes database updates
  • Next by Date: Re: Searching for non-empty toMany relationships...
  • Previous by thread: Re: Same value with different precision causes database updates
  • Next by thread: Re: Searching for non-empty toMany relationships...
  • Index(es):
    • Date
    • Thread