management of a shared vehicle

[Raul Rossi]

Hi everyone,

we'd like to manage the booking of a company vehicle and, more importantly, its availability using JSM.

Any suggestions?

We've currently created the request form and workflow, but we're stuck on managing availability.

Thanks in advance.

[Raul Rossi]

Hi,

I found a solution but my JQL is not working well.

customfield_10393 = Plate Nr; customfield_10412 = Date Time PickUp; customfield_10413 = Date Time Return

project = XXXXXX AND key != {{issue.key}} AND {{customfield_10393}} != "Not Available" AND {{customfield_10412}} < {{issue.customfield_10413}} AND {{customfield_10413}} > {{issue.customfield_10412}}

Manually all is fine and I can find overlapping

project = XXXXXX AND key != "XXXXXX-102" AND "XXXXXX Car Model and Plate" != "Not Available" AND "XXXXXX DateTime Pickup" < "2026-02-03 12:30" AND "XXXXXX DateTime Return" > "2026-02-02 17:00"

Any suggestions?

[Nikola Perisic]

Hello @Raul Rossi 

I would strongly recommend Booking by Apwide that handles all use cases that you have mentioned: https://marketplace.atlassian.com/apps/1236123/booking-resource-reservation-for-jira-and-jsm

[Raul Rossi]

THX