Pulling a specific row from seedlist

[Legacy User]

Is it possible to pull a specific row from a seed list? I can tell it to pull a sequential or random row, but not a specific one like I can do with columns.

[Sean-K-CA]

The only way that I can think of to do this would be to query the seedlist in the repo directly...

 

Get a list of all seed lists:

SELECT DISTINCT RD_REF_ID FROM GTREP.GTREP_REFERENCE_DATA

 

Say you want to work with "FirstName" -

SELECT RD_REF_VALUE_1 FROM  GTREP.GTREP_REFERENCE_DATA WHERE RD_REF_ID = 'FirstName'

 

You could then modify the above query to get the value that you want.

 

Note that some seed lists have multiple RD_REF_VALUE_* fields. Like "US Valid Addresses" so select accordingly.