Johnson Liang

Columns of join table are always selected, which breaks aggregation in PostgresSQL

43

Dialect: PostgresSql Sequelize version: 3.19.3 I have two tables that are n:m associated with a joining table. Whenever I use `.findAll` and include the other table, all fields in the...

## As-is Currently if the user does not provide slug when editing profile (for example, just changing display names), the operation will be rejected. ## To-be Change `UpdateUser` - When...

Introduce app ID management mechanism

1

Fixes part of #244 (server apps only) Spec: https://g0v.hackmd.io/51wwLHgvSUqtBDaP-yAVnA

Per [20210428 discussion](https://g0v.hackmd.io/6ZwH7NANRqG6s-CCIy9IYw?both#yegogo-%E8%99%95%E7%90%86), since we backup original reply text in the spreadsheet, we can consider removing spammer's reply text entirely. We can modify `removeArticleReply.js` so that it optionally take a...

iOS 12 devices cannot login cofacts.tw

1

No matter which domain they use, iOS 12 users are not able to login Cofacts, regardless of they logged in Cofacts in other devices before. ...

Renders open peep into data-url

1

Returns a data url for `avatarUrl` so that UI can render it in `img` or via CSS `url()` directly.

Highlight improvements

1

From [20201014](https://g0v.hackmd.io/R3TffjwOSXefZBCFPkSrqA#Chatbot-highlight-amp-matching-improvement) and [20200923](https://g0v.hackmd.io/-j-fAX0tS62amv9LejshOg#-Chatbot) discussion, ## Long snippet gets truncated out  > 因為 API 那裡可能會吐出很長的 snippet ，然後再 highlight 中間的部分，導致 highlight 的部分太後面 xD > 這個可能要在 API 上多開欄位指定預計 snippet 長度來解，有些麻煩就是了，可以記下來，未來再想想怎麼做 ##...

Use this to replace x-accept-license header. Spec: https://g0v.hackmd.io/51wwLHgvSUqtBDaP-yAVnA Should implement ASAP. [Meeting note](https://g0v.hackmd.io/JUVhhxSmSx62O5SUVuJ1rw#2-%E6%9C%88-License)

ListArticle filter & sorting fix

1

From [Profile page pilot study](https://g0v.hackmd.io/XvP4q3IkTwCDeT1zopaTQg#Usability) - Article type filter & article-reply-from-userId filter - Currently the two filters are independent - 目前是「列出 user 有回過、且有一個 reply type 符合要求的 article」 - All filters...

From [20200729](https://g0v.hackmd.io/r3NK7xssSwCNPFxthlw7tA#%E5%A4%A7%E6%9D%BE%E6%AA%A2%E8%A8%8E) Sometimes our URL scrapper will be temporarily blocked, leaving useless URL previews like [this](https://cofacts.org/article/39n5zi0t4vlci). During [20200729 discussion](https://g0v.hackmd.io/r3NK7xssSwCNPFxthlw7tA#Youtube-%E9%98%BB%E6%93%8B-metadata-scraping) we can provide an API for logged in editors to reload...