Below query will give the id for the url
SELECT [id]
FROM [irm_alfresco].[dbo].[alf_namespace] where
uri='http://www.ironmountain.com/model/content/1.0'
22
Below query will give the id used in the alf_node
table
SELECT [id]
,[version]
,[ns_id]
,[local_name]
FROM [irm_alfresco].[dbo].[alf_qname] where
(ns_id='22' AND local_name='customType')
251
SELECT [id]
,[version]
,[store_id]
,[uuid]
,[transaction_id]
,[type_qname_id]
,[locale_id]
,[acl_id]
,[audit_creator]
,[audit_created]
,[audit_modifier]
,[audit_modified]
,[audit_accessed]
FROM [irm_alfresco].[dbo].[alf_node] where
type_qname_id='251'
35978,01a29a40-d34a-4093-a641-16b9be2fee6b
All properties will be given distinguish them
based on qnmae_id
SELECT TOP 1000 [node_id]
,[actual_type_n]
,[persisted_type_n]
,[boolean_value]
,[long_value]
,[float_value]
,[double_value]
,[string_value]
,[serializable_value]
,[qname_id]
,[list_index]
,[locale_id]
FROM [irm_alfresco].[dbo].[alf_node_properties] where
node_id='35978'
SELECT *
FROM [irm_alfresco].[dbo].[alf_node] AS n,
[irm_alfresco].[dbo].[alf_qname] AS q
WHERE (n.type_qname_id=q.id
AND q.local_name='customType' AND q.ns_id= (SELECT [id]
FROM [irm_alfresco].[dbo].[alf_namespace] where uri='http://www.patil.com/model/content/1.0'))
