BMC Remedy FTS
- Chris Speed
- Mar 6, 2017
- 1 min read
How to determine which fields are being used by FTS
select 'character' TYPE, c.name FORM, b.fieldname FIELD from FIELD_CHAR a, field b, arschema c where a.schemaid = c.schemaid and a.schemaid = b.schemaid and a.fieldid = b.fieldid and a.fulltextoptions = 1 UNION select 'diary' TYPE, c.name FORM, b.fieldname FIELD from FIELD_DIARY a, field b, arschema c where a.schemaid = c.schemaid and a.schemaid = b.schemaid and a.fieldid = b.fieldid and a.fulltextoptions = 1 UNION select 'attachment' TYPE, c.name FORM, b.fieldname FIELD from FIELD_ATTACH a, field b, arschema c where a.schemaid = c.schemaid and a.schemaid = b.schemaid and a.fieldid = b.fieldid and a.fulltextoptions = 1 order by FORM asc, FIELD asc
Comments