Plomino

Hello,

you can do it manually via the ZMI: go to your plomino db design tab / Others / Index then go to Indexes tab and add a new one

you can also do it by script: plominoDocument.getParentDatabase().getIndex().createFieldIndex("yourfield", "TEXT")

but in both cases, the index will be destroyed by any db refreshing

refresh rebuilds entirely the index and it only uses the fields declared into forms

so the best way is just to add a field in a form (even if you do not display it in the form layout), just to make sure the index is properly created

regards

eric