Michael T on Nostr: nice 👍 one thing, which might be misleading: Order by <int> ASC makes NULL first ...
nice 👍
one thing, which might be misleading:
Order by <int> ASC makes NULL first
one could assume by this snippet, that the salesChannelId is an integer, but as all IDs in Shopware, it is a string/binary
Published at
2024-04-11 07:34:33Event JSON
{
"id": "50dec29ebfb17ef764ec1e405d37087281f89ae2c30594c7edfbebd473678e0a",
"pubkey": "cd3ad7da8e0f86f89804fd45304edf82ee578acb8f21fd2206331c10a1fbc301",
"created_at": 1712820873,
"kind": 1,
"tags": [
[
"p",
"1a36ba7b3e50b237e6d807450a3e0fcb34a0906d3d31f28fcd6780e64bbab7aa"
],
[
"e",
"74a7408ded03c49be1fac39df4795584b53b714e727d29be6d4b8511483419fa",
"",
"root"
],
[
"proxy",
"https://phpc.social/users/mitelg/statuses/112251428749436987",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://phpc.social/users/mitelg/statuses/112251428749436987",
"pink.momostr"
]
],
"content": "nice 👍\none thing, which might be misleading: \n\nOrder by \u003cint\u003e ASC makes NULL first\n\none could assume by this snippet, that the salesChannelId is an integer, but as all IDs in Shopware, it is a string/binary",
"sig": "5c7c1cfdb067e51c13a425897328c10ebccfed38dfc775addc6e833b46857889ba00507caf0d50c50785b2061edb85f932e9e26146a77050a8a3a7b650b12087"
}
