Should I use two query entities ?
Discussion posts and replies are publicly visible
Its better to create a view to get data from multiple tables. So we can use single query entity to achieve this.
Hi ,
If you have two or more different table with no dependency or relationship among them like Student(StudentID,StudentName,..), Qualifications(QualificationID, QualificationName,...), etc., you can use two different query entities to get the details.
If you have two or more different table with dependency or relationship among them like foreign key, you can create a view, create cdt for view then using query entities get the details. This will reduce the load on the interface when there are huge records. When it takes more time to load the data, screen will be showing working or it makes some delay in displaying the results. So we can avoid performance and user experience issue.
We really need a lot more information / detail to provide any sort of meaningful or helpful answer. Mainly, what do you intend to show / do on your interface? What exactly do you mean by "call multiple tables"? Do the different tables have any data-wise relationship to each other? Do you already have individual query entity expression rules defined for the individual tables/data types?
firstly can you please tell us whether you want to get the data from the both the tables and then want to show them together somewhere or do you have a different scenario for your interface ? Please help with these details so that we can suggest a suitable solution to you .