Null, zero and empty in Search CriteriaData cells with nothing in themApparently in the database world a datafield can be 'null', 'zero', 'blank' or 'empty' and these are DIFFERENT! For the non-database orientated person the differences can lead to confusion. The classic situation is that you want to do a query via Manage-something to find the data records where a datafield is empty, blank, or not filled in. For some datafields you can put in '=isnull' into the query to return records where the datafield has no data. An example (as of April 2009) is the 'Field' datafield in Manage-Matches. There are six different special commands. They are:
The '=' sign is established in the Setting=Criteria. You can change to use a different prefix. The current prefix is = For more info see the RidgeStar Features page. Features Personal and Site CriteriaVia Administrator:Options-Criteria you can see what criteria have been set for each 'form'. csofxx is the format for site default criteria fxx is the format for individual criteria The xx have some relationship to the actual form, but it may be obscure. For example fri is the Form Referee-Inquiry It can happen when a change is made to a form that the site or personal criteria that exist no longer do what the User intended, but may actually return a completely different query Result List. Keep this in mind when changing forms - for example when a form datafield changes from pulldown to fragment. The simplest solution, is to delete all the criteria associated with the form. Or you can go in and edit the criteria for people. |