Skip to content

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

Open
@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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions