Home » Software Development » How to Delete Multiple Table Rows

About Max Katz

How to Delete Multiple Table Rows

Okta Workflows how-to guides are questions and answers from weekly community office hours, MacAdmins Workflows Slack channel, and other places. Read all previous how-to guides

On to the question. 

How to delete multiple table rows?

A Workflows table provides fast-short term storage for flows. Check out Workflows Tips #20: How to Manage Tables for Fast Short-Term Storage to learn when to use tables.

In this guide you will learn how to delete multiple rows.

You have a table that holds positive and negative numbers. You want to delete all rows with a negative number.

Workflows table

The solution has two flows:

  1. A flow to find all rows to delete (with negative numbers)
  2. A helper flow to delete each row

The main flow searches for rows with negative numbers and passes each row to a helper flow for deletion:

Searching table rows

The flow has the following cards:

  • Tables – Search Rows finds all the rows with negative numbers
  • A list of rows with negative number is passed to List – For Each. For Each calls a helper flow ([Helper] Delete row) for each item passing its Row ID

The Tables – Search Rows options view:

Search Rows options

Search criteria (to change it click on Change link – see above screenshot):

Searching table criteria

To pass a row ID to the helper flow, click the down arrow for Row ID field and choose Item > Row ID:

Setting helper flow input

The helper flow deletes each row by its Row ID:

Delete a table row

After the flow is run all rows with negative numbers are deleted:

After deleting rows with negative numbers

In this short how-to guide you learned how to delete multiple table rows.

Published on Java Code Geeks with permission by Max Katz , partner at our JCG program. See the original article here: How to Delete Multiple Table Rows

Opinions expressed by Java Code Geeks contributors are their own.

Do you want to know how to develop your skillset to become a Java Rockstar?

Subscribe to our newsletter to start Rocking right now!

To get you started we give you our best selling eBooks for FREE!

 

1. JPA Mini Book

2. JVM Troubleshooting Guide

3. JUnit Tutorial for Unit Testing

4. Java Annotations Tutorial

5. Java Interview Questions

6. Spring Interview Questions

7. Android UI Design

 

and many more ....

 

Receive Java & Developer job alerts in your Area

I have read and agree to the terms & conditions

 

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments