Home > Forum > Forms > [SOLVED] Q: How to delete a row within an ItemList with a SELECT statement?

[SOLVED] Q: How to delete a row within an ItemList with a SELECT statement?
0

MVP

Hello again,

feeling a little bit like a newbie, i have another problem with ItemLists.

I am playing around building a KANBAN Board with WEBCON.
Therefore i would like to move ItemList-rows between my six ItemLists (Backlog, To-Do-List, In Progress, Test, Done, Blocked).

After copying the row information to the new ItemList, i would like to _delete_ the old row(s) e.g. on the "UPDATE"-Path. HOW can I do that?
I didn't find any information - except the "DET_IsDeleted" flag.

I'm kind of stuck - again.

Anyone out there for a little help?
Maybe there is an easier way to transfer the row data between the ItemLists?

Thanks in advance,
Bjoern

MVP
In reply to: Daniel Krüger (Cosmo Consult)

Hi Björn,

I was wondering whether you already had a solution for this, but it slipped my mind.

There's no other way than doing it with a custom SDK action.

If you want you could take this option:
https://daniels-notes.de/posts/2022/remove-item-list-rows

Best regards,
Daniel

Thank you Daniel,

your custom SDK action gave me much inspiration for two other more "unconventional" ways
to solve my problem: first try was "add new & delete old", second try was "just move".
At the moment, working only on my "test & maybe crash" WEBCON installation, i will keep the last one.

Better solution would be a WEBCON "remove row"-function. I will post a suggestion in USER VOICE,
if there is no old one already there.

For all others your custom action could/should be a solution -> so i will close this post with [SOLVED].


╱╱┏╮
╱╱┃┃
▉━╯┗━╮
▉┈┈┈┈┃
▉╮┈┈┈┃
╱╰━━━╯