View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001893||Advanced Data Generator||General||public||2021-06-29 09:59||2023-01-18 14:50|
|Reporter||Martijn Tonies||Assigned To||Martijn Tonies|
|Priority||normal||Severity||feature||Reproducibility||have not tried|
|Fixed in Version||4.1.0|
|Summary||0001893: Ability to select unique items from lookup, but reset this for each master item|
|Description||Ability to select unique items from lookup, but reset this for each master item|
|Additional Information|| |
Suppose I have Table 1 and a "child" Table 2 on FK-PK
relationship. I want to create between 1-5 rows in Table 2 for
every row in Table 1. I want a data field that I want to
select at random from Table 3 (so e.g. Table 1 is Orders,
Table 2 is Order Lines, and Table 3 is Products). I see that
we can randomly select this product ID via random or unique.
So I'm generating n rows in Table 2 for every row in Table 1.
I want Table 2 to pick random values from Table 3. I am using
unique, because, I don't want the same product to appear twice
in the same order. But I cannot use unique, because it assumes
that each product will be selected only once for the ENTIRE
order lines table. However, I only want it to be unique for
the set of 1-5 records that I'm creating per Order table line.
Does this make sense? Is there a way to do that?
|Tags||No tags attached.|
|DBMS & Version|
|2021-06-29 09:59||Martijn Tonies||New Issue|
|2022-11-14 13:47||Martijn Tonies||Assigned To||=> Martijn Tonies|
|2022-11-14 13:47||Martijn Tonies||Status||new => assigned|
|2022-11-16 12:54||Martijn Tonies||Status||assigned => resolved|
|2022-11-16 12:54||Martijn Tonies||Resolution||open => fixed|
|2022-11-16 12:54||Martijn Tonies||Fixed in Version||=> 4.1.0|
|2023-01-18 14:50||Martijn Tonies||Status||resolved => closed|