Topic Options
#36176 - 03/20/13 12:07 PM Gridview Query Help Please
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
I need a query in my filter to enter the {Category}. Can anyone help?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#36177 - 03/20/13 12:13 PM Re: Gridview Query Help Please [Re: SusanTennier]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Whoa, I think I got it.

Right({Category},3) =Right(QueryString("Enter RCA,RCB,RCM,RCN,RCO,RCP,RCQ,RCS", ""),3)

Sometimes I amaze myself!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#36205 - 03/21/13 01:53 PM Re: Gridview Query Help Please [Re: SusanTennier]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Well done!

FYI, you shouldn't need the RIGHT function on either side, as categories can only be 3 characters maximum.

Another way you could choose to tackle this is to create an additional view based on the Category code list (just the code and description), and link this to the view you are working on. You can put a filter on the Category list view to limit the list to just the 8 codes you indicated, and thus the user of the GV workspace can pick one (or more) categories to perform the link selection.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 78 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14448 Topics
70593 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30