Create index: Sort by custom metadata

[ErikHeemskerk]

I'm trying to define an explicit index using an AbstractIndexCreationTask which will sort documents by a custom metadata property, but I get a runtime exception if I want to create the index.

The index is defined as follows:

internal sealed class FoosByClassificationOrderedByCreatedIndex: AbstractIndexCreationTask<Foo>

{

public FoosByClassificationOrderedByCreatedIndex()

{

Map = Foos => from foo in Foos

                   select new

                   {

                   foo.Classification,

                   Created = this.MetadataFor(foo).Value<DateTime>("Created"),

                   };

Sort(foo=> MetadataFor(foo).Value<DateTime>("Created"), SortOptions.None);

}

}

The exception I get:

System.InvalidOperationException in Raven.Abstractions: Not idea how to deal with convert value(Services.Raven.Index.FoosByClassificationOrderedByCreatedIndex).MetadataFor(foo).Value("Created") to a member expression

I'm using the embedded client (1.2) running in memory. Apparently, the map is not a problem, but the sort is.

[Oren Eini (Ayende Rahien)]

internal sealed class FoosByClassificationOrderedByCreatedIndex : AbstractIndexCreationTask<Foo>

{

public FoosByClassificationOrderedByCreatedIndex()

{

Map = Foos => from foo in Foos

 select new

 {

 foo.Classification,

 Created = this.MetadataFor(foo).Value<DateTime>("Created"),

 };

}

public override IndexDefinition CreateIndexDefinition()

{

var indexDefinition = base.CreateIndexDefinition();

indexDefinition.SortOptions["Created"] = SortOptions.None;

return indexDefinition;

}

}

Note that for dates, you don't need to do anything.

This is identical to the defaults.

[ErikHeemskerk]

So you mean I only have to map the metadata and I can then sort by it?

On Friday, August 3, 2012 10:49:41 AM UTC+2, Oren Eini wrote:

internal sealed class FoosByClassificationOrderedByCreatedIndex : AbstractIndexCreationTask<Foo>

{

public FoosByClassificationOrderedByCreatedIndex()

{

Map = Foos => from foo in Foos

 select new

 {

 foo.Classification,

 Created = this.MetadataFor(foo).Value<DateTime>("Created"),

 };

}

public override IndexDefinition CreateIndexDefinition()

{

var indexDefinition = base.CreateIndexDefinition();

indexDefinition.SortOptions["Created"] = SortOptions.None;

return indexDefinition;

}

}

Note that for dates, you don't need to do anything.

This is identical to the defaults.

[Oren Eini (Ayende Rahien)]

Yes