I have a user that is trying to search for a range of records, for example 400/15 - 500/15. However when the results are returned. It should anything beginning with a 4, like for 4, 40, 4000. I used the range search for Record numbers. IS this not the correct way to conduct this type of range of records. The first attachment is the example of the results. I have attached a couple of screens. Thanks.
We tried that also didn't seem to work. It also seems to mess up on the number after slash. ( for example /15) also brings crazy returns. But I have more intel now. The user was searching under a reel#, I think its an additional field type. Any other suggestion. I have attached anothe example with the Reel# Thanks so much.
No that didn't work. It's a pretty small dataset. I also tried to add single and double quotes on two sets of number ranges, that didn't work either. I have searched Help menu and can't find exactly what I want on search ranges. Any other suggestion. Thanks.
Yes, there are records in that range, only its pulling single digits, double digits etc, 4, 40, 400, 500 Any number in those ranges. Then the second number after the slash is crazy too. Its almost like its saying I will look for 4 in any format, I can find. We recently upgraded to RM 8.1, do you think indexing would help? Just trying to think of something. Thanks.