NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: broche on October 03, 2017, 07:13:59 AM

Title: Contract button on browse and passing a paramater
Post by: broche on October 03, 2017, 07:13:59 AM

CL 10
NT 10.06

Have a contract button on a browse that will drop down a listing of documents.
The document list is filtered on a field in the browse, there is no relationship in the dictionary between these two files.
How do I get the value from the browse to use on the filter?  I see a parameter prompt but this does not seem to work.
If I hard code the filter with the Staff ID it works just fine.

Does Not Work
'CVFA:Status=<39>ASSIGNED<39> AND CVFA:AssignedTo=' &p_web.GSV('MTC:StaffSysID')

Works Fine
'CVFA:Status=<39>ASSIGNED<39> AND CVFA:AssignedTo=123'

Thanks

Title: Re: Contract button on browse and passing a paramater
Post by: Bruce on October 03, 2017, 09:09:13 PM

I suspect this may be one of the cases where using MTC:StaffSysID directly may be in order.
Since you are populating the parent browse, and hence cycling through the records there...
So try

'CVFA:Status=<39>ASSIGNED<39> AND CVFA:AssignedTo=' & MTC:StaffSysID

This leads me to thinking though that assigning the session value in the browse loop.

cheers
Bruce