Posted by [IP Address: 198.167.54.68] 'K Kemp' on September 12, 2001 at 06:53:27 EST:
I have created a table with position # and review date as the keys. Each row stores classification information for each position. I want to create a panel which will display a number of fields from this table and a number of rows from the table (say maybe in a grid). But I do not want to list the information necessarily by position number. I may want to see all of the positions which belong to a particular department or I may want to see all of the positions which have been assigned a particular rating. In other words, I want to be able to "query" or search on one or a number of fields from this table and have the resulting rows display on the panel.
Using a search box will give me the option of choosing from many fields and then bringing back the results, but I can only display one row from my list on the panel. How can I display all of the results on my panel without having a higher level key than what I am filtering on?
What I am looking to do is basically have a panel which displays the result of a query on a single table with varying parameters used to run the query. One day I may want to see of the rows where the ratings are the same, another day I don't care if the ratings are the same but I want all of the rows with a certain classification level etc. Is what I am asking to do possible? And any suggestions on how this could be done?
We are using PeopleTool 7.05.10 .