No folder scanned yet.
Questions to ask it
Open forms-metadata.sqlite in any SQL browser, or run
forms-metadata.sql into Oracle. These run as they stand —
change the name in quotes to the one you are looking for.
Numeric fields that carry a format mask
Where the mask and the data type can disagree, and where a migration
has to decide what the mask meant.
select f.file_name, i.form_block_name, i.form_item_name, i.data_type, i.format_mask
from form_items i
join form_files f on f.form_file_pk = i.form_file_fk
where i.data_type = 'Number'
and i.format_mask is not null
order by 1, 2, 3;
Blocks on a given table
What queries it, what writes it, and whether this block is allowed to.
A block with no DML target writes what it queries, which is why the
two are rolled together here.
select f.file_name, b.form_block_name,
b.query_data_source_name as queries,
coalesce(b.dml_data_target_name, b.query_data_source_name) as writes,
b.insert_allowed, b.update_allowed, b.delete_allowed
from form_blocks b
join form_files f on f.form_file_pk = b.form_file_fk
where upper(coalesce(b.dml_data_target_name, b.query_data_source_name))
like '%ORDERS%'
order by 1, 2;
LOVs and record groups that reference a table
The record group holds the SELECT; the LOV names the record group it
uses. A record group with no LOV beside it is one something builds or
populates in code.
select f.file_name, l.form_lov_name, g.form_record_group_name, g.record_group_query
from form_record_groups g
join form_files f on f.form_file_pk = g.form_file_fk
left join form_lovs l on l.form_file_fk = g.form_file_fk
and l.record_group_name = g.form_record_group_name
where upper(g.record_group_query) like '%CUSTOMERS%'
order by 1, 2;
Everything that touches a table, module by module
From the blocks: read, created, updated, deleted. A table named only
inside a trigger is not here.
select f.file_name, u.table_name,
u.reads, u.creates, u.updates, u.deletes
from form_table_usage u
join form_files f on f.form_file_pk = u.form_file_fk
where u.table_name like '%ORDER%'
order by 3, 1;
Anything called by a name, whatever kind it is
There is no table of every object, so this is a union over the
kinds worth asking about — add or drop a leg to suit.
select f.file_name, 'item' as kind, i.form_block_name, i.form_item_name as name
from form_items i join form_files f on f.form_file_pk = i.form_file_fk
where upper(i.form_item_name) like '%DATE%'
union all
select f.file_name, 'block', b.form_block_name, b.form_block_name
from form_blocks b join form_files f on f.form_file_pk = b.form_file_fk
where upper(b.form_block_name) like '%DATE%'
union all
select f.file_name, 'LOV', null, l.form_lov_name
from form_lovs l join form_files f on f.form_file_pk = l.form_file_fk
where upper(l.form_lov_name) like '%DATE%'
order by 1, 2, 4;
The boilerplate text on every canvas
A text object's font run rides on the graphic that holds it, so
what a label says and how it is drawn is one row.
select f.file_name, g.form_graphic_name, g.segment_text,
g.segment_font_name, g.segment_font_size
from form_graphics g
join form_files f on f.form_file_pk = g.form_file_fk
where g.segment_text is not null
order by 1, 2;