top of page

BMC Remedy FTS

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

 
 
 

Recent Posts

See All
Harbor Install & Setup

1. Go to the Harbor releases page & Download either the online or offline installer for the version you want to install. 2. Use tar to...

 
 
 

Comments


Contact Me

Tel: 678-642-8051

cspeed@jcsassoc.com

  • Google+ Long Shadow
  • LinkedIn Long Shadow
  • Facebook Social Icon
  • Twitter Long Shadow

© 2005 by Christopher Speed

Your details were sent successfully!

bottom of page