How can I delete entries from a search object without deleting the corresponding row in my datatable?

[tomka]

I’ve been trying del rows[5] but was not successful. How can I do it?

[campopianoa]

The search iterator is connected to the database rows.

If you want to decouple that object from your database, I believe you must cast the search iterator to a list of dictionaries, then you can treat it as a Python list.

Please see this recent post about casting:

DB row as dictionary

How do I cast a DB row as a dictionary? Yes, I could do it by extracting all the values and setting all the keys of a new dictionary. But I want to do something like row_dict = dict(row) since the thing is so much like a dictionary already.

For example,

# on the server
my_list=[dict(r) for r in app_tables.my_table.search()]

[tomka]

So I got an answer to my question after only 8 minutes. Amazing how helpful people around here are! Thank you, @alcampopiano !

[campopianoa]

@tomka

Amazing how helpful people around here are

I have said that myself many times. Good luck with your project.