Hi all, I have a question about retrieving data based on certain conditions. I have two tables A and B with one-to-many association. Table A has student details(primary key being student ID) and Table B has list of corresponding courses attended by the students. I need to fetch the courses attended by a particular student, who has logged in. How do I mention the student ID from A and fetch course details from B for that student as a constraint in the XPath specification of the data view or list view that is used?
You would write an Xpath retrieval for your course object with a constraint similar to:
or if running this in a grid it would be something like: