SQL Help

[Maggie]

Hello
I am no expert in SQL Queries but find the need to write a SQL Search and would appreciate some help

I want to select all elements within a specified package with type 'Feature'

Here is my first cut

Code: [Select]

SELECT t_object.Name, t_object.Status, t_object.Author FROM t_object WHERE t_object.Object_Type = 'Feature'

But this selects all model elements with type Feature

How can I restrict it to a given package

Thanks

Maggie

[qwerty]

Do you mean a SQL search in automation (raw) or one for user searches (cooked)?

a)

Code: [Select]

SELECT t_object.Name, t_object.Status, t_object.Author FROM t_object
WHERE t_object.Object_Type = 'Feature' AND Package_ID = <id>where you have to supply the relevant package id in <id>

b)

Code: [Select]

SELECT t_object.Name, t_object.Status, t_object.Author FROM t_object
WHERE t_object.Object_Type = 'Feature' AND Package_ID = #Package#
q.

[Maggie]

Thanks Querty