Knud Möller knudmoeller

Perform OR queries for categories on Microsoft Outlook for Mac

Bizarrely, one cannot make OR queries in Microsoft Outlook for Mac, at least not easily. For example, I want a smart folder that contains all messages tagged with either the FIS Broker category or the Dubletten category.

The way to do it non-easily is to select Raw Query as the query rule type (in Search > Advanced), and then enter a Spotlight query string. The attribute to query for categories is com_microsoft_outlook_categories. That attribute takes a numeric id - but what the hell is the id for a category like FIS Broker? Outlook doesn't tell me, so I have to go even deeper down the rabbit hole. Here is how:

	from ckanapi import RemoteCKAN
	import os

	# require ckanapi: https://github.com/ckan/ckanapi

	package_names = [
	"versickerung-aus-niederschlagen-2017-umweltatlas-wfs-beb56dfa",
	"versickerung-aus-niederschlagen-ohne-versiegelung-2017-umweltatlas-wfs-e4a931f6",
	"versiegelung-2005-unkorrigierte-versiegelungsgrade-rasterdaten-atom-451f714b",
	"versiegelung-2011-unkorrigierte-versiegelungsgrade-rasterdaten-atom-c973b948",

	#!/bin/bash

	# The CKAN Action-API endpoint:
	DATENREGISTER_API_BASE="https://datenregister.berlin.de/api/3/action/"

	# Query filtering datasets that came in through the FIS-Broker harvester
	QUERY="berlin_source:harvest-fisbroker"

	# date_updated refers to the when the data (not the metadata) was updated last
	SORT="date_updated+desc"

	<?php

	function parseMarkdownLink(string $link) {
	$pattern = "/^\[(.+?)\]\((.*?)\)$/";
	if (preg_match($pattern, $link, $matches)) {
	return [
	"label" => $matches[1] ,
	"link" => $matches[2]
	];
	}

	require 'cgi'

	filename = ARGV[0]
	File.open(filename).each { \|line\| puts CGI.unescape(line) }