Model Views Problem

[philchudley]

Hi All

I am attempting to create a Search Folder using Model Views, but when I attempt to set the search, the drop list of searches only shows those in Built-in, none in My Searches

The search I have created (its in SQL) works correctly, and is visible in the Search View.

Oddly, when clicking the ... button adjacent to the list of searches, I can see all My Searches ...

The same behaviour in EA v 10, EA v 11.1 and EA v12 RC2

The end result is I cannot assign a custom search to any search folder in Model View

Any advice?

Cheers

Phil

[qwerty]

The list shows only those that have ea_guid AS CLASSGUID as the first column.

q.

[philchudley]

Thanks for that, I do indeed have the CLASSGUID, but I have now managed to get it to work.

I simplified the query so after the mandatory fields CLASSGUID and CLASSTYPE, I have only reported fields from t_object.

If I try to report fields from other tables, for example t_package and use joins between t_object and t_package it does not seem to work for Model Views, but does run OK in the Query View

Thanks for your reply

Phil

[philchudley]

Found the issue!

Queries such as
[highlight]
SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE [/highlight]

work

but queries such as

[highlight]SELECT t_object.ea_guid as CLASSGUID, t_object.Object_Type as CLASSTYPE[/highlight]

don't work with Model Views, but do for Model Searches!

Yes the word as is case sensitive

To be fair the user guide example does have the word AS in upper case, but does not mention it MUST be upper case.

Cheers

Phil

[qwerty]

Ah. The [highlight]AS[/highlight] is different. Hard to find But not an unknown behavior with EA.

q.

[Geert Bellekens]

Yep, Yep, Yep, now you mention it it all comes back. (must have suppressed it I guess ) I had a similar issue with queries where I have to use 'AS' iso 'as'

Geert