## Set-Up Instructions
## Task 1 – Create a Database Collection in SearchBlox
After logging in to the Admin Console, select the Collections tab and click on Create a New Collection or "+" icon.
Next, Choose Database Collection as Collection Type.
Enter a unique name, choose access type, choose the language and click Save to create the collection. This will add a database collection to the SearchBlox server.
## Task 2 – Database Collection Settings
Select database type as JIRA from the dropdown menu. Enter the database URL string in the format as shown here:
jdbc:jira:[email protected];Password=password;Url=https://yoursite.atlassian.net;API Token=XXX;`
Provide SQL Query to fetch the data from JIRA. The Query format is: SELECT <index field> as uid , <column name2> as title, <column name3> as content FROM <tablename> LIMIT 100
Configure SQL Query
Some of the commonly used tables and queries in JIRA are:
SELECT * FROM Projects
SELECT * FROM Comments
SELECT * FROM Issues
For more data tables that can be indexed from JIRA, use the following link:
If you have more than 100 entries in a table, specify the number of documents to be indexed by giving LIMIT value in the query. For example:
SELECT * FROM Account LIMIT 1000
Otherwise, a minimum of 50 rows will be indexed.
For API Token, login to JIRA Account. Go to Account Settings -> Security -> Create and Manage API Token -> Create API Token.
Save the settings.
Check the settings by clicking Test Database Collection. The database connection has to be successful for the indexing to work.
## Task 3 – Schedule and Index
Schedule indexing from the Schedule tab or from Manage Collection page.
After reaching the maximum number of documents, if continuous indexing is not required, click stop.
Search results in faceted search is shown here:
## Task 4 – Viewing Search Result in Kibana
Indexed content from JIRA can be visualized using Kibana.
The following example uses the maximum number of fields available in the data table **_account_**. The query to provide is
SELECT * FROM Issues LIMIT 1000
## Steps in Kibana
**1. Start Kibana** How to start [Kibana Visualizations](🔗)
**2. Add the collection ID**
**3. After adding the index, you can view the fields mapped.**
**4. Create visualizations by following the steps listed in the reference link, provided in the preceding step one.**
Sample visualization generated for JIRA data indexed in JIRA: