According to your first sentence, I understand the results have already been logged and you want to retrieve some data that meet specific conditions. This can be easily done using SQL statements (using a WHERE clause) disregarding the schema you use.
After reading the second part of your explanation, it seemed to me that you are trying to create a database schema similar to the default one in TestStand 2.0. I am attaching an image with the default tables and relationships between them. As you will see, while in TS 1.0.x there were just 2 tables, in TS 2.0 there are many more tables. There is one table, called STEP_RESULT, which contain all the results that are common to every step type. The other tables are divided by step types. For i.e., the STEP_PASSFAIL table wil
l contain the results (properties) that belong to the Pass/Fail Test Step type only. As you can see, the layout of the tables is better structured and therefore easier and faster to handle. If you created a new step type, you'd just need to create a new table that would contain the properties that belong just to that particular step type. This table should be related to the STEP_RESULT table in the same way the others are.
The last part of your description talks about logging your new step type data to the database (if I understood correctly). In TestStand 2.0 this would be a simple task since you can easily define what you want to log by creating a schema that matches your database (you could refer to the user manual for more information). In TestStand 1.0.3 it is not that straightforward since you'll need to modify the "Database.seq" sequence file where you'll use database steps to log
the additional data.
I hope this will help in what you are trying to do. Otherwise, I think g
iving an example (such as a layout of the tables you'd like to use along with the results you'd like them to have) would be very helpful to fully understand what you are trying to accomplish.