How to use variables in jql query while calling an api in java?

[sweety pareek]

I am trying to use a jql query in my java code.

HttpResponse<String> response = Unirest.get("https://sweetypareek155.atlassian.net/rest/agile/1.0/epic/none/issue").basicAuth(e,p).header("Accept", "application/json").queryString("jql", "project = 'project1' and created > '2023-03-22'").asString();

Here i want to replace 

2023-03-22 with a string variable storing the current date of today.

How to use a variable here in jql? 

[habib rahman · Accepted solution]

Hi @sweety pareek My name is Habib. I will do my best to assist:

---

Also, take a look at Adaptavist Library: https://library.adaptavist.com/

---

To use a variable in the JQL query in your code, you can use string concatenation to combine the JQL syntax and your variable:

You can create a variable `String currentDate` and assign the current date to it using the following code:

```

DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");

String currentDate = dateFormat.format(new Date());

```

And then replace the hard-coded date value in your JQL query with the variable.

```

String jqlQuery = "project = 'project1' and created > " + currentDate;

HttpResponse<String> response = Unirest.get("https://sweetypareek155.atlassian.net/rest/agile/1.0/epic/none/issue")

    .basicAuth(e,p)

    .header("Accept", "application/json")

    .queryString("jql", jqlQuery)

    .asString();

```

This will dynamically insert the current date value into your JQL query based on the value stored in the `currentDate` variable.

If this helped, please accept the answer so others might also benefit from this issue.Thank you 

Habib