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?