This content has been marked as final. Show 2 replies
hi, i have that already set to ensure data is in sync in all tabs within the subtab region....but that does not help with the problem.
i worked past this problem by moving all the search fields to the initial tab, HOWEVER, i have requirement when page loads first time it has to automatically query rows for whoever is logged in . so in process request i coded to populate appropriate search field with the userlogin and did the default execute query. unfortunately, this did not append the where clause and it gave me all rows. strangely , after the page is initially rendered, if i just hit Go, it generates the where clause and returns the right rows. WHY IS THAT ? how do I make my initial page render with the correct/restricted results ???
since facing the above issue, on the initial page loading after setting the searchfield with the login i myself set the whereclause and did executeqry. this brought the correct initial rows. then i also reset the whereclause to null (to ensure when user changes search criteria and hits Go, only the new whereclause gets generated). however, now the Go button does nothing (ie the rows displayed remain the same as the initial rows even though the searchcriteria fields were changed....)
to summarize requirement is -
1. search results (construction mode - autoCustomizationCriteria) to display in subtab region
2. initial page rendering has to programatically display a resultset restricted to a searchfield (ie restrict by login)
3. subsequent queries on Go (where user may input values in other searchfields) should be handled by the default generation of the whereclause as provided under the autoCustomizationCriteria mode
any insight into this problem ? i am stuck with this as this is very critical for my page...