Custom search queries not showing in model view

[mrblack12]

Hi,

I'm constructing a number of model views, based on search queries I have built and saved as My Searches. It looks as though the 'Properties' window of a (search) model view does not show all the queries I've stored under My Searches, in the 'Search' dropdown list (just some of them). When I go to the 'Manage views' window however, the searches are displayed in the 'Searches' dropdown. And when I select one and run it, it performs the search correctly.

But when I close the 'Manage views' window and return to the 'Properties' window again, the selected search is still not showing in the 'Search' dropdown list. This is bugging the hell out of me : is it really a (known) bug or am I doing something wrong?

Any nsights on this would be greatly appreciated!

Rick

[natvig]

Hi Rick,

If you are trying to build model views from SQL-searches, I think you need to include the following two columns in your search:

Code: [Select]

SELECT req.ea_guid AS CLASSGUID, req.Object_Type AS CLASSTYPE, ...
FROM ...

The reason is that the model view list items have icons representing the object type found in the search and since the list items have a context menu which allows you to find the listing in the project browser etc.

/Hans

[Geert Bellekens]

To add to what Hans said, the 'AS' keyword needs to be UPPERCASE for the searches to be used in model views.

Geert