0.11.6-rc Data API builder for Azure Databases

[seantleonard]

Changes:

• f557b4d GraphQL stored procedure support for DW (GraphQL stored procedure support for DW #2008)
• 302520d Enhanced claims processing for MS SQL Set session context (Enhanced claims processing for MS SQL Set session context #2003) [ [Bug]: Array in claims taken as duplicate claims with "Duplicate claims are not allowed within a request." #1957, Database Policies - Support "in" filter for OData #2004 ]
• a64c277 Cache enablement check and dab-draft.schema.json changes ([Cherrypick] Cache enablement check and dab-draft.schema.json changes #2033) [ Updated Json Schema which includes cache property #2011, Cache Enablement check changes #2012 ]
• d763a83 Fix query string contents in nextLink for REST (remove dupe $after query parameter) ([Cherrypick] Fix query string contents in nextLink for REST (remove dupe $after query parameter) #2032) [ Fix query string contents in nextLink for REST (remove dupe $after query parameter) #2006, Fix base64 encoding of $after query parameter value in NextLink #1895, Update README.md #1, Move from GraphQL DotNet to GraphQL hotchocolate #2 ]
• 3697d07 Added Cosmos Db nested Support for array type of attributes (Added Cosmos Db nested filtering support for array type of attributes #2009) [ [Bug]: Using filter on multi-level nested objects causes runtime error (GraphQL, CosmosDB) #1628, [Bug]: using multiple filters on a nested object field returns an access forbidden message #1624 ]
• a102e44 Support environment variable serialization for data source options (Support environment variable serialization for data source options #1980) [ [Bug]: env() transformation does not work after upgrading the project from 0.7.6 to 0.9.7 #1956 ]
• 5fe65f8 Make relationship fields in referenced entities nullable (Make relationship fields in referenced entities nullable #1958) [ [Bug]: Cannot return null for non-nullable field. #1747 ]
• 1f3f176 Add support for app insights in CLI (Add support for app insights in CLI #1952) [ [RFC]: Adding Cli option to enable Application Insights telemtry #1745 ]
• 0217d3e Verifying the read access of anonymous users prior to transmitting the Mutation result. ( Verifying the read access of anonymous users prior to transmitting the Mutation result. #1893) [ GraphQL - Roles defined without read action returns error #1464 ]

See More

DW

• 462eb00 fixing datetime and bit issue in DW. (fixing datetime and bit issue in DW. #1931)
• 542ac92 GraphQL Mutation support for datawarehouse. (GraphQL Mutation support for datawarehouse. #1978)

Fundamentals and Pipelines

• 1a72c9c Add tests for built_in methods support as default field values (Add tests for built_in methods support as default field values #1986) [ [Bug]: CLI create API incorrectly requires field value that has been excluded in the config #1857, [Bug]: MYSQL giving unreliable results when columns have a default value as a built_in method. #2014 ]
• 02463a2 Update README.md (Update README.md #2028)
• 27b652c Updating Service Connection for publishing dab container images (Updating Service Connection for publishing dab container images #2005)
• 02eed81 Update build-pipelines.yml (Update build-pipelines.yml #1996)
• e681aa5 Migrate MYSQL and PGSQL Integration test pipeline (Migrate MYSQL and PGSQL Integration test pipeline #1993) [ Pipeline Migration #1923 ]
• 4d53e7e Exposing the field mappings helpers through interface. (Exposing the field mappings helpers through interface. #1965)
• 95549b1 Cleanup of redundant class (Cleanup of redundant class #1963)
• aa577bf Update Dependencies and Suppress NU1603 (Update Dependencies and Suppress NU1603 #1970)
• dacf3bc Add design doc for dab validate (Add design doc for dab validate #1822)
• bc146f3 Upgrade deprecated tasks in pipeline (Upgrade deprecated tasks in pipeline #1954)
• 1d94ccc Update dwsql-pipelines.yml (Update dwsql-pipelines.yml #1955)
• 2902ccb Helper methods to expose field mappings (Helper methods to expose field mappings #1918)
• 2820516 update mssql pipeline for migration (update mssql pipeline for migration #1928) [ Pipeline Migration #1923 ]

This list of changes was auto generated.

---

This discussion was created from the release 0.11.6-rc Data API builder for Azure Databases.

[jaykar2020]

3697d07 Added Cosmos Db nested Support for array type of attributes (#2009) [ https://github.com//issues/1628, https://github.com//issues/1624 ]

I am on 0.11.6-rc and am not able to verify this fix. Multi-level nested object query still either returns

Bad Request if nested entity/child type is NOT defined in config
-or-
No results if nested entity/child type is defined in config

Any idea what could be wrong? Happy to provide more info if needed.