Latest unity project versions missing in OnBase database

[Alberto_Medina1]

We are trying to get all the current unity scripts by a SQL query to the corresponding table. Recently we found that the latest versions of some scripts are not in the database. Why could be the cause? Is there another table with this information? Currently, we are quering the unitysourcedata and the unityprojectinfo tables

[Tyler_Sorber · Accepted solution]

Hi Alberto

I would highly recommend contacting your first line of support if Unity Script Versions are not being displayed correctly within the Client.

[#3]

The unityprojectver table has the version info.

[Alex_French]

Are you not finding the latest Published, the current Active, or just versions that have been Saved but not Published?

What's the specific query you're doing?

[Doug_Paull]

I have a query that dumps the current "saved" version of source for all Unity Projects.  It uses these tables:

unitysrcxproject, unityprojectinfo, unitysourcedata