Is there possible to filter table data by using select from other table ?
It's mean I can filter data in table where conditions like this:
Filter Cause on table1:
TABLE1_ID IN (SELECT TABLE2_ID FROM TABLE2 WHERE ORGID = 100)
Regards,
Tomek
Not at the moment, I'm
Not at the moment, I'm afraid. The filter clause is the end of a where clause, so you can test a filter by doing
SELECT * FROM <table> WHERE <filter clause>I'm contemplating better filtering and better conflict resolution for the 2.3.1 release, but nothing is set in stone yet.
Brian
It occurred to me after I
It occurred to me after I wrote this, but I've never tried it, that it might actually work like you said. Have you tried this? Just format it as it would go after a where clause and let me know what happens! It probably should work, as the filter clause is just and'd onto the end of the sql statement that does the select to create the xml file for sync.
Brian