Page 1 of 1

Indexed column query

Posted: Mon Jul 07, 2014 2:53 pm
by 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


Indexed column query

Posted: Mon Jul 07, 2014 3:18 pm
by Evgene Karachevtsev

Hello Koen,

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


Indexed column query

Posted: Mon Jul 07, 2014 5:54 pm
by 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


Indexed column query

Posted: Mon Jul 07, 2014 8:48 pm
by Evgene Karachevtsev

Koen,

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