Hi, I have 2 Smart Objects -
1. Connected to a view in Oracle database that fetches [name, id, yearmonth, user] - acts as master data
2. Connected to a webservice that fetches data from another table where we have [id, yearmonth, otherValue] - acts as details data
They are associated in K2 designer as 1[id] == 2[id], such that when I fetch rows from Smart Object [2], then it displays in the table - [name, otherValue]
The data stored in the View (SO=1) has multiple occurances of the same [id,name] by yearmonth and user
The catch here is - when user will want to add a new data, then there will be a list box which will display [name] from SO=1 which are valid for that user and yearmonth, then provide the details and Save the data to the details table.
When I run the view, I am unable to tell K2 to fetch data from master (SO=1) based on passed [yearmonth, userkey] parameter. As a result of which, I am having a cartesian return in the list.
Can you please advise if the approach is correct?
Many thanks in advance,
Saikat.