This guide shows how to test the Tables – Search Rows card.

• Okta Workflows
• Cards

1. Use the Tables – Search Rows card and pass a variable into the Where Expression field:

When testing the Search Rows card, the following will be seen:

2. The test output is not what was expected.

Modify the Where Expression JSON to perform the test.

• • The JSON for searching is:

    {
      "expr": [
        {
          "lhs": "Number",
          "op": "=",
          "join": "AND",
          "rhs": 10 
        }
      ]
    }

NOTE: The rhd was updated with rhs.

3. Testing the card with updated JSON returns a valid test outcome:

Another example searching with two fields:

• • This is the updated JSON to test the Search Rows card above:

    {
      "expr": [
        {
          "lhs": "Country",
          "op": "=",
          "join": "AND",
          "rhs": "Brazil"
        },
        {
          "lhs": "Code",
          "op": "=",
          "join": "AND",
          "rhs": "BR"
        }
      ]
    }

4. Now, testing the card produces the correct result:

Related References

• How to Iterate Over Rows in a Table in Workflows
• How to Delete Multiple Table Rows