|
Вот такой страшный запрос мультипаспорт генерирует для формы EсoResProductDetailsExtended в AX2012
Я иногда копи-пастю такие запросы для всяких нужд.
SELECT * FROM InventTable(InventTable) OUTER JOIN * FROM S_InventTable(S_InventTable) ON InventTable.RecId = S_InventTable.RefRecId OUTER JOIN * FROM InventModelGroupItem(InventModelGroupItem) ON InventTable.dataAreaId = InventModelGroupItem.ItemDataAreaId AND InventTable.ItemId = InventModelGroupItem.ItemId OUTER JOIN * FROM InventItemGroupItem(InventItemGroupItem) ON InventTable.dataAreaId = InventItemGroupItem.ItemDataAreaId AND InventTable.ItemId = InventItemGroupItem.ItemId OUTER JOIN * FROM EcoResTrackingDimensionGroupItem(EcoResTrackingDimensionGroupItem) ON InventTable.dataAreaId = EcoResTrackingDimensionGroupItem.ItemDataAreaId AND InventTable.ItemId = EcoResTrackingDimensionGroupItem.ItemId OUTER JOIN * FROM EcoResStorageDimensionGroupItem(EcoResStorageDimensionGroupItem) ON InventTable.dataAreaId = EcoResStorageDimensionGroupItem.ItemDataAreaId AND InventTable.ItemId = EcoResStorageDimensionGroupItem.ItemId JOIN * FROM EcoResProduct(EcoResProduct) ON InventTable.Product = EcoResProduct.RecId OUTER JOIN * FROM EcoResProductDimensionGroupProduct(EcoResProductDimensionGroupProduct) ON EcoResProductMaster.RecId = EcoResProductDimensionGroupProduct.Product OUTER JOIN * FROM EcoResProductTranslation(EcoResProductTranslation) ON EcoResProduct.RecId = EcoResProductTranslation.Product AND ((LanguageId = N'ru') OR (LanguageId = N'ru')) OUTER JOIN * FROM EcoResProductMasterModelingPolicy(EcoResProductMasterModelingPolicy) ON EcoResProductMaster.RecId = EcoResProductMasterModelingPolicy.ProductMaster JOIN * FROM InventTableModule(Purch) ON InventTable.ItemId = InventTableModule.ItemId AND ((ModuleType = 1)) JOIN * FROM InventTableModule(Invent) ON InventTable.ItemId = InventTableModule.ItemId AND ((ModuleType = 0)) JOIN * FROM InventTableModule(Sales) ON InventTable.ItemId = InventTableModule.ItemId AND ((ModuleType = 2)) JOIN * FROM InventItemLocation(InventItemLocation) ON InventTable.ItemId = InventItemLocation.ItemId AND ((inventDimId = N'AllBlank')) WHERE ((InventModelGroupItem(InventModelGroupItem).)) AND ((InventItemGroupItem(InventItemGroupItem).))
|