RISCm Filter Guide (With Images)

Documentation and tutorials on RISCm

RISCm Filter Guide (With Images)

Postby Nathan » Fri Mar 28, 2014 1:13 pm

RISCm’s filter mode provides several special operators that when used in combination can articulate the most sophisticated search parameters. This guide will provide a visual representation of these operators in use. It is recommended that you pair this guide with the list of operators we have provided in another forum post: http://stratcorrman.com/forum/viewtopic.php?f=11&t=7.

The RISCm filter mode can be opened by selecting “Filter” from the top menu in the software. You can view a screenshot of the entire RISCm filter here: http://www.stratcorrman.com/images/full_filter_shot.png

With the filter open, you can try out the following examples.

Operator: || (OR)
The || operator is used to implement a logical OR for two or more search conditions in the same data provider. For example, if we want to set up a search to display data for only records that hold SCFM 4 or SCFM 6, we would enter 4||6 in the Scfm field. This will return only records that contain either SCFM 4 or SCFM 6.

Operator: | (Format)
Unlike the OR operator, the Format operator is just a single pipe. We use Format to separate a value with an implied format. For example, if we want to view a date in MM/DD/YYYY format, we could search for 01/01/2001|MM/DD/YYYY. Similarly, if we want to view the date in a DD/MM/YYYY format, we would enter 01/01/2001|DD/MM/YYYY.

Operator: ! (Not)
The ! operator is used to implement a logical NOT clause. This is one of the most commonly used operators, and is very powerful for excluding unwanted data returns. If we wish to view every single record except those where the Surface Type is a Tank, we would enter !1 into the Surface Type field.

Operator: # (Sensitivity Modifier)
This operator implies a case-insensitive search for text columns. This means you can search ToLEdo to return records that contain the word “Toledo” in any case format. In addition, # can be used to match an entire day for date columns. Entering #01/01/2001|MM/DD/YYYY into the Last Insp. Field will return records for the entire day (regardless of time) of 01/01/2001 in a MM/DD/YYYY format.

Operator: ^ (Is Null)
The ^ operator allows you to search for records where a field is empty (null). Quite simply, if we want to find all records that have no Remark Codes assigned, we would enter ^ into the Remarks field.

Operator: ^= (Is Null, Empty or Zero)
Unlike the Is Null (^) operator, ^= will also return data with a value of 0 as well as null. Searching for SCFM: ^= will return everything with either no data or a 0 in the SCFM section.

Operator: < (Less Than)
If you’re familiar with mathematics, you’ll be familiar with a few of these styles of operators. The less than symbol ( < ) is commonly used, and will return records where a field is less than a specified value. For example, if we wish to search for records where the Extent is anything below but not equal to 10, we would search Extent: <10

Operator: <= (Less Than or Equal To)
By appending an = to our less than sign, we can transform our search operation to include an “also equal to” clause. Filtering by <10 on extent served us well to return anything with an extent less than 10, but it didn’t include 10 in the search. When we alter our criteria to <=10, the search will return records with an extent less than 10 but also including 10.

Operator: > (Greater Than)
The opposite of less than ( < ) is the greater than ( > ) operator. This will filter the data by returning records where the value of the field is more than your operand. For example, we can search for all records that have a measured area that is more than, but not equal to, 3 by entering >3 in the Measured Area field.

Operator: >= (Greater Than or Equal To)
Just like including an = symbol to our less than operator, we can do the same for our greater than operator. We can filter the Last Maint. dates to return records only when the date is greater than or is equal to the value we choose. For example: >=01/01/2001 will return everything entered on and after 01/01/2001.

Operator: … (Between)
The between operator will allow us to search for records where the data values are between, and including, two operands. 2…7 is between 2 and 7, inclusive of 2 and 7. This is most useful when we wish to search for things like SCFM values: SCFM 3…8 returns data with SCFM between 3 and 8, including 3 and 8.

Operator: % (Wild Card String)
The % operator is not a percentage or modulus symbol, it actually matches records based on a wild card. For example, if you want to find all records with a Service Code that begins with a B you can enter B% in the service code field. Similarly, if you want to view service codes that contain a specific character anywhere in the string of data, you can place the operator on both sides of the character: %D% will find all service codes that contain the letter D at any point in the field.

Operator: _ (Wild Card Character)
The underscore ( _ ) operator essentially fills in a blank between two points. The filter will return data with a match on the two points specified and any characters that appear in between. For example, you can search To___o to find a return of Toledo.

Operator: \ (Escape Character)
The back slash ( \ ) is used to escape characters and operators in a search query. If you were to search for 20 per cent, you would have to use the % symbol (20%) – but we know from our previous guide entries that the % symbol is actually used as a wildcard operator. In this case, you would need to escape the % symbol with a back slash like so: 20\%. This will return 20% as per cent rather than a wild card operator.

Operator: now
The word “now” is actually an operator which matches records where the condition is right now, including time. It’s not often used, but is available for the rare occasion is may be needed. If you were to enter now in the Date Applied field, it would only return data that has the date and time of right now.

Operator: today
Like the now operator, today will return data that has a date set to today’s date but exclude the time. This is more commonly used than the now operator as it returns all data for today’s date excluding the time of day. For example; Date Applied: today.
Nathan King
Software Developer & IT Engineer

Strategic Corrosion Management
Site Admin
Posts: 12
Joined: Fri Nov 15, 2013 10:13 am
Location: United Kingdom

Re: RISCm Filter Guide (With Images)

Postby Brian Madsen » Wed Oct 15, 2014 5:04 pm

Hi Nathan.

To me it seems like the pictures are not loading.
Brian Madsen
Posts: 1
Joined: Thu Feb 27, 2014 2:00 pm

Return to Guides & How to's

Who is online

Users browsing this forum: No registered users and 1 guest