why we can extract the entire max result issues using particular project JQL in automation ?

[chandraprakash]

when i am using particular JQL for the project cant extract maximum only it give 50 index data of the page there is no different JQL for each 50 index data. I need to extract total issues but only get 50 max result, there is no page index options to pull the total data could anyone clarify this query?

[Darryl Lee · Accepted solution]

Hrm, I think that documentation is missing the limit parameter, which tells you how much to increment the start value so that you can keep requesting additional "pages" of data.

In your case, it sounds like the default limit is 50. So then, you need to make the same query, but add a start=50 to it. You would keep doing that until you get a response with isLast=true.

There's a good example (and probably a better explanation than mine) on how this works here:

Pagination in the REST API 

[chandraprakash]

thanks Mr. Darryl Lee with the help of your reply I found that alternate way finally it is help me to sort out this issue. Now onwards I can easily extract all the data 

thanks and regards
S. Chandra Prakash 

[chandraprakash]

@Darryl Lee I have question and Query ?

I wrote one program to calculate the all Jira project metrics for that i am using JQL to extract the values and I am calculating my project values and metrics but its done from the server 
But when We want to perform in the cloud database ?. So I have a following question to all Atlassian developer

1.how can I connect with my Jira cloud using python ?

2. How can I attached my program into real time Jira cloud database

3.Is there any document please share ?

4. Or else instead of creating new web programs is there any way to add a dynamic and custom plugin to Jira ?

[Darryl Lee]

Hi @chandraprakash

I've answered inline:

1.how can I connect with my Jira cloud using python ?

You can connect to Jira Cloud through REST APIs.

There are several libraries available. I think the best maintained one is probably this: https://github.com/pycontribs/jira

But you might also look at these:

• https://atlassian-python-api.readthedocs.io/#
• https://pypi.org/project/jira-cloud-python/

2. How can I attached my program into real time Jira cloud database

If you mean the backend SQL database for Jira, that is not possible:

https://community.atlassian.com/t5/Jira-questions/Is-there-a-way-to-connect-to-the-jira-cloud-database-using-sql/qaq-p/676203#M221762

3.Is there any document please share ?

No documentation for SQL access, because it doesn't exist. For REST API documentation see above. For add-on development, see below.

4. Or else instead of creating new web programs is there any way to add a dynamic and custom plugin to Jira ?

I believe there are two ways to develop add-ons for Jira:

Forge and Connect.

I do not profess to be a developer, but yeah, I think they're both more web program/service type of development than the traditional Java development used in writing plugins for the on-prem version of Jira.

For the full details on developing for Atlassian apps, you'll want to start here:

https://developer.atlassian.com/

There is even a separate Community for Developers:

https://community.developer.atlassian.com/

[chandraprakash]

Thanks @Darryl Lee  It will really helpful for me 
let me try if any queries, let me reach you

[chandraprakash]

Hi @Darryl Lee  I have one question

can I create a customized graphs for visualization using forge for my projects ?

I created my own customized plugin to measure the quality of my each project and I am tried to extract the data and done successfully because of you

By thinking advance now I need to create my own visualization for the data which I am needed and so for that I am having the following Questions please help me to sort out ?

1. can we able create my own graphs under forge either its Jira or confluence ?

2. If yes is there any documentation is there ? if not is there any other way to implement it ?

3. in forge I saw one video using {map builder}- countries map they build instead of that we can build any thing if there is any map type code or link please share with me ?

4. how my friends (Atlassian) maintain their visualization in a back end ?

please help me on this

[chandraprakash]

@Darryl Lee 

can I create a customized graphs for visualization using forge for my projects ?

I created my own customized plugin to measure the quality of my each project and I am tried to extract the data and done successfully because of you

By thinking advance now I need to create my own visualization for the data which I am needed and so for that I am having the following Questions please help me to sort out ?

1. can we able create my own graphs under forge either its Jira or confluence ?

2. If yes is there any documentation is there ? if not is there any other way to implement it ?

3. in forge I saw one video using {map builder}- countries map they build instead of that we can build any thing if there is any map type code or link please share with me ?

4. how my friends (Atlassian) maintain their visualization in a back end ?

please help me on this