# WhereClause is not displayed by Selection Criteria part of Analysis Results Metadata **URL:** \ **Category:** Define.xml\ **Created:** [June 14, 2022, 12:51am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829 "2022-06-14T00:51:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![cnakao](https://avatars.discourse-cdn.com/v4/letter/c/85e7bf/32.png) [@cnakao](https://forum.certara.com/u/cnakao)\ **Post date:** [June 21, 2022, 3:33am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/1 "2022-06-21T03:33:25Z")
I do not believe it is supported with P21 Community about ARM while it is creating define.xml. Thank you. Chikaaki ---
**Author:** ![s-sekine\_1](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@s-sekine\_1](https://forum.certara.com/u/s-sekine_1)\ **Post date:** [June 21, 2022, 6:40am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/2 "2022-06-21T06:40:01Z")
Hi, Mr.Chikaaki Thank you very much for answering the question. I hope that the malfunction is revised by next update of Pinnacle21C. Best regards ---
**Author:** ![cnakao](https://avatars.discourse-cdn.com/v4/letter/c/85e7bf/32.png) [@cnakao](https://forum.certara.com/u/cnakao)\ **Post date:** [June 23, 2022, 1:16am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/3 "2022-06-23T01:16:34Z")
Hi, Satoshi-san. It is found that Community V4.x support ARM creation using P21C. Please download the installation kit and use the template. Thank you. Chikaaki ---
**Author:** ![lionel.debecq](https://avatars.discourse-cdn.com/v4/letter/l/d26b3c/32.png) [@lionel.debecq](https://forum.certara.com/u/lionel.debecq)\ **Post date:** [August 11, 2022, 2:53pm UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/4 "2022-08-11T14:53:43Z")
Hello, I’m experiencing the same issue. Where is located the template you mentioned ? Because, everything else is filled correctly, but the Parameter section and the Selection Criteria. How to complete that correctly ? I’ve tried to use the ARM Define.xml from CDISC and convert it to Specification through P21 4.0.1. However the result is disapointing as the Selection Criteria column is empty and no Parameter to be found anywhere. I thought first to complete the WhereClause Column in the ValueLevel sheet, but there is no way to reference it in the Selection Critieria column of Analysis Result sheet. A little help here? 🙂 Thanks a lot in advance. Lionel. ---
**Author:** ![Trevor\_Mankus](https://sea1.discourse-cdn.com/certara/user_avatar/forum.certara.com/trevor_mankus/32/2650_2.png) [@Trevor\_Mankus](https://forum.certara.com/u/Trevor_Mankus)\ **Post date:** [August 15, 2022, 4:38pm UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/5 "2022-08-15T16:38:32Z")
Hi, I can verify that this is a bug in the latest version of P21C 4.0.x. I’ve created a ticket to have this fixed in the next release. This bug only impacts generating a define Spec from define.xml. Generating a define.xml from a define spec with values in this cell will work as expected. You’ll need to populate them manually. Here are examples of how to populate this field: - A single dataset and complex where clause: - ADQSADAS[PARAMCD EQ ACTOT and AVISIT EQ “Week 24” and EFFFL EQ Y and ANL01FL EQ Y] - Multiple datasets and complex where clauses: - ADAE[TRTEMFL EQ Y and AESER EQ Y] ADSL[SAFFL EQ Y] Please let me know if this works or if you have additional follow up questions. Trevor Product Manager ---
**Author:** ![lionel.debecq](https://avatars.discourse-cdn.com/v4/letter/l/d26b3c/32.png) [@lionel.debecq](https://forum.certara.com/u/lionel.debecq)\ **Post date:** [August 18, 2022, 9:34am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/6 "2022-08-18T09:34:00Z")
Hi Trevor, Thanks a lot for your answer. I made a mistake by assuming that “=” was equivalent to “EQ”. It was not the case, now it is replaced it is working just fine ! Thanks a lot for your time and help. Kind regards Lionel. ---
**Author:** ![s-sekine\_1](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@s-sekine\_1](https://forum.certara.com/u/s-sekine_1)\ **Post date:** [August 19, 2022, 12:51am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/7 "2022-08-19T00:51:26Z")
Hi, Trevor I appreciate your replying my question. According to your instruction, I was able to create ARM without a problem. Best regards, Sato ---
**Author:** ![s-sekine\_1](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@s-sekine\_1](https://forum.certara.com/u/s-sekine_1)\ **Post date:** [June 14, 2022, 12:51am UTC](https://forum.certara.com/t/whereclause-is-not-displayed-by-selection-criteria-part-of-analysis-results-metadata/1829/8 "2022-06-14T00:51:31Z")
Dear, Pinnacle 21 Staff Even if I fill in Analysis Results Sheet with anything, def:WhereClauseRef cord is not made at all in arm:AnalysisDatasets in Defien.xml. Please instruct the entry example to the Excel Sheet. Best regards, Sato