Dataview Query with Tasks

Help
1

What Iā€™m trying to do

Can someone tell me why my Dataview query still shows completed tasks?

Blockquote

TABLE WITHOUT ID
	split(split(split(split(split(split(split(split(split(split(split(split(split(split(Tasks.text,
		 "āž•", 1)[0],
		 "ā³", 1)[0],
		 "šŸ›«", 1)[0],
		 "šŸ“…", 1)[0],
		 "āœ…", 1)[0],
		 "āŒ", 1)[0],
		 "ā¬", 1)[0],
		 "šŸ”½", 1)[0],
		 "šŸ”¼", 1)[0],
		 "ā«", 1)[0],
		 "šŸ”ŗ", 1)[0],
		 "šŸ”", 1)[0],
		 "šŸ†”", 1)[0],
		 "ā›”", 1)[0] AS Task, 
	choice(contains(Tasks.text, "šŸ”ŗ"), "šŸ”ŗ",
	choice(contains(Tasks.text, "ā«"), "ā«",
	choice(contains(Tasks.text, "šŸ”¼"), "šŸ”¼",
	choice(contains(Tasks.text, "šŸ”½"), "šŸ”½",
	choice(contains(Tasks.text, "ā¬"), "ā¬",""))))) AS "Priority",
	choice(contains(Tasks.text, "šŸ”"), "šŸ”", "") AS "Recur",
	default(object(
	    " ", "ā¹",
	    "/", "āŗ",
	    "-", "āŒ", 
	    "x", "āœ…",
	    "I", "āÆ",
	    "i", "ā„¹ļø",
	    "b", "šŸ”–",
	    "<", "šŸ“…")[Tasks.status], "ā“") AS "Status",
	dateformat(Tasks.created, "yyyy-MM-dd EEE") AS "Added",
	dateformat(Tasks.due, "yyyy-MM-dd EEE") AS "Due",
	dateformat(Tasks.completion, "yyyy-MM-dd EEE") AS "Done",
	Tasks.due - date(today) AS "Countdown",
	company AS "Company",
	link(Tasks.section, "šŸ”—") AS "Link"
FROM "Work"
WHERE text !="" AND Tasks.text !="- [x]" OR !completed OR !checked
FLATTEN file.tasks AS Tasks
SORT default(Tasks.due, "") ASC
2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.