Datanory Production » Datanory - SNEKKU

select * from customer_to_user_relation where customer_id= 'CFEB8C5486AF464D956B7BB12418E81F'
select * from customer where customer_code= '3h807'

select * from member where member_id = '054e3f6fc4bb4bbf98f791a6db0f54b4'

select * from txn_sales_order_header where customer_id='CFEB8C5486AF464D956B7BB12418E81F' order by created_date desc

select * from txn_sales_order_details where ord_hdr_id in ('131e1c88-3318-4db2-9ebe-1f1835ba0c5f',
'f50be59c-0c65-4bf5-ab9d-96ae7d30341a',
'28d85348-2c78-42b2-aef4-67845426bdf2',
'c1712f20-a97c-4dc3-a19d-f35454c0b01b',
'16cb6f16-3f8e-44f7-976a-dabbccc43867')

SELECT

p.status,  p.item_name, sd.created_date,sd.updated_date,
 p.created_date 
FROM 
 txn_sales_order_details sd
INNER JOIN 
    product_item p 
ON 
    sd.product_id = p.item_id
WHERE 
    sd.ord_hdr_id IN (
        '131e1c88-3318-4db2-9ebe-1f1835ba0c5f',
        'f50be59c-0c65-4bf5-ab9d-96ae7d30341a',
        '28d85348-2c78-42b2-aef4-67845426bdf2',
        'c1712f20-a97c-4dc3-a19d-f35454c0b01b',
        '16cb6f16-3f8e-44f7-976a-dabbccc43867'
    )
ORDER BY 
    sd.created_date DESC;

as we checked from our side, we notice that there is inactive product. as we checked with technical team(shu ern ) the items are set to inactive, and when app trying to retrieve the last sales order, it cant find the products and will throw error. we already disable the last order product list in sales order taking module where mobile could not display the last order product history.