Useful SQL statements

Rhythmyx Technical Discussion
1

Hi,

I’ve found the following SQL useful to figure out what is going on in Rhythmyx 6.5.2:

[ul]
[li]To list all snippet templates by the slots that use them:
[/li]

SELECT RXSLOTCONTENT.SLOTID, RXSLOTTYPE.SLOTNAME, RXSLOTCONTENT.CONTENTTYPEID, CONTENTTYPES.CONTENTTYPENAME, RXSLOTCONTENT.VARIANTID AS TEMPLATE_ID, PSX_TEMPLATE.NAME AS TEMPLATE_NAME
FROM RXSLOTTYPE 
INNER JOIN RXSLOTCONTENT
ON RXSLOTTYPE.SLOTID = RXSLOTCONTENT.SLOTID
INNER JOIN PSX_TEMPLATE
ON RXSLOTCONTENT.VARIANTID = PSX_TEMPLATE.TEMPLATE_ID
INNER JOIN CONTENTTYPES
ON CONTENTTYPES.CONTENTTYPEID = RXSLOTCONTENT.CONTENTTYPEID
ORDER BY SLOTNAME, CONTENTTYPENAME

[li]To trace back from slots to the (mostly page) templates that “contain” them:
[/li]

SELECT PSX_TEMPLATE.TEMPLATE_ID, PSX_TEMPLATE.NAME AS TEMPLATE_NAME, RXSLOTTYPE.SLOTID, RXSLOTTYPE.SLOTNAME
FROM RXSLOTTYPE 
INNER JOIN RXVARIANTSLOTTYPE
ON RXSLOTTYPE.SLOTID = RXVARIANTSLOTTYPE.SLOTID
INNER JOIN PSX_TEMPLATE
ON RXVARIANTSLOTTYPE.VARIANTID = PSX_TEMPLATE.TEMPLATE_ID
ORDER BY TEMPLATE_NAME

[/ul]

Does anyone have any other SQL statements that they have found useful?

Andrew.

2

Has anyone found what field and table the user input is contained in?

3

If by user input you mean actual content, then it is stored in multiple tables: CONTENTSTATUS for system fields, one or more tables for shared fields, one for each content type, plus another table for each child table field.

4

In looking some more I found RXS_CT_SHARED has the fields CALLOUT and BODY.

I’m entertaining creating a store procedure or jdbc based java program to clean the BODY field since users can still paste MS Word/Outlook snippets which messes with our css.