Information on Reservations & Data - Orient DB

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/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,

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?

Environment

Release:
Component: TDMWBP

Resolution

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://community.broadcom.com/groups/viewdocument/demo-how-to-update-a-case-with-ca?CommunityKey=c475a143-13f8-4809-b469-d8541b80ea91&tab=librarydocumentshttps://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

To contact support, go to https://support.broadcom.com/