Skip to content

Not able to query data on a new index. #236

@dealerpickupadmin

Description

@dealerpickupadmin
  • to an existing json i have added a new index called StoreId.
  • then i tried to query using storeId and getting 0 response.
  • when checked in redis logs, index creation seems to be done fine.
    please suggest.

screenshot from redis stack
image

c#code:
.. Get Call
return await _customerAssociation.Where(c => c.StoreId == storeId).ToListAsync();

.. Class
[Document(StorageType = StorageType.Json, Prefixes = new[] { "CustomerAssociation" })]
public class CustomerAssociation
{
[RedisIdField]
public long Id { get; set; }

    [Indexed] public long StoreId { get; set; }

    [Indexed] public long CustomerId { get; set; }

... Index Creation
public class IndexCreationService : IHostedService
{
private readonly RedisConnectionProvider _provider;
public IndexCreationService(RedisConnectionProvider provider)
{
_provider = provider;
}

    public async Task StartAsync(CancellationToken cancellationToken)
    {
        await _provider.Connection.CreateIndexAsync(typeof(CustomerAssociation));
    }

    public Task StopAsync(CancellationToken cancellationToken)
    {
        return Task.CompletedTask;
    }
}
this class is added in startup and is being called when app starts


Please suggest what i am missing here

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions