No JobCandidates are returned when filtering by `jobId`

[maxceem]

I have a Job:

This Job has a JobCandidate:

But when searching for JobCandidates and filtering by jobId not Job Candidates are returned:

For testing I'm using user tester1234 who is a Topcoder User.

[imcaizheng]

@maxceem Did you mean the jobCandidate can be found by querying /jobCandidates without filters while it cannot be found filtered by jobId?

In case the jobCandidate cannot be found even without filters, it could be possible that taas-es-processor doesn't properly create the jobCandidate in ES.

Trying to reproduce the issue, I cloned the latest commit of the taas-apis and followed the steps you mentioned. I am able to find the jobCandidate associated with a job using user tester1234.

[maxceem]

@imcaizheng

Did you mean the jobCandidate can be found by querying /jobCandidates without filters while it cannot be found filtered by jobId?

yes.

If I get all JobCandidates without filter, I get JobCandidate record for this Job:

But if I filter, then I don't get it:

I also, don't get it using admin user if I filter:

I get this issue, when I review the PR #87 - this is no dev branch.

[imcaizheng]

@maxceem I tried to run the app from PR #87 but still cannot reproduce the issue. Could you find any clue by looking at console log when querying GET /jobCanidates?
Also, please check whether the specific jobCandidate exists in both ES and DB.

[nkumar-topcoder]

@maxceem I verified, jobid that you highlighed and few other job id doesn't exists in postgres or ES

[maxceem]

@nkumar-topcoder I've tested it locally, so that Job is only in my local ES/DB.

[maxceem]

I've retested it after clearing ES/DB from scratch, and I cannot reproduce this issue anymore, probably I had some corrupted data in ES. So I'm closing it.