Question

Expand length of the column

  • 7 July 2022
  • 1 reply
  • 107 views

Badge +6

Hi Team,

 

Our requirement to use external Ref id to store in FSM table and use this as key for inbound requests  .  Ex: REQUEST table “CROSS_REFERENCE” is string 64  and wanted to increase to 128. 

is there any way to 

  1. increase length of column 
  2. Create an index on this column 

this seems common requirements and has anyone done this approach. 

Thanks,

Srinivas


1 reply

Userlevel 7
Badge +24

Hi @seeda,

Creating an index is fine but standard fields should not have their field types amended. The standard route for this is to use one of the userdef fields and then rename it on the front end to be a more suitable name if it needs to be displayed to users. Then you can pick the userdef field with the required types and create an index on that userdef field without interfering with the baseline fields.

Kind regards,

Lee Pinchbeck

Reply