PINNACLE 21 DEFINE GENERATOR ISSUE: WHERE CLAUSE REPEATS

r Ryan

on January 20, 2016

I generated a define.xml 2.0 file using the new Pinnacle 21 define generator that passed validation however there appears to be an issue with the WHERE clause in the Value Metadata. It seems to repeat some of the criteria variables so it would show something like this in the WHERE column:

EGTESTCD='HR' and

EGCAT='MEASUREMENT' and

EGTESTCD='HR' and

EGCAT='MEASUREMENT'.

The example above you can see that the EGTESTCD and EGCAT are repeating and that is what is being generated in Pinnacle define file. I'm pretty sure my excel define metadata WHERE clause entries are correct because when I ran the older OPENCDISC 2.01 community generator, it produces the correct WHERE clause statements in the define.

Is this a known bug or an isolated incident in the Pinnacle 21 version?

Regards,

Ryan

Forums: Troubleshooting and Problems

s Sergiy

on January 28, 2016

Hi Rayan, For multiple

Hi Rayan,

For multiple conditions in WhereClause in Pinn21 Excel specifications you need to create separate records with the same ID for each condition. I recommend to scan an example define.xml file included into Define.XML v2.0 standard package (Define.xml Generator-> Import Define.xml). Here is how it was done for VSTESTCD=WEIGHT and COUNTRY in (CAN, MEX):

ID	Dataset	Variable	Comparator	Value
VS.VSTESTCD.WEIGHT.DM.COUNTRY.CAN	VS	VSTESTCD	EQ	WEIGHT
VS.VSTESTCD.WEIGHT.DM.COUNTRY.CAN	DM	COUNTRY	IN	CAN, MEX

Kind Regards,

Sergiy

s Sergiy

on January 28, 2016

ID Dataset Variable Comparato

ID	Dataset	Variable	Comparator	Value
EGEXAMPLE1	EG	EGTESTCD	EQ	HR
EGEXAMPLE1	EG	EGCAT	EQ	MEASUREMENT

r Ryan

on January 30, 2016

ID Dataset Variable Example

Hi Sergiy,

My original define spec Where Clause tab already did this (using same ID to link multiple criteria) hence why

the OPENCDISC Community 2.02 define generator working properly with my file. The problem is when I fed this same file into the newer Pinnacle version, it doesn't produce the correct Where Clause (it repeats all the Criteria twice) in the displayed WHERE statement. So what looks clean in OPENCDISC 2.02 WHERE clause (ex. WHERE egtestcd='HR' AND egcat='Measurement') looks incorrect in Pinnacle (ex. WHERE egtestcd='HR' AND egcat='Measurement' AND egtestcd='HR' AND egcat='Measurement').

It's strange that the older OPENCDISC 2.02 define generator works on my file but the Pinnacle one does not.

Regards,

Ryan