nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Objects: One data set results as parameters to another data set

actuser9

Hi,
 
I am using iHub3.1. As part of the data object, ss it possible to use the results of one data as parameter for another data set? If possible, can anyone please post a sample?

Find more posts tagged with

Comments

Chad Montgomery

I believe the best way to go about this is a joint data set. I'm not sure of your requirements, but hopefully this helps.
 
The Customers data set is just a single row return that gets the SalesRepEmployeeNumber based on the CustomerNumber in the query. The Employees dataset just returns all of that table. The joint data set does an inner join on the SalesRepEmployeeNumber and the EmployeeNumber from the Customers/Employees data sets.
 
The result is all rows that contain the SalesRepEmployeeNumber that was returned in the Customers data set.
 
Does this help?

actuser9

Thanks Chad!
 
I have the first data set with 9000 rows and second data set with 4million rows. I am using a left outer join and would not want all the 4million rows on second data set. I am looking a way to get the a column from first data set to be a parameter for the second data set in data objects. 
 
I have done this before in the report but not sure if data objects has this flexibility. Please advise.