RTF document based on Search with SQL fails

[Marco Schramp]

I'm trying to get a RTF report, where the set of elements is based on a search result. In order to drill down to the problem, I've gone to the simples query possible:

select o.ea_guid as CLASSGUID,
o.Object_Type as CLASSTYPE,
o.name as Name
from t_object as o

When this query runs through the search window it is ok. my entire (small) model is returned.

Then I associate the model document to the search by specifying the Searchname tagged value. When trying to generate the report, I get an error message. The log-window shows the text below:

To run a custom search you must specify ea_guid AS CLASSGUID in your select statement

I don't understand this, because the CLASSGUID is in the query.

Please suggest or ask good questions for more info to solve this. I'm lost.

Marco

[Eve]

It's case sensitive. You need 'AS' not 'as'.

[Marco Schramp]

 :-? Very unlogical, but it works....