Information on Reservations & Data - Orient DB

Document ID : KB000092330
Last Modified Date : 19/04/2018
Show Technical Document Details
Introduction:
I need to extract information on the number of records that are still not reserved and available for use per TDM portal model.  This information is created and stored in the OrientDB.  this information can be obtained manually checking it from the TDM portal by clicking and writing down the results for every test match.  As you might guess, this is very time consuming, especially when you have many models. Being able to create a report based on the information in the database rather than manually gather the information as I click through the models is the most efficient method,
Question:
Can you please let me know how to access the information on the data available in the TDM portal models through the Orient DB that is displayed in the UI?
Answer:
You need to select data from ‘Reservations’ table.

Example:
Column is ‘payL’ (JSON string payload).
Because ‘payL’ is a String, you cannot ask the usual way “where dataModelId=123” you have to match the string “where payL like ‘%123%’”.
Payload contains reservations keys.
You can add conditions to the where clause.
In my model with ID 165, I can easily find cities whose name is “Brno” using this query: select * from `Reservation` where payL like "%\"dataModelId\":165%" and payL like "%\"NAME\":\"Brno\"%"
Additional Information:
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html