Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Filtering
Options
Go to last post Go to first unread
Previous Topic Next Topic
Warwick Wood  
#1 Posted : Thursday, August 26, 2010 9:14:09 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Quick question, I cant figure out how to filter for all my boreholes that end with a particular suffix, namely A, B, C, or D.

The numbering is in sequence and the suffix differentiates between different units.

Please help.

Thanks.

hemla
Back to top
WWW

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Thursday, August 26, 2010 9:17:26 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello Hemla,

You can filter using the "Like" operator under the "Filter" tab.

Clicking "LocCode", "Like" will give the following in the filter box:

LocCode Like('%%')

You will then need to edit it as follows to get what you want:

LocCode Like('%A')

Note the % is a wildcard.  If you do a search in the help file for "Filtering" one of the topics found is "Filter SQL" which discusses wildcards and other filtering techniques in more detail.

Regards,

Warwick
Back to top
WWW
Warwick Wood  
#3 Posted : Thursday, August 26, 2010 9:21:01 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Hemla,

Further to that.

Rather than add a suffix to the location names another approach would be to populate the "Area" field in the Location Table (or "Monitoring_Zone" field in SQL Server versions).  Then you can filter a bit easier without having to worry about wildcards.

If the suffix is describing vertical variations in aquifer unit, then you are best having "A", "B" ... as a WellCode in the Wells table.  Then you have only one location (ie BH01) which identifies the common attributes (co-ordinates, geology, borehole construction etc..), and each screened interval is identified by it's WellCode.  This is less important if there is only one well installed in each borehole. 

Regards,

Warwick

Edited by moderator Thursday, August 26, 2010 9:25:04 PM(UTC)  | Reason: Not specified
Back to top
WWW
Similar Topics
Filtering standards for specific chemcodes (ESdat)
by DeclanF 7/30/2024 1:23:58 PM(UTC)
Filtering out different units for same analyte (ESdat)
by JackP 6/21/2023 10:42:53 AM(UTC)
Filtering in Data View - filter within filter? (ESdat)
by paige_spurgeon 2/28/2023 1:05:46 AM(UTC)
Chemistry table filtering options (ESdat)
by YlianeYG2 2/28/2022 9:57:10 AM(UTC)
Filtering non detect results (ESdat)
by Unknown 8/28/2018 1:03:11 PM(UTC)
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET