How can I add an index on a field of type textarea? I have added the index with field(32). Which is the part of the field I'd like to index. However, each time we do a Quick Repair and Rebuild. Sugar finds the index but wants to remove and re-add the index.
Any thoughts?
This is in version 13
Example:
Fullscreen
1
2
3
4
5
6
7
8
9
10
$dictionary['SchedulersJob']['indices']['idx_webhook'] = [
'name' => 'idx_webhook',
'type' => 'index',
'fields' => [
'target',
'status',
'data(32)',
'deleted'
]
];