How to create test data to insert into a database (how to create a page row)
I have a test case for which I want to create some test data. I want this test data to be available no matter which environment I am in (Dev, QA, etc). So to do this I want to add 3 to 4 rows of data to the database that the Data Page will be referencing.
Ex. Suppose I have an database table (which is replacated by the class) Names, which have fields, "ID", "First", "Last"
I want to add the following data:
1, "Frank", "Franklin"
2, "George", "Gershwin"
3, "Harry", "Henderson"
To do this, I started to create a Data Transform. In the Pages & Classes, I've added:
Rows | Code-Pega-List
Rows.Row | Names
What do I do on the Definitions tab? I've tried to do an Update Page or Append and Map to, but I don't seem to be doing something correctly.
What I ended up doing is create a Decision Table where the Results is "Evaluate all rows". The decision table contains all the desired data and each column header is .Rows(<APPEND>).FirstProperty, .Rows(<LAST>).SubsequentProperty. Where .Rows is an added property to the data page I'm modeling and it is a List Page of that data page. I then used a Data Transform to get the data from the decision table. It all worked out.