Re: Kanban vertical sorting

I know this is an old post, but since I found a new solution I thought I would share.

when you enable sortable kanban on a table, a hidden field is added to that table. The hidden field is called "KanbanPriorityOrder", and the order is saved in this hidden field as a number.
Unfortunately since it is hidden, you cannot order reports on this field, so we have to copy it to a newly created field.

my solution requires 2 main steps.
1. adding a new numeric field to a table (eg. kanban-sort-copy) , (I manually set all existing records to value of 1000)
2. using a webhook to copy the kanban sorting order into this field, whenever sort order is changed.

I will only talk about step 2

here is my webhook (API_EditRecord)
<qdbapi>
<udata>mydata</udata>
<usertoken>%user.token.xxx_xxx_xxxx.testingJohnny%</usertoken>
<apptoken>[xxxxxxxxxxxxxxxxx]</apptoken>
%RepeatOn%
<rid>[Record ID#]</rid>
<field fid="77">[KanbanPriorityOrder]</field>
%RepeatOff%
</qdbapi>

I manually typed in the [KanbanPriorityOrder] after I found it's name using the restful API (it does not show up in the dropdown of fields)
field 77 is my new numeric field that I created.
this webhook looks for all updated records and then copies the kanbanPriorityOrder to the new field.

Now I just sort reports using my new field.
so far it is working well for me.

------------------------------
Johnny Niumata
------------------------------