Is it possible to query against the notes for an EMMA case

[Astrid_Gambill]

I'm looking to join the EMMA_CASE table to the table that holds the notes for the case.  Does anyone know what this latter table is?

I've looked at all the tables beginning with EMMA* and can't find it.

Many Thanks

Astrid

[TammyPowlas · Accepted solution]

Astrid - I checked our test system and we don't have anything populated

Maybe try querying from this view:

Or check the joins on this table:

[william_eastman]

Astrid:

Notes are not stored in a table like that.  Typically you need to call a function like READ_TEXT.  You can see this in the method READ_CASE_TEXT. 

regards,

bill.

[former_member586730]

There is a flag XNOTE in EMMA_CASE table which denotes that there exists note for the emma case but the notes content are not stored in emma tables. Its actually stored in STXH , STXL cluster tables with RELID = TX, TDOBJECT = EMMA_CASE.