in ISIS/Base it's possible to export search result into a local database. The result is a datbase file that contains all forms that were in the original database, but a subset of the data.
Is there a way to do this in IJC? Or can we do something similar using shared projects/lists?
No, there is no equivalent functionality in IJC at the moment, but we do plan to support this sort of thing. We want to be able to support migration of data from oracle/mysql to a local database, and vice versa. For now the best option is to export the data and import it into other database. The forms can be transferred by copy and paste. But this is certainly not as simple as we would like.