Hi, I have a situation similar to what mentioned in the below https://www.inflectra.com/Support/KnowledgeBase/KB369.aspx However in my case I have multiple CUST values, (01, 02) and Im running query against Project Group, not Project. In the group, some project has only 1 CUST, some has 2 which made my report grabbing the unexpected custom properties. Can you please help to advise how to get them correctly? Thanks en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/2024.aspxthreadId=2024Tung Nguyen (tran.nguyen@transport.nsw.gov.au) Hi, I have a situation similar to what mentioned in the below https://www.inflectra.com/Support/KnowledgeBase/KB369.aspx However in my case I have multiple CUST values, (01, 02) and Im running query against Project Group, not Project. In the group, some project has only 1 CUST, some has 2 which made my report grabbing the unexpected custom properties. Can you please help to advise how to get them correctly? Thanks Wed, 08 May 2019 23:40:27 -04002024-10-17T14:07:43-04:00/Support/Forum/spirateam/reports/2024.aspxmessageId=3579Jim R (donotreply5@kronodesk.net) When you run against a project group, the custom properties will be different for each of the projects, so the values themselves will not be the same for each project. In addition, the projects may not use the same fields for the same value (e.g. Browser could be CUS_01 in project PR1 and CUS_02 in project PR2). However assuming that is NOT the case, then if it is just the values that are different then you could use the following: select R.REQUIREMENT_ID, R.REQUIREMENT_NAME, R.TEST_CASE_ID, R.TEST_CASE_NAME, T.CUST_02, C.NAME from SpiraTestEntities.R_RequirementTestCases as R inner join SpiraTestEntities.R_TestCases as T on R.TEST_CASE_ID = T.TEST_CASE_ID left join SpiraTestEntities.R_CustomListValues as C on cast (T.CUST_02 as int32) = C.CUSTOM_PROPERTY_VALUE_ID and T.PROJECT_ID = C.PROJECT_ID where R.PROJECT_GROUP_ID = ${ProjectGroupId} where we added an additional clause to join the projects explicitly: ...and T.PROJECT_ID = C.PROJECT_ID Regards Jim Sun, 12 May 2019 11:25:38 -04002019-05-12T11:25:38-04:00/Support/Forum/spirateam/reports/2024.aspx#reply3579messageId=3724Tung Nguyen (tran.nguyen@transport.nsw.gov.au) Hello Jim, Thanks for your response. Weve instructed all projects to use the same way of custom values, however it runs into another issue, for example: project 1, cust02 is Program, value is free form Text, but for project 2, cust02 is also Program, value is a List of predefined program (Civil, Electrical...). Consequently the report generated error cannot convert character correctly etc...In this case, its type mismatch for the custom properties Anyway to fix? By the way, if custom value is Date type, error with conversion happens as well. Possibly we cannot apply C on cast (T.CUST_02 as int32) = C.CUSTOM_PROPERTY_VALUE_ID?? Many thanks Wed, 05 Feb 2020 04:30:01 -05002020-02-05T04:30:01-05:00/Support/Forum/spirateam/reports/2024.aspx#reply3724