Waymarking et Benchmarks

Liens

Pour les usagers de GSAK

Code pour filtre “Where” à ajouter dans la fenêtre:

filtrewhere

Exemples:

1- Afficher Waymarks non trouvés (Sans les Canadian Beanchmarks)

CacheType = 'Y'
and Found = 0
and OwnerName <> "Canadian Benchmarks"

2- Afficher Waymarks non trouvés (Sans les Subway Restaurants et les McDonald’s Restaurants)

CacheType = 'Y'
and Found = 0 
and OwnerName <> "Subway Restaurants"
and OwnerName <> "McDonald's Restaurants"

3- Afficher Waymarks non trouvés (Seulement les Subway Restaurants)

CacheType = 'Y'
and Found = 0
and OwnerName = "Subway Restaurants"

4- Affiche Waymarks non trouvés (Seulement Subway Restaurants et McDonald’s Restaurants)

CacheType = 'Y'
and Found = 0 
and OwnerName in ("Subway Restaurants","McDonald's Restaurants" )

5- Afficher Waymarks non trouvés (Sans les Canadian Benchmarks, les Subway Restaurants et les McDonald’s Restaurants)

CacheType = 'Y'
and Found = 0 
and OwnerName not in ("Canadian Benchmarks","Subway Restaurants","McDonald's Restaurants" )

6- Afficher Waymarks types non trouvés

CacheType='Y' AND NOT Found
AND OwnerName NOT IN (SELECT DISTINCT OwnerName FROM Caches WHERE FOUND AND CacheType='Y')