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].


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

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings