snippet

Find object name by type id

Find specific object by name

select 
    * 
from 
    obj.objects 
where 
    lower(name) like '%merchant%';

id	type_id	class_id	master_id	memo	name
1500803	59	97	null	MERCHANTS_OFFICE	Merchants office
1500191	60	105	null	UNIPIN	UniPin Merchant
1501092	18	114	2848	WITHDRAW_ON_MERCHANT	Withdraw on merchant
1500235	60	105	null	NewTestMerch	NewTestMerchantApr20
1500699	60	109	null	TEST_MERCHANT	Test Merchant
1366505	61	104	null	TYPE_PAYMENT_TO_MERCHANT	PAYMENT_TO_MERCHANT
1500862	60	109	2825	MERCHANT01	Merchant01
1500947	18	17	2848	REFILL_TO_MERCHANT	Refill to merchant
1500948	61	104	null	TYPE_REFILL_TO_MERCHANT	REFILL_TO_MERCHANT
1501091	61	104	null	TYPE_WITHDRAW_ON_MERCHANT	WITHDRAW_ON_MERCHANT
1501559	60	109	2825	TESTING MERCHANT 01	Testing Merchant 01

Show all object name group by object type

SELECT
    distinct obj.get_object_name(service_id) object_name
    , service_id
    , obj.get_object_name(type_id) object_type
    , type_id
FROM
    processing.operations
order by
    type_id;

object_name	service_id	object_type	type_id
Withdraw on merchant	1501092	WALLET_DEPOSIT	1366485
Wallet deposit	1000117	WALLET_DEPOSIT	1366485
KHQR upay deposit	1583654	WALLET_DEPOSIT	1366485
Upay	1537949	WALLET_DEPOSIT	1366485
Registration bonus fee	1502269	CUSTOMER_BONUS	1366503
Bonus fee	1501864	CUSTOMER_BONUS	1366503
Activity bonus fee	1504754	CUSTOMER_BONUS	1366503
Payment amount	1366145	PAYMENT_TO_MERCHANT	1366505
merchant order refund	1505168	PAYMENT_TO_MERCHANT	1366505
Discount amount	1538676	PAYMENT_TO_MERCHANT	1366505

Get object location or properties

select 
    *
from 
    obj.object_properties 
where 
    property_id = ost.get_property_id('MERCHANT_PROVINCE');

Get currency

SELECT 
    distinct obj.get_object_memo(currency_id)
FROM 
    processing.operations;

get_object_memo
UPOINT
BONUS_USD
Euro
KHR
BONUS_KHR
USD
CNY

Get operation status

SELECT 
    distinct sys.get_constant_memo_by_id(status_id)
FROM 
    processing.operations;

get_constant_memo_by_id
OPERATION_FAILED
OPERATION_READY_FOR_PAYMENT
OPERATION_REVESED
OPERATION_PARAMS_FAILED
OPERATION_PARAMS_CHECKED
OPERATION_COMMITED
OPERATION_INIT
OPERATION_PAID
OPERATION_PARTIAL_REFUND
OPERATION_CANCELED
OPERATION_PARAMS_CHECKING
OPERATION_COMMIT_FAIL
OPERATION_PARAMS_INPUTED

Find type id of a specific string

select 
    *
from 
    ost.get_object_type_id('terminal'); -- 12