TDM: Find and Reserve needs inbuilt SQL functions (Count, Trunc) , custom functions and
search cancel

TDM: Find and Reserve needs inbuilt SQL functions (Count, Trunc) , custom functions and

book

Article ID: 191568

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have a need to use Find and Reserve with inbuilt SQL functions as per the query examples below:

1. SELECT     PARTICIPANT_ID, COUNT(CLIENT_ID) AS NUMBER_OF_CLIENTS   FROM    PARTICIPANT   HAVING  COUNT(PARTICIPANT_ID)>'1'    GROUP BY PARTICIPANT_ID
2. SELECT PARTICIPANT_ID, FLOOR(( TRUNC(SYSDATE) - TRUNC(BIRTH_DATE))/365.25) AS AGE   FROM PARTICIPANT   WHERE PARTICIPANT_ID IN      ( SELECT PARTICIPANT_ID FROM PLAN_PARTICIPANT                   WHERE PLAN_ID ='12345'  )

We also have a need to use custom SQL functions in the Find and Reserve. Example below

1. select SSO_CLIENT_ID,  trim(SSO_USER_ID) as sso_user_id, sso.FUNC_DECRYPT_STR(password) as PIN, USERNAME, DATE_OF_BIRTH from SSO.SSO_USER where SSO_CLIENT_ID = 'QQQQ' and sso_user_id in ('123445678')

Can you please advise how can we use Find and Reserve to accomplish these use cases?

Environment

Release : 4.9

Component : CA Test Data Manager - TDM Web Portal

Cause

Not supported

Resolution

Currently this is not supported.

Our next product release, we will support views.