1 to many association data fetch using XPath

0
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?  
asked
1 answers
4

You would write an Xpath retrieval for your course object with a constraint similar to:

[Mymodule.Course_Student =$Student]

or if running this in a grid it would be something like:

[Mymodule.Course_Student ='[%CurrentObject%]']

Hope this helps

answered