Impossible to build views across multiple modules

We have been testing ZOHO ONE and were quite impressed with the functions. Generally it would offer all feature we need. Even if not really integrated with other modules (see e.g. CRM and Campaigns) we think ZOHHO is on a good way.

What we can´t understand (and which is a complete show stopper for us) that it isn´t possible to retrieve data across various modules or even related lists within the CRM.
It is not possible to select all Contacts, with a sales order greater 10,000 AND with no open tickets from ZOHO Desk. You can define new modules and build relations via lookup fields. So far so good. But it´s impossible to query this data to push them to ZOHO campaigns. We can build reports but not for operational usage in campaigns.
In other CRM system (Dynamics, salesforce) you can of course do an advanced search over various entities and use the result to perform some action.

So, we are out for the moment and waiting until ZOHO is offering cross entity functionality.