I'm a little confused. Are you searching against these different titles or is the search something else and you're really only interested in displaying different titles for documents returned for the query?
If it's just a display issue, you can use multivalued fields, the order in which you put values in the fields is the order in which they're returned and your application layer can decide whether to display the title or not. This implies that you return all the titles and dates with each document to the app... If you're searching against titles and dates, that's a different case, you'd be adding some clause like AND ((title_1:yourtitle AND st_date_1:[* TO NOW] AND end_date_1:[NOW TO *]) OR (same for title2) OR ....) Best Erick On Mon, Jul 25, 2011 at 12:27 PM, abhayd <ajdabhol...@hotmail.com> wrote: > hi > > > What i want to do is get title_1 if NOW is between st_date_1 and end_date_1 > Also at the same time get title_2 if NOW is between st_date_2 and > end_date_2 > > and so on > > at present i have a schema like this denorm'. I cant figure it out a > single solr query to do this. > <field name="id" type="string" indexed="true" stored="true" > omitNorms="true"/> > <field name="search_terms" type="text" indexed="true" stored="true" > omitNorms="true" multiValued="true"/> > <field name="img_url" type="text" indexed="false" stored="true" /> > <field name="number_of_links" type="sint" indexed="false" stored="true" > /> > <field name="header" type="text" indexed="false" stored="true" /> > <field name="img_position" type="text" indexed="false" stored="true" /> > <field name="url_1" type="text" indexed="false" stored="true"/> > <field name="title_1" type="text" indexed="false" stored="true"/> > <field name="desc_1" type="text" indexed="false" stored="true"/> > <field name="st_date_1" type="date" indexed="true" stored="true"/> > <field name="end_date_1" type="date" indexed="true" stored="true"/> > <field name="url_2" type="text" indexed="false" stored="true"/> > <field name="title_2" type="text" indexed="false" stored="true"/> > <field name="desc_2" type="text" indexed="false" stored="true"/> > <field name="st_date_2" type="date" indexed="true" stored="true"/> > <field name="end_date_2" type="date" indexed="true" stored="true"/> > <field name="url_3" type="text" indexed="false" stored="true"/> > <field name="title_3" type="text" indexed="false" stored="true"/> > <field name="desc_3" type="text" indexed="false" stored="true"/> > <field name="st_date_3" type="date" indexed="true" stored="true"/> > <field name="end_date_3" type="date" indexed="true" stored="true"/> > <field name="url_4" type="text" indexed="false" stored="true"/> > <field name="title_4" type="text" indexed="false" stored="true"/> > <field name="desc_4" type="text" indexed="false" stored="true"/> > <field name="st_date_4" type="date" indexed="true" stored="true"/> > <field name="end_date_4" type="date" indexed="true" stored="true"/> > > Any help getting correct query? > > Also i thought of using multivalue filed like > title , st_date, end_date, But I am not sure if two multivalue fields > co-relate with each other. That is if today's date does not fall in first > st_date and first end_date then i dont want to have first title in results. > Is that possible ? > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/multivalue-or-denormalise-tp3197942p3197942.html > Sent from the Solr - User mailing list archive at Nabble.com. >
