I need to run a SQL query and use the output to map PV1 7.1. The query is :
SELECT ID FROM TestTable WHERE ProviderName = 'TEST,PROVIDER' AND IDType= 'BPI'
When I run this query with the 'TEST PROVIDER' I do pull the ID in question but I can't figure out how to do it from the DTL given that there are various providers sent in PV 1 7 . Any assistance will be greatly appreciated.