External object question

ckacoroski · Post by **ckacoroski** » Thu Jun 07, 2007 7:40 pm

I have some data in an external database so they show up as external objects (not sure if this is the right term). As stated in your docs I cannot do:

Find ExternalObject where exists InternalObject where (InternalObject.Id = ExternalObjectId)

However, this seems to work and I am wondering if it is suppose to work or not (e.g. I do not want to depend on behavior that may go away in the future).

Process1:
Find ExternalObject where somecondition
DoProcess2

Process2: (tasks an external object as input)
Find InternalObject where InternalObject.id = ExternalObject.id
do more stuff here...

Thanks in advance for your help

aware_support · Post by **aware_support** » Fri Jun 08, 2007 5:04 am

The sub-query on an internal object embedded in the query on the external object should work, because a sub-query is "isolated" within the main query.