ISession.Query with index returns null even though record exists

[wyarcdev]

ISession.Query with index returns null even though record exists

I'm querying a WorkflowType using its index, but it returns null despite the record existing:

var type = await _session.Query<WorkflowType, WorkflowTypeIndex>(x => x.Id == id).FirstOrDefaultAsync();

When I call this with id = 19, it returns null. However, I've confirmed the record exists by checking the list directly.
What could cause this mismatch? Is there something specific about how YesSql indexes work that I'm missing?

[hishamco]

What's the OC version? Does this happen with WorkflowTypeIndex only?

[wyarcdev]

2.0.0, I figured it out, it was a mistake on my part
#18710 (comment)

[wyarcdev]

I've figured it out, when querying with index, when I use "Id" it refers to the MapIndex Id. The proper way to query is:

var doc= await _session.Query<WorkflowType, WorkflowTypeIndex>(x => x.DocumentId == myWorkflowType.Id).FirstOrDefaultAsync();

// or just query directly
var doc= await _session.GetAsync<WorkflowType>(id);