To enter a Data Value for multiple SDIs, use the following example as a guideline:
sdcid = Sample
keyid1 = S01;S02;S03
paramlistid = Metals;Polymers;Fluids
paramlistversionid = 1;3;5
variantid = 2;4;6
dataset = 1;2;3
paramid = Al;HDPE;IPA
paramtype = Std;Mod;Unu
replicateid = 1;1;1
enteredtext; 100;200;300
This will search the SDIDATAITEM table for a match on each set of qualifying columns. The first value for the first property
is matched with the first value in the second property and so forth. When an exact match is found,
the enteredtext column is provided your value. This action may also result in other columns being updated such as
TransformValue, EnteredQualifier, DisplayValue, EnteredValue, and more.
Using the example values shown above, we would expect these three data items to be updated as shown in this table:
| Qualifying Column | Matching this value combination (all columns must match) | ||
| keyid1 | S01 | S02 | S03 |
| paramlistid | Metals | Polymers | Fluids |
| parmlistversionid | 1 | 3 | 5 |
| variantid | 2 | 4 | 6 |
| dataset | 1 | 3 | 3 |
| paramid | Al | HDPE | IPA |
| paramtype | Standard | Mod | Unu |
| replicateid | 1 | 1 | 1 |
| Entered Text | 100 | 200 | 300 |