Create Index on multiple columns?

[inawlaljar]

Is it possible to create index on multiple columns?

for e.g. tryCreateIndex(User.TABLE.index("ss_fb_def_item_idx", [User.ADDRESS_ID, User.ORG_ID, User.EDUCATION_ID]));

[jdkoren]

Sure you can. The Table.index() method (and the Index constructor) accepts a variable number of Property<?> objects. You can write it like this:

User.TABLE.index("ss_fb_def_item_idx", User.ADDRESS_ID, User.ORG_ID, User.EDUCATION_ID)

You could also declare an array if you wanted to since var-args can accept an array.

[inawlaljar]

THanks.