Issues Queryable doesn't return data

[Amulya Prabhakar]

Hello –

Ours is a simple C# application which calls Atlassian SDK to auto-generate Jira tickets from it. We are able to create tickets but unable retrieve all the tickets created.

Can we know if you can provide any insight on why the data isn't returning on making on either of the below calls –

var projIssues = (from i in jira.Issues.Queryable
where i.Project == "XXXXX"
orderby i.Created
select i).ToList();

(OR)

var issues = (from i in jira.Issues.Queryable – This doesn't return any data
where i.Key.Value.Contains("XXXXXX")
orderby i.Created
select i).ToList();

We've tried multiple alternatives with Issues Queryable and none return any data. Interestingly, as mentioned before we are able to create tickets, call GetIssueAsync and get ticket information. But we require to get back all tickets and for some reason this isn't working.

Any help would be highly appreciated.

[Nic Brough -Adaptavist-]

The Atlassian SDK doesn't work like that.  What libraries are you using to provide the querytable function, where is the code running (inside Jira or an external application) and what method does the application use to talk to Jira, if it is an external application?  REST or something else?

[Amulya Prabhakar]

What libraries are you using to provide the querytable function -  Atlassian SDK  that contains LinqToJira for querying JIRA Issues. 

Where is the code running (inside Jira or an external application) : External - Ours in .Net Core API application

What method does the application use to talk to Jira : Here's the private fn within our application that makes the call - (Ref : https://bitbucket.org/farmas/atlassian.net-sdk/src/master/docs/how-to-use-the-sdk.md) Connection to Jira is already established

private IQueryable<Atlassian.Jira.Issue> FindPartialDuplicates( Employee employee, Services service, string project)
{
var parts = (from i in jira.Issues.Queryable
where i["First Name"] == employee.FirstName
&& i["Last Name"] == employee.LastName
&& i["Service Start"] == service.ServiceStart
&& i["Policy/Medicare #"] == service.PolicyID
&& i.Project == project 
select i);

return parts;
} 

[Nic Brough -Adaptavist-]

Ok, so an added library that I'm not familiar with.

My guess is that it would be asking Jira over the REST interface, as that's the recommended way to talk to it.  I'm afraid you'll need to debug the library to see what it is doing.  My best guess is that there's either a bug in it dropping the issues, or that your authentication to Jira is failing so it can't read any issues out.