How do you make a app to use the third environment?

[David_Zhong]

Hi all

I have an app that I want to use the new environment, but there is no way for me to use because it said “disabled” see attachment

I tidied up all old queries but still don’t let me use that local one. please help….

[pyrrho]

Hello @David_Zhong,

IIRC, this issue is due to the resources in the app not all having the environment created in their settings.

For example, if you are using a SQL DB Resource, and in the resource configuration you have not added a setup for your new environment (below):

then any App using that resource will not be able to switch to that environment. Above, even though I have a ‘staging’ environment, any app/workflow using this resource will have the 'staging’ environment disabled.

[David_Zhong]

Thanks for replying @pyrrho

I am pretty sure about all queries that don’t have the environment are deleted.

Are there efficient ways to check all queries environment?

[MiguelOrtiz]

Hey @David_Zhong,

You don't really need to check all of your queries, you need to check all of your resources, including Retool AI, which needs to be enabled for all of your environments:

[David_Zhong]

It turned out I can use Retool AI and found out about one query that is not being used but still there didn’t have the enabled new environment!