CDR Tickets

Looks like each DrugInformationSummary has only one link to a Term document, but many links to GlossaryTermName documents. Can you confirm that you're expecting multiple rows for at least some of the DIS docs, one for each linked glossary term name?

I'm going to guess that you don't want multiple rows for each DIS/DCS document, and that what you had in mind for the glossary links were just the ones in the

DrugInfoMetaData

block. Let me know if that's not right.

Yes, you're right! Just the GlossaryLink that's in the metadata block. Sorry I didn't specify that.

This looks great, but I noticed a couple of anomalies that I thought I'd mention:

• There's some strange formatting in the dictionary definition column. Some of the definitions have large spaces or line breaks within the definition. Is there an easy trick to clean that up? If not, I think we can live with this as it's for internal use.

• The dictionary definition for selinexnor isn't showing up (corresponding with the following DIS- CDR 798722). We can copy/paste this in - it seems to be the only publishable DIS with a blank cell - but it seemed odd so I figured I'd mention it. This was run using the data on PROD right? I double-checked that the term had a publishable definition.

Thank you!

I have preserved the whitespace exactly as it was entered by the users. I'll take a look at 798722.

I meant to run it on PROD, but the first one was from DEV. I've added the version for PROD, and that's got the missing definition.

As you can see, the report is reflecting the way the definition was entered in the CDR:

Would you prefer that I normalize whitespace in the definitions, rather than preserve what the users have entered?

I've done it both ways, so you can take your pick. 😃

This looks great, Bob. Thank you!!