Filter not working on child browse

[LSlowick]

Hi

I have a parent browse 'SampleBook' on file SBBBM using primary key SBB2:K_ .
I have a child browse 'SampleBC' on file SBBBK using primary key SBB:K_ .

On the parent browse one of the fields is SBB2:Book_ID and I'm trying to use that field in the
conditional filter of the child browse as follows:

'SBB:BOOK_ID = <39>' & p_web.GSV('SBB2:BOOK_ID') & '<39>'

Looking at the debug trace of the filter I'm not getting any value for SBB2:BOOK_ID in the child.

Question:

1) Are the columns in the parent browse row not available in the child by using GSV?
2) Is only the parent key/field values passed to the child?
3) In the child how can I access or get the values from the selected parent row?

PS.. I changed my filter in the child browse to use the parent key/field and it now work. But I'd still like to know for future reference / use the answers to my questions above.

Thanks for any help.
Lee

[bshields]

Hi Lee,

By default you can count on at least the primary key field being available. Before setting the filter i find it best to get the whole record of the parent file (or files i may need to set the filter)

Regards
Bill

[Stu]

Hi Lee,

You could _trace on the parent browse click, see what's going on there.

Also, if in a pinch, it's a good idea to try and replicate in one of the nettalk examples. The Accounts eg has parent/child browses (i think).

[Bruce]

>> 1) Are the columns in the parent browse row not available in the child by using GSV?

correct. The columns are not available. Only the "Unique key" fields (as set on the browse) are available. If you need other fields in that record you need to load the record yourself (in the callee not the caller) and do a
p_web.FileToSessionqueue(customers)

>> 2) Is only the parent key/field values passed to the child?

yes. (or more accurately, the parent key field values are set in the session queue for use by the child.)

>> 3) In the child how can I access or get the values from the selected parent row?

other than the key fields? Open the table, and read the record.

Cheers
Bruce

[LSlowick]

To all,

Thanks, it's now much clearer!

I just takes a while to put all the pieces together to understand what can or can't be used.

Lee