Is there an equivalent to SQL sys views in AppFarm?

Ask the community
1

Hey there,

We are trying to set up generic actions for tasks that are similar. For instance, we’d like to have an action that

  1. Removes data from all runtime data sources.
  2. Closes current dialog.

This is fairly easy to set up, obviously. In an action, we just add a whole bunch of “Delete objects” tasks, one for each runtime source. However, this is not as dynamic as I would have liked.

In SQL, I would have used the sys views (e.g., sys.tables) to get information about all tables, and then run a loop over these tables. So if new tables are added, the process would automatically include the new tables.

Is there a way to do something similar in AppFarm?

Regards,
Mikkel

2

Hi Mikkel,

There is currently no way to do this in Create, meaning you must set up action nodes for all the data sources you want to delete, as you mentioned.

3

Hey Isabel,

Thank you for the answer! The manual solution will work quite well, I’m sure.

Any chance you could jot down this as a wish from a user? To have something equivalent to the sys views available in actions (or as standard object classes)?

4

Hi Mikkel,

I will register your wish :+1:

5

Thanks! Can’t ask for more :smile:

1 Like