syncano-node icon indicating copy to clipboard operation
syncano-node copied to clipboard

Document which fields can be index'ed

Open mkucharz opened this issue 7 years ago • 4 comments

Where we can add order_index, filter_index etc.

mkucharz avatar Feb 28 '18 15:02 mkucharz

Part of this could be porting https://legacy-docs.syncano.io/docs/data-objects-filtering-ordering

mkucharz avatar Feb 28 '18 15:02 mkucharz

Current state of core:

all_types = {'string', 'text', 'integer', 'float', 'boolean', 'datetime', 'file', 'reference', 'object', 'array', 'geopoint', 'relation'}
noindex_types = {'text', 'file', 'object'}  # these cannot have any indexes at all

special cases: 
reference - can have filter, unique but no order
array, geopoint and relation - only filter (no unique, no order)

23doors avatar Feb 28 '18 15:02 23doors

@23doors so beside array, geopoint and relation all other can have unique? or text file and object also don't have unique?

mkucharz avatar Feb 28 '18 22:02 mkucharz

text, file and object cannot have any index at all - be that order, filter or unique. So text, file, object, array, geopoint and relation all cannot be unique.

23doors avatar Feb 28 '18 22:02 23doors