I have two objects like Teacher and student and i created two models.
I have created two tables with two models. I would like to search Teacher object with the student record.
Arjun, this is very feasible. I assume that there is some relationship between the two objects, maybe each student has a lookup to teacher.
So, make your two models. But the teacher model should have the following items.
1. Set model to Not load data on page load (in the advanced tab of the model)
2. Give it a condition on the Teacher Record Id that does not have any value and is “filterable default off”
Then go to your Student Table and add a Row Action. It should be of type “Run Multiple Actions”. Here are the actions you run.
1. Activate Condition and Send value. Look for the Teacher Model and select the condition you made in step 2 above. Pass it the TeacherId value from your student record using merge syntax. Probably somthing like {{TeacherId}}
2. Query model. Choose the teacher model. This will make your teacher table appear with the record associated with your student.
If the relationship goes through a junction object (many to many) your teacher model needs to be set on that junction object and your condition should look for all Junction Object records that have the particular student Id.
Hope this provides you an outline of how to get this done.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.