I’ve created a new table in my database called “Survey” and established a relationship with the “visiting_system” table using _PK to _FK.
My goal is to display the Top 5 Satisfied entries for each Department and Host Name using portals on the visiting_system layout. Additionally, I’ve implemented global filter fields (g_filter) to allow filtering by Weekly, Monthly, and Annual timeframes.
However, I’m encountering challenges getting the portals to reflect the correct filtered results based on satisfaction level and selected date range. Any guidance or recommendations would be appreciated.
I don't know how large is the table your portal is displaying records from, but there is one thing for sure, you wish the portal will display the data in a timely fashion.
I you set a filter on the portal, then all the rows in the table will have to be downloaded to the client computer for the the portal to then filter. If you filter on the relation then the chore will be done on the server and only the relevant records will be pushed to the client. Without more knowledge of your system, it's hard to offer more advises, but a virtual table could be solution.