The issue was in creating this function at slide 95 in lab 6BTW, if you create a SQLQuery type function, don’t add any inputs or outputs, but just go straight into SQL query editor and paste the scripts, you will get exactly the function like the above one (obviously without the external inputs/outputs, which have to be added manually).

As you can see, there is no ContainerNo input, but there is a Container input (probably the Container was added before the SQL script was pasted, as pasting the SQL script creates all inputs and outputs correctly).

 The query displays the data when the following condition is met:

WHERE

                C.Container = @ContainerNo

 In the students’ query the SubmitKey was providing the container Id to the @Container input, and the @ContainerNo was not populated at all (as it is not in the configuration).

This is why the popup was showing no data.

We changed the input to ContainerNo, and the popup works as expected.