Querying ShipmentEx table and tracing Order back to user account

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.

Home / Forums / Developers (Main Products) Forum / Developer to developer /

Querying ShipmentEx table and tracing Order back to user account with SQL

Mike

Vote:

expand_less 0 expand_more

Hello,

I have a table "ShipmentEx" that links to some orders that have ERP and Tax stuff, but I can't see how I can link it to get the full order information.ShipmentEx cannot link to Shipment, OrderGroup, or OrderForm tables because they all require OrderGroupId, which isn't available in the ShipmentEx table. From a row in ShipmentEx, I want to be able to pull the full order and user account details. Can someone provide clarity on this?

Edit: I was able to query orders with customer information, with OrderGroup -> LineItem -> Shipment tables, but linking to this table is essential.

SELECT [ObjectId]
      ,[CreatorId]
      ,[Created]
      ,[ModifierId]
      ,[Modified]
      ,[PrevStatus]
      ,[ERPOrderNo]
      ,[StatusExt]
      ,[TaxDocCode]
      ,[ShipmentTax]
      ,[ShipmentTaxStatus]
      ,[ShippingRateTable]
      ,[ShippingGroup]
      ,[HandlingCharge]
  FROM [elad01mstrfg1t0prod.commerce].[dbo].[ShipmentEx]

#315814

Edited, Jan 18, 2024 17:05

Quan Mai

Vote:

expand_less 0 expand_more

Not sure if I understand you correctly but

LineItemEx (ObjectId) is essentially LineItem (LineItemId), from there you get OrderGroupId

#315855

Jan 19, 2024 7:57

error This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.