In legacy SRM we had this value available in the Booking Overview table - Service State: Start, Stop, Failed.
Is it possible to get this value in a Visio?
It must be part of the booking object (since I can see it in the Bookings app)
Just to share, also found this placeholder that helped me to work around this:
[reservation:[var:IdOfSelection],Property=Booking Life Cycle]
Currently, the following properties can be used and shown in Visio using the '[Reservation:]' placeholder:
- ProfileID of a node
- ResourceID of a node
- Custom property
- Start time
- End time
- ID of the booking
- Status
I'm unsure if this 'Status' is matching the booking state in your booking manager. However, you can retrieve any data from the booking table using the ID of the booking as a subscription filter. An example of the subscription filter where the ID column is pid 102: SubscriptionFilter value=102 == [reservation:[This service],ID]
Status will tell you if the booking is ‘ongoing’, ‘confirmed’, ‘completed’, etc..
Unfortunately the table where we were fetching the data doesn’t exist anymore. That’s why we are looking for alternatives.
We’ll need to know where this data is stored before we can tell you how you can retrieve it.
Right now, a workaround can be to put it in a custom property on the booking. This way, it can be retrieved and shown with the current functionality.
Edit: What is the column called that contains this data in the ‘Bookings’ module?
It is called “SERVICE STATE”.
Looks like this is a custom property. This means you can access it using the [Reservation:] placeholder.
Syntax is test [Reservation:[this service],Property=MyPropertyName]. Extra details can be found in RN21843.
Could you tell me where you can find the value now that it’s no longer available in the table? Is it part of the Booking object as a property or a custom property?