Model Search - #BRANCH# bug

[Paolo F Cantoni]

SELECT O.ea_guid AS CLASSGUID, O.Name, O.StereoType, O.Status, O.Author, O.ModifiedDate, O.CreatedDate
FROM (t_object AS O INNER JOIN t_package AS P ON O.Package_ID = P.Package_ID)
WHERE (P.Package_ID=#Package#) AND (O.Object_Type<>'Text' AND O.Object_Type<>'Package')
ORDER BY O.Name

Finds the items in a package,. 

If I replace #Package# with #Branch# (and there is more than one level of package), I get an syntax error error at ','.  I suspect the macro conversion is failing and the comma separated list is malformed.

Reported,
Paolo

[OpenIT Solutions]

Use have you tried '#Branch' as its a comma separated list ?

[qwerty]

The syntax for a comma separated list is WHIERE (P.Package_ID IN (#Branch#)) AND ...

q.

[Paolo F Cantoni]

The syntax for a comma separated list is WHIERE (P.Package_ID IN (#Branch#)) AND ...

q.

When all else fails, get someone else (q) to RTFM...   

However, when I set the correct syntax I get a peculiar error

"Error in date in query expression 'Package_ID IN (#BRANCH#)'"

It turns out the name of the Macro is CASE SENSITIVE!  Exactly as  shown in the Help: "Branch"

Paolo

[qwerty]

I guess this case sensitivity should be reported as bug. (Has the "capitalized AS"-bug ever been reported?)

q.