NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Richard I on April 04, 2019, 12:13:24 AM

Title: Filter on File Drop
Post by: Richard I on April 04, 2019, 12:13:24 AM

Hi,
On a form, I have a file drop on Department Name (Dep:Name)
Each record in the Department table has a ZoneNumber (Dep:Zone)

Each Employee has a zone Number (EMP:ZoneNumber)

I want the file drop to display only those Departments that have the same zone number as the employee's zone  last logged in

The filter doesnt like the = in the expression Im trying to set and besides, the Dep:Zone hasnt been called...?

How to please?

Many thanks
Richard
NT 11.07

Title: Re: Filter on File Drop
Post by: DonRidley on April 04, 2019, 02:32:57 PM

Assuming Strings...
'Dep:Zone = ' & '''' & p_web.GSV('StoredEmployeeZone') & ''''

or maybe even...
'UPPER(CLIP(Dep:Zone)) = ' & '''' & UPPER(p_web.GSV('StoredEmployeeZone')) & ''''  !No need to clip the Session Value

Assuming Longs...
'Dep:Zone = ' & p_web.GSV('StoredEmployeeZone')

Where StoredEmployeeZone = Session value stored when user logs in.

There are better ways to construct the string filter but it works for me.

The NetTalk drop downs use Views.  Make sure Dep:Zone is in the View.

Don

Title: Re: Filter on File Drop
Post by: Richard I on April 04, 2019, 03:31:45 PM

Many thanks Don, again !!
much obliged.
Works perfectly.
So simple but so far!

Cheers
Richard

Title: Re: Filter on File Drop
Post by: Bruce on April 04, 2019, 10:14:43 PM

Hi Don,

Good answer - just one thought;

>> The NetTalk drop downs use Views.  Make sure Dep:Zone is in the View.

Fields used in _Filters_ do not need to be PROKECTED in the VIEW. While that's a fairly common Clarion myth it has no basis in fact.

cheers
Bruce

Title: Re: Filter on File Drop
Post by: DonRidley on April 05, 2019, 01:43:18 AM

Quote from: Bruce on April 04, 2019, 10:14:43 PM

Hi Don,

Good answer - just one thought;

>> The NetTalk drop downs use Views.  Make sure Dep:Zone is in the View.

Fields used in _Filters_ do not need to be PROKECTED in the VIEW. While that's a fairly common Clarion myth it has no basis in fact.

cheers
Bruce

Thanks for the reminder Bruce!  Just keeping you on your toes!  LOL