Adding lookup table for each select field values in Jira

[Allen Chun]

Hi Atlassian Community, 

Is there a way I can tie up a quantity field for each values in the Select Field? 

Basically I'm creating a borrowing system for a specific items.

Scenario:

1) A staff can borrow an item by selecting an item from Item Type select field (sample values are Laptop, iPhone, Monitor etc..)

2) Staff also input the Borrow From  and Borrow To date custom field

3) Staff also input the Quantity for the item type

4) From the inputs above, I would like to validate the availability from this Item Type from the specified From and To date. That's why I want to tie up a quantity for each item type.

Is there a lookup table add-on or built in feature in Jira where I can perform JQL queries. 


Thanks in advance.

[Jack Brickey · Accepted solution]

There are a number of asset management addons in the marketplace. I don’t have firsthand experience so can say if any will achieve your goals but I would have to assume they would.

[Allen Chun]

Thanks @Jack Brickey Not necessarily an asset management addon but more on lookup table for the scenarios I stated in my question. I would like to perform JQL in order to check the availability of items inputted by the user vs the items in the lookup table. example SQL query

SELECT * FROM items WHERE item_type = <item_type> AND borrowed_from <= <borrowed_from> AND <borrowed_to> <= borrowed_to

validate if returned records from SQL then return error like Item not avaialable

[Jack Brickey]

Well you could certainly create the necessary fields as you have laid them out and could create a JQL but I fail to see how you would implement the actual inventory availability within Jira, I.e. return item available or not. There isn’t a count field available that could be incremented and decremented so you would have to manage that somewhere else.