JoeLitton.net | View categories and case sensitivity
PermaLinkView categories and case sensitivity
posted Wednesday 16th, June 2004
 



17 June 2004 Follow-up: Many thanks to Dan Soares at Stony Brook University for pointing out that the issue I mentioned below is easily addressed by simply selecting the view column option for 'Case sensitive sorting'. Thanks Dan!

If you change the value of a categorized field, changing only the case of the letters, the displayed category in views will not change. So far I have only tested this in ND6. It appears to be similar to SPR # GCUN5ECLRD, which reports that one cannot rename a folder (using the shortcut menu after right-clicking on the folder) - if one is trying to simply change the case of the folder name.

Regarding the view category, here's the scenario: I provide a function to allow a user to change the value of a categorized field. The button is used to, for example, change a value of 'Abc' to now be 'ABC'. The documents are all changed, but the view still displays the old 'Abc' in the category. The only solution I've found so far is to first change the field value to something that includes at least one additional or different letter, like 'ABCz', and then to change the field value to the desired value of 'ABC'. Similarly the SPR referenced above suggests workaround of renaming the folder to something completely different, and then setting it to what one really wants.

At least this time the issue doesn't appear to be my own goofy blunder, but I do wish I could provide a cleaner solution. The only thing I've come up with so far is possibly putting code in the button to capture the desired new field value, set the field to that value plus something bogus like 'z~z', and then set the field to the REAL new value. Man, that's goofy!
Comments :
 
 

1. Posted by Dan09/09/2007 08:42 PM



Joe,

I tested the scenario you mentioned and was able to use an action in a view to change a field value ( to uppercase) which was being used as the category in a view.

As long as the column in that view was set to "case sensitive sorting", I was able to get the category to change when the case changed.

WIll send you the database if you like. Was using R6.5.1

Dan
Daniel.Soares@stonybrook.edu




2. Posted by Joe Litton - website09/09/2007 08:42 PM



Hey Dan, Thanks for pointing out what is probably a REAL easy fix. Man, I *never* have even looked at that setting (OK, I've seen it, but I've never done anything with it) -- never had a reason to. In fact, I had always found the case INsensitive sorting to be rather handy. I'll give this a shot tomorrow.




3. Posted by Joe Litton - website09/09/2007 08:42 PM



Yup Dan, that was it! I'll post a more obvious mention of this later from home, but THANKS for letting me know. My code solution was working, but this is FAR simpler!