Posted by [IP Address: 162.95.80.197] 'ShuSheng Li' on August 30, 2001 at 12:16:52 EST:
In Reply to: Re: Limit number of records in a prompt table posted by [IP Address: 162.95.80.197] 'remotedeveloper' on August 30, 2001 at 08:37:34 EST:
Here are some details:
The panel is in AR(manage sale acitivity)> apply payments > express deposit. If you open the panel for "ADD", the first thing is a pop up window asking for "Deposit Unit". Normally user would key in the value of the Business Unit she/he is working on. After specify Banking info. on the "Total" panel, user then will go ahead to the "Payment" panel; and this is where the problem happens.
The field is the Item ID. When user press F4 or dropdown botton to get the valid values in the prompt table, the process of loading the prompt table is VERY LONG and that is the problem. It returns over 20,000 rows and this number keeps growing because we keep consolidate other systems into PeopleSoft. The query that loads the prompt table is not from people code, it from the view's query. At this point, user already have the value of Business Unit (shows at the header section), but the query does not. Is it possible to pass the value of the Business Unit to the view's query in order to narrow down selections?
Are you saying I may use ExecSQL to populate the prompt table at the SearchInit event?
Thanks
ShuSheng Li