Re: Find sql behind a view

[Larry Roux <lroux@SYR.EDU>]

The view SQL under the prompt will return a certain set of values.  The
panel processor then uses the keys on the table and values on the panel
to determine which values to show.

For instance, if you have a table

(k) Vendor
(k) Item_Type
(k) Item_code
    Item_Amount

with rows

VENDOR    ITEM TYPE   ITEM CODE  ITEM AMOUNT
GEORGE    A           123        17.00
GEORGE    B           123        23.00
SAM       A           123        15.00

and there was a table at the same, or higher scroll level with the
VENDOR field set to GEORGE then you would not see the SAM row.
Similarly, if another (or the same) table had the Item Type "A" then you
would only see the first row.

Remember, the Select SQL will usually return many more rows than the
panel processor will show due to processing that occurs on that end.
Sometimes hitting Control-F4 on the field will show some (or all) of the
key values that are being used to "filter" the data, but many times you
just have to wade through the data/tables on the panel to see just what
is going on.

Larry Roux
Syracuse University




******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> allen.cunningham@SONOMA.EDU 03/18/02 19:32 PM >>>
I am trying to find the criteria used to fill a prompt table with
vendors on
the RUN_1099_COPYB_RPT panel. A certain vendor should be in the prompt
table
and is not, and I need to find out why he is not in the prompt table. If
I
have the name of the view (PS_VNDR_COPYB_VW) what is a good debug
technique
to find what the criteria is to load the table. I did a sql trace on the
panel and I see a SQL select being done that selects all vendors from
the
view so the user can pick one, but need to know whay my vendor did not
get
into the table.

Using SQR 4.3.4
PS 7.5 Financials

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*