s shibhin
on

 

Hi, 

We are getting a blank brace in the whereclause of value level metadata in define.xml ver 2. 

Eg: QVAL EQ AESTRF()

Please advice, what value is actually expected inside the braces and how to get it populated. 

Also, please explain, if we don't want any value in there, how to remove these braces?

Thanks in Advance.

Forums: Define.xml

j Jozef
on July 13, 2017

What do you mean with "getting"? Is in the XML code? That cannot be the case as you would need to see something like:
<def:WhereClauseDef OID="WC.SUPPAE.QNAM.xyz">
        <RangeCheck SoftHard="Soft" def:ItemOID="IT.SUPPAE.QVAL" Comparator="EQ">
          <CheckValue>AESTRF</CheckValue>
        </RangeCheck>
</def:WhereClauseDef>

Or do you mean in what you see in the browser through the stylesheet (which is only a visualization)?
If it is the latter, it can either be a problem with the stylesheet, or invalid XML that you generated (how did you generate it?).
The first thing to do is when such things occur is to look into the define.xml XML (e.g. using NotePad++). And don't be afraid to do that - you can learn XML in less than 2 hours.

As one of the developers of the define.xml standard, it always makes me very sad when I see that people believe that what they see through the stylesheet is "it", and completely neglect what is in the XML itself.

s shibhin
on July 13, 2017

Many Thanks for the reply.

The issue we are finding is in the browser view.

We generate the xml using Pinnacle 21. We export the metadata (which is as per pinnacle requirement) in to the "Generate define" option in pinnacle 21. Is there any way we can prevent pinnacle 21 interface from creating this braces. Or is it an issue with the metadata or stylesheet?

Can you please advice, in the pinnacle metadata (in excel format), from where the value which is supposed to be coming inside these braces are picked up? i mean the excel tab and the column name/label etc.

We guess it is the label of the variable name, which must be coming inside the braces. In this case of AETRTEM, it might be "Treatment Emergent Flag". 

Thanks again for responding.

 

l Lex
on July 13, 2017

It is the stylesheet, but you need a description (label) for your ItemDef, since supplemental qualifiers describe variables. A reviewer does not know what AESTRF is by looking at the Define-XML file without having a description.

Same issue was reported here:

https://www.pinnacle21.com/forum/how-can-i-get-rid-extra-end-each-element-value-level-metadata

 

j Jozef
on July 13, 2017

Thanks Lex for finding out so quickly!
@shibhin: the sentence "Is there any way we can prevent pinnacle 21 interface from creating this braces" still suggests that you did not take a look into the generated XML (as the braces are NOT generated by the Pinnacle21 tool). Again, if you have such an issue, ALWAYS have a look at the XML that was generated. This will help you concentrate on what the real problem is. In your case, if you inspect the XML, you will not find the mentioned braces. So it must be that the stylesheet is missing some information (in this case the information from the "Description" element in "ItemDef" element in the XML).
I would suggest that you do the following:
- learn the basics of XML: 2 hours
- take a CDISC Define-XML course: 8 hours
This will make you a Define-XML "expert" (everything is relative ... ;-) ) in about 10 hours, and help you understand what you are doing when you use the tool.

Want a demo?

Let’s Talk.

We're eager to share and ready to listen.

Cookie Policy

Pinnacle 21 uses cookies to make our site easier for you to use. By continuing to use this website, you agree to our use of cookies. For more info visit our Privacy Policy.