Indexed column query

[Koen Huylebroeck]

Hi,

I'm looking for some additional info on the use of indexed columns in collections. If I have an indexed column 'question', can I query on the index? How?

Thanks in advance,
Koen

[Evgene Karachevtsev]

Hello Koen,

Hope this link will be useful: https://getsatisfaction.com/apperyio/...

[Koen Huylebroeck]

Hi Evgene,

Thanks for sharing the link. To make sure I understood, please consider the following situation:

• A collection with a column 'question', containing 10 questions

  If I want to be able to query the 6th question, I need to add a column 'question_id' to do so? The creation the column 'question_id' can not be avoided by checking the option indexed column when creating the 'question' column?

  Thanks in advance for further clarification,
  Cheers,
  Koen

[Evgene Karachevtsev]

Koen,

You should create a column 'question_id' - 'indexed column' does not help to avoid the creation of this column