Query Prelim items from Agile DB
is it possible to query perlim items from Agile DB, it seems to me that if the item is in prelim (it does not have any revision) it does not come up in queries. is this correct? if so, is it by design?
Yes, you can, but I would really REALLY caution against modifying anything directly in the database.
Every item has the introductory rev record, so you cannot look for where the item has no records in the REV table. Instead look for items where REV.CHANGE > 0 :
select id, item_number from item i where not exists (select null from rev where item = i.id and change > 0);
If you really want to look at any item that only has the Introductory Rev *or* is only assigned the “Preliminary” status, then you need to get a bit deeper into what ID is used by any lifecycle phase value that you take to mean “Preliminary” (the default value is ID = 976).