nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpq57fwuf3lsqyv35ed8yccw3yzysvl3xmwapzjgpv0chjk2502vxnsc8ajvy (nprofile…ajvy) Sorry, one more clarification: I can get the user's results for a given standard no problem. I'm struggling with getting them for _all_ assignments attached to a standard (the outer join). I'd like a None returned if it doesn't exist.
Maybe a subquery and then joining on that list of items for a given standard?
Brian :cupofcoffee: :rss:
npub1rk…cfcdy
2026-02-27 21:36:47 UTC
in reply to nevent1q…tz63
Author Public Key
npub1rkr8tvf8udyuu5qwnrynpmfuw84gnydptrtgczywjfuu7kya3aesucfcdySeen on
wss://relay.mostr.pubPublished at
2026-02-27 21:36:47 UTCEvent JSON
{
"id": "4cc12f547c076b649cd411138b486c05e2378dc5723e011c0027bd661a22ad20",
"pubkey": "1d8675b127e349ce500e98c930ed3c71ea8991a158d68c088e9279cf589d8f73",
"created_at": 1772228207,
"kind": 1,
"tags": [
[
"p",
"a792ee263f8008c8d32d39318744822419f89b6ee84524058fc5e56551ea61a7",
"wss://relay.ditto.pub"
],
[
"p",
"00147331ebc0445a37cf524ceb865dda48a92494e5d7dc144db5bcdf43c8cd01",
"wss://relay.ditto.pub"
],
[
"e",
"72d2534ade2965f7d7029e7f6f5917ce7bbe01b610b3a8d161e09c309a28d3f2",
"wss://relay.ditto.pub",
"reply"
],
[
"proxy",
"https://fosstodon.org/users/brianb/statuses/116144747780951558",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpq57fwuf3lsqyv35ed8yccw3yzysvl3xmwapzjgpv0chjk2502vxnsc8ajvy Sorry, one more clarification: I can get the user's results for a given standard no problem. I'm struggling with getting them for _all_ assignments attached to a standard (the outer join). I'd like a None returned if it doesn't exist. \n\nMaybe a subquery and then joining on that list of items for a given standard?",
"sig": "8791bcf9258d8b26f9318fd34c9a6e37ae28eeafd82b85564f0ef27be5b942c63aa336fc2dbf932c6267c3d811c03c5f20a07048c1c0d8201456efe440c5775d"
}