Change a certain field of all items from DB that matches a certain condition

Need help Database
1

Hi, I’m trying to change a certain field of all items from DB that matches a certain condition every 5 seconds.

I’m making a SNS so I say it like it is twitter

like If your tweet have gotten more than 10 likes, I would like to change a certain field of the tweet.

I would like to do it as Backend workflow, (If it’s impossible, then normal workflow is fine)

but I can’t figure out how to do it. please help

2

Hello,
In my opinion, you have two ways to do this:

  1. Add a field to the ‘Tweet’ data type to store the number of likes.
    Each time a tweet is liked, update this field (using a “Do a search for” on the Like data type).
    Then, in your “Make changes to a list of things” action, filter the tweets using this field (e.g., likes_count ≥ 10).

  2. Use an advanced filter directly in your search, with a constraint like:
    Search for Tweets:filtered (Advanced: Search for Likes:count ≥ 10).

3

so, this is a normal workflow, not a backend workflow.
is there no way to do it as backend?

4

The method is the same but you can just use the workflow backend to run it

5

OK I think I figured it out, thank you so much!