Not Considering

Look for the status of TMs in the SQL database directly

Dear All,

We would like to filter/sort our TMs based on their status - the little flag icon next to the TM. Now this field/attribute can't be found in the Freeform SQL query. We thought it might be possible to get this attribute directly from the DB with SQL queries. Did anyone try this already? Where should we look for it in the DB?

Thanks!

Bence Bokor
Parents

  • Did you check for the status Values in the tmTranslationsId table?

    SELECT TOP 1000 [tmTranslationId]
          ,[tmAssetId]
          ,[languagePairId]
          ,[status]
          ,[sourceVC]
          ,[targetVC]
            FROM [WSDBName].[dbo].[zTM[Multiple-Digits-Number]_TRANSLATIONS]

    My test system has too many TMs for me being able to quickly check and compare but those seem to be a likely candidate for the status value you are looking for.

Comment

  • Did you check for the status Values in the tmTranslationsId table?

    SELECT TOP 1000 [tmTranslationId]
          ,[tmAssetId]
          ,[languagePairId]
          ,[status]
          ,[sourceVC]
          ,[targetVC]
            FROM [WSDBName].[dbo].[zTM[Multiple-Digits-Number]_TRANSLATIONS]

    My test system has too many TMs for me being able to quickly check and compare but those seem to be a likely candidate for the status value you are looking for.

Children
No Data