Hey everyone,
I'm still very new to K2 and am trying to figure out how I'm supposed to be using SmartObjects in an ASP.NET application and take advantage of the relationships between SmartObjects.
Specifically, I have two SmartObjects, the first is Employee which gets its data using the SQL Server Service), the second is Assignments which is using the SmartBox Service. Below illustrates the basic relationship between the two. (I've cut out a lot of fields in the Employee SO for brevity.) What I want to display in my ASP.NET page is a single table with the combined results, also shown below:
In SQL, this is a very simple INNER JOIN query, how would I go about this using K2 SmartObjects?
Employee:
- Full Name
- Office
- Employee Number
Assignment:
- Assignee's Employee Number
- Assignment's Employee Number
To be displayed in table:
- Assignee's Full Name
- (Hidden) Assignee's Employee Number
- Assignment's Full Name
- (Hidden) Assignment's Employee Number