CM9.2 Searching for Records
I am trying to search for a particular record which I am able to see, but when I try to locate it using the Search Records and use the 'NOT' search, the record isnt being returned - see attached.
If I search for the record without the NOT it is returned fine, so its just when I use the NOT feature it doesnt like it.
Any ideas why?
Maybe I misinterpret what you are trying to do here but it would seem you have structured a search to exclude the file you are looking for.
Maybe I misinterpret what you are trying to do here but it would seem you have structured a search to exclude the file you are looking for?
We have a certain criteria for filing records. The CareWorks numbers should be 7 digits in length so we want a seach for numbers that are less/more than the 7 digits thus using the NOT search.
For instansts...if a careworks number is NOT between 1000000 and 9999999 we want it to return in the search.
The problem is that the Careworks number is in a string field. so I do not think you can do what you want to do. For example when comparing strings 10000 < 2 and 9637 > 96355.
I will double check to see if there some super smart way to treat strings as numbers but I am not hopeful. You may end up having to resort to writing some code to use a brute force approach, for example using powershell.
I double checked and there is no magic to treat a string as a number, or to search based on string length. Either the field needs to be replaced with a numeric field or you will need to write some code. It may be possible to do a SQL query on the database to find what you need...
There are two things you can look at.
1) Check existing numbers by exporting the meanings and record numbers to a CSV and use excel to identify them
2) Prevent this from happening again toy can place a mask on the field that will force the user to always enter 7 digits
I hope that helps
EDRM Consultancy bv