- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
What filing identifier/routine (tab_filing) can we use to properly sort new IND index when field contains non-numeric followed by numeric characters? We want to search the GUI using this string: ssj###
We'd like them to sort in this order:
We defined new field and IND index: SSJ. Seeing that other numerical IND indexes use filing identifier 21, we tried using it. But searching in GUI by "ssj666" resulted in a display that sorts as if the numeric portion is decimal.
You need the numeric portion to be treated as a whole number. Two filing routines do that: lc_call_no and expand_num.
lc_call_no may not work with more than two alpha characters at the beginning. And handles only 4 numbers. Article "*lc_call_no* tab_filing routine *MASTER RECORD*" KB 16384-10097 discusses it.
expand_num is likely to work better. It files these like this:
- Article last edited: 12-Mar-2016