[CONNECT C++] Translate ECQuery to Report Filter

My code can build an ECQuery that interrogates Item Type instances.  I would like to create a Report that emulates that ECQuery.  Is there any way to translate an ECQuery to a Report filter?  That is, user has queried a set of elements by filtering their Item Type properties and can see a result set of, say, highlighted elements. 

AreaAnnotator Search dialog

I expect that user would like to create a Report that lists those same element properties.  This is an analog of queries and reports in most relational databases: a report can use an SQL query as the source of its data.  Filtering is implicit.

I'm not optimistic about a positive response because the Report filter syntax is undocumented (in the Update 9..13 SDK) and obscure, so I have no idea where to begin.

Parents Reply
  • What is *Alternative Metrics*?

    Some customers create designs with annotation in two metric systems.  For example, modellers in most of the world prefer the metric system (metres, hectares) while US modellers think in Imperial/English units (feet, acres).  If a multinational shares designs between two locales that have different measuring systems, they want to see annotation and reports that show both units.

    That helps to avoid the problems of misusing a measurement, such as infamously sending a space vehicle to the wrong location.

    are you doing any unit conversion?

    Yes: that's essential!  For example, in the screenshot above, you can see column heading Area and below it units m2 and Yards2.

    are you copying values from this view or are you executing your definition at Microstation table level

    It creates a MicroStation Table in the same way that a Report creates a Table.  The table shows what's in the worksheet, including the aggregate information.  You can also write the worksheet contents as an Excel file.

     
    Regards, Jon Summers
    LA Solutions

Children
No Data