Document toolboxDocument toolbox

Orders Missing in ThoughtSpot

Owned by David Haskell (Unlicensed), created
Oct 14, 2021
1 min read

Summary / TL:DR: This article will show you how to find a missing order in ThoughtSpot.

  1. Find PO number from AdvDbPrd

    select * from proord_m where ord_num = ''

     

  2. Find the orderuid from Prromo3 where (po number) is the the value found in step 1.

    select * from abstractorder where id = '(po number)'

     

  3. Search OpiumAudit using theorderuid found in step 2.

    select * from auditcustomerinfo where orderuid = ''

Wrap up

You should now know how to find a missing order in ThoughtSpot.

com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.