Book a Demo

Author Topic: Custom SQL Query - RTF on selected items  (Read 3670 times)

bartvanb

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Custom SQL Query - RTF on selected items
« on: January 14, 2009, 09:16:52 pm »
Hi,

In the 'Find In Project' window, I have wrote a custom SQL query.
I get the search results, but I can not do a RTF print on the selected items. If I run a"'Simple" search, I get the same search results back and then I can select items from the search results and do a RTF on the selected items.
Here's the SQL query:

SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object where pdata5 LIKE '%TEST%'

Is there something I forgot ? It seens that the "Simple" search that comes with EA includes some other colums from the t_object table etc...
Can someone help us out please ?
Many thanks



Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 591
  • Karma: +7/-0
    • View Profile
Re: Custom SQL Query - RTF on selected items
« Reply #1 on: January 15, 2009, 04:27:28 pm »
For build 833 - try adding t_object.Object_id to the query.  
In build 834 - you can use the RTF editor: File | Document Options | Element Filter - to set this filter.