Opportunities are gone from Workspace
I cannot find Opportunities in my workspace. It is an active object.

13 Replies
And this is the Workspace:

Hello @Martin, are you self hosting or using the cloud service ?
Cloud Service
I've sent you a friend request, could you please dm your email ?
I am also having the same issue on self-hosted version
Hello @sangwan, this bug has been introduced following the opportunities indexed default view deletion, we haven't been able to isolate the root cause of this deletion
To fix the issue you need to create a new default view for the opportunity object metadata
What you ca do is:
- go to
/objects/opportunities
- Create a new view call it All opportunities
( does not really matter )
- Retrieve the created view id
- Add the created view to favorite
- In dabatase in your workspace_schema
update the key
col of the created view to INDEX
- Finally still in your workspace_schema
find the favorite
that contains your created viewId
and set forWorkspaceMemberId
to null
You should be good to go
I am getting an error
error: error: column property.sqftch3Id does not exist
Hello @Atul in what way is this related to this help thread ?
Have you encountered this error while following the messag above ?
Hi @prastoin ,
The data that we have entered is available in the database as tables as well as in the Data Model as objects. However, we can't see it in the side menu. Please look at screenshots once


Here is the error that we are getting when we login and screenshot of the side menu where only one object is visible.


Also, at one time, only one object is visible and when we use and change the URL, then we can access another object
Hello @Atul seems like to be an other error, you're missing a migration
Please create a dedicated help thread so we can follow your issue