Skip to main content
AK_109957676-Contributor
6-Contributor
April 9, 2025
Solved

Windchill BLOB Data - Stream Data Table analysis

Version: Windchill 12.1

 

Use Case: Analysis of Stream data


Description:

Analysing the stream data - count of object types per organization

Shreyas_AtreAnswer
12-Amethyst
April 9, 2025

If you are looking to count how many objects from each organization are stored in blobs (in stream data), you need to build a query using the application data table.

Below is a sample query that will give you the object types stored in the blob table. Please join the holdertoContent  table to WTDocument, EPMDocument, and other objects as necessary:

SELECT hc.CLASSNAMEKEYROLEAOBJECTREF, COUNT(1)
FROM ApplicationData a, holdertoContent hc
WHERE hc.IDA3b5 = a.ida2a2
AND a.classnamekeya5 = 'wt.content.StreamData'
GROUP BY hc.CLASSNAMEKEYROLEAOBJECTREF;

Hope this helps 
Thanks

View in thread

5 replies

Catalina
CatalinaCommunity Manager
Community Moderator
April 9, 2025

Hi @AK_10995767 

 

Thank you for your question! 

 

I’d like to recommend to bring more details and context to your initial inquiry. For example:

  • Which specific object types are you interested in counting?
  • Are there particular organizations you want to analyze, or should the analysis include all organizations?
  • Is the stream data currently in BLOB format, or has it been converted to a different format?

Please add screenshot(s) to better understand what you are trying to do in your process. 

 

Please refer to this guideline to make your questions more likely to receive a quick and useful answer. 

This will increase your chances to receive meaningful help from other Community members. 

 

What is a good question? 

Windchill 

 

Thank you for your participation and please let me know if you need further assistance! 

 

Best regards,

Translate
Catalina | PTC Community Moderator
avillanueva
avillanueva23-Emerald II
23-Emerald II
April 9, 2025

Normally, settings are set to force content to vaults. Its not recommended to store files in BLOBs. Do you think that is your case, the file data is ending up in BLOBS. You should be able to change your vaulting rules and move that content out. Can you elaborate on your question?

Some links:

https://www.ptc.com/en/support/article/CS37197

https://www.ptc.com/en/support/article/CS371703?source=search

 

Translate
    Shreyas_Atre12-AmethystAnswer
    12-Amethyst
    April 9, 2025

    If you are looking to count how many objects from each organization are stored in blobs (in stream data), you need to build a query using the application data table.

    Below is a sample query that will give you the object types stored in the blob table. Please join the holdertoContent  table to WTDocument, EPMDocument, and other objects as necessary:

    SELECT hc.CLASSNAMEKEYROLEAOBJECTREF, COUNT(1)
FROM ApplicationData a, holdertoContent hc
WHERE hc.IDA3b5 = a.ida2a2
AND a.classnamekeya5 = 'wt.content.StreamData'
GROUP BY hc.CLASSNAMEKEYROLEAOBJECTREF;

    Hope this helps 
    Thanks

    Translate
      AK_109957676-ContributorAuthor
      6-Contributor
      April 9, 2025

      @Shreyas_Atre Thanks for the solution.
      Can you please let me know based on which identifier I can join holdertoContent  table to WTDocument, EPMDocument, and other table?

      Translate
      avillanueva
      avillanueva23-Emerald II
      23-Emerald II
      April 9, 2025

      Hc.IDA3A5 joins to IDA2A2 of either WTDocument or EPMDocument

      Translate
        Terms & ConditionsAccessibility statement