Count and Find Items

Count and Find Items
 1# This script shows how to use CountItems and FindItems in the "BySQL" mode.
 2
 3ot = impact.gui.output_toolbox
 4ot.clear()
 5
 6sql = "D_NAME like 'ACME'"
 7
 8count_opts = impact.creator.count_items_options()
 9count_opts.drawing_type = ipDrawingType.dtProject
10count_opts.sql = sql
11q_count = impact.active_database.count_items(count_opts)
12ot.add("Count items: " + str(q_count))
13
14find_opts = impact.creator.find_items_options()
15find_opts.sql = sql
16find_opts.order_ascending = False
17find_opts.order_by = "D_NAME"
18find_opts.max_records = 10
19db_items = impact.active_database.find_items(find_opts)
20
21if db_items.isNone():
22    ot.add("FindItems: nothing")
23else:
24    ot.add("FindItems: " + str(db_items.count))
25    for item in db_items:
26        ot.add("Project reference: " + str(item.reference))