Welcome to the Jazz Community Forum
What is triggering execution of specific SQL statement against RTC backen db?

Hi,
I see the following SQL statement being executed several times a day on the RTC backend db. What is the action that triggers this SQL statement to run? Is it a user accessing specific source code in their RTC Project?
SELECT SEQUENCE_COL, STORED_SIZE, EXPANDED_SIZE, STORAGE_METHOD, DELTA_PREDECESSOR, CONTENT_BYTES FROM SCM.CONTENT WHERE HASH_CODE = ? ORDER BY SEQUENCE_COL ASC
I see the following SQL statement being executed several times a day on the RTC backend db. What is the action that triggers this SQL statement to run? Is it a user accessing specific source code in their RTC Project?
SELECT SEQUENCE_COL, STORED_SIZE, EXPANDED_SIZE, STORAGE_METHOD, DELTA_PREDECESSOR, CONTENT_BYTES FROM SCM.CONTENT WHERE HASH_CODE = ? ORDER BY SEQUENCE_COL ASC
One answer

This is the query used by the server to fetch content from the db.
User actions that retrieve file contents from the server would hit this: loading workspaces, accepting changesets into a loaded workspace, doing compares, etc.
I don't think a user accessing specific source code in their RTC project would necessarily trigger this since the user should have the content locally in their sandbox.
User actions that retrieve file contents from the server would hit this: loading workspaces, accepting changesets into a loaded workspace, doing compares, etc.
I don't think a user accessing specific source code in their RTC project would necessarily trigger this since the user should have the content locally in their sandbox.