Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 11-23-2007, 03:30 PM   #1 (permalink)
Junior Member

mitchgibbs's Avatar

Join Date: Oct 2006
Location: Chicago
Posts: 20
Rep Power: 0 mitchgibbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Question Sort key not working?

Hi all-

It seems like the backslash functionality of the Sort Key in Query is not working on our system (RE 7.81). When I sort organizations with names starting with The, they are sorted by that word. For pretty much all of our records like that, we've got a backslash to change the sort criteria (e.g. The\Hutchinson Foundation).

Is it just us? Any ideas?

Thanks,

Mitch
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 11-23-2007, 04:47 PM   #2 (permalink)
RDC:RE Guy

mwittman's Avatar

Join Date: Sep 2007
Posts: 158
Rep Power: 2 mwittman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)

Quote:
Originally Posted by mitchgibbs View Post
Hi all-

It seems like the backslash functionality of the Sort Key in Query is not working on our system (RE 7.81). When I sort organizations with names starting with The, they are sorted by that word. For pretty much all of our records like that, we've got a backslash to change the sort criteria (e.g. TheHutchinson Foundation).

Is it just us? Any ideas?

Thanks,

Mitch

We're on RE Version 7.81.1334.12, and the funny thing is I thought the sort key mechanism was broken too because it didn't work during a live training session I was conducting (yikes!), but I re-checked just now and it seems to work as advertised IN QUERY. However, in the Find Constituent interface, there is mixed results regarding order depending on the substring you use for the search criteria (try different combos with wildcard "*" -- it's good fun

During the live session, I may have tried entering forward-slash instead of back-slash, so I can't say for sure it wasn't working even on that occasion.
__________________
Micah Wittman

WORK

Database Coordinator
Red Deer College
blackbus4.m.wittman@xoxy.net

PERSONAL

http://bebepool.com
http://hmatters.com

Last edited by mwittman; 11-23-2007 at 04:47 PM. Reason: Fixed typo
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
query, sort, sort key


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Electricity - Renegade motorhomes - Mobile Phones - Credit Counseling
All times are GMT -6. The time now is 06:34 PM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70