I would like a single relational field in my aux table to be able to reference records in the "TS_STATES" table. Does anyone know if this is possible?
The use case is that the aux table contains logic for our service level agreements that scripts will utilize. I realize the workaround would be to manually enter the state TS_IDs in the aux table, but I'd like to do this as cleanly as possible.
Hmm, upon looking at the schema guide I guess the TS_STATES table may not technically be a "System Table," that designation appears to be reserved for the ones with the "BPEL" prefixes etc. Not sure exactly what type to call it...
Not directly. Don't forget that TS_STATES will contain all states (including deleted ones) for all workflows - probably not what you want your users to see. If you maintain an aux table with scripting, you can filter out irrelevant states. You can also provide a subrelational to a descriptive text field in your aux table.
Besides, going directly to the db to modify an existing single-relational field to point to TS_STATES causes db