Member Name in SQL
# help-with-otherj
JN
05/01/2024, 8:22 PMHow to get member name from SQL Database? I need to get member name in a stored procedure.
j
Jemayn
05/02/2024, 8:18 AMMembers are nodes in the umbracoNode table with a specific type, technically to just get all names of members you can run
Copy code
sql
SELECT [text]
FROM [umbracoNode]
WHERE nodeObjectType = '39EB0F98-B348-42A1-8662-E7EB18487560'j
JN
05/02/2024, 1:21 PMThanks. This works!
s
Sven Geusens
05/14/2024, 11:26 AMIf you ever need others, you can find all off the node object type guids in
Umbraco.Cms.Core.ObjectTypes.Strings
a
Ambert
05/14/2024, 4:47 PMThis should be in docs somewhere 😄
s
Sven Geusens
05/14/2024, 5:27 PMneih, just become a core team dev, you will learn these things 😅
Sven Geusens
05/14/2024, 5:28 PMAny suggestion on the place where you would search for this, and what wording?
a
Ambert
05/14/2024, 5:34 PMOk, maybe im just too tired, but why can I find the ObjectTypes library ?
Ambert
05/14/2024, 5:36 PMAmbert
05/14/2024, 5:38 PMObject Types references
Ambert
05/14/2024, 5:38 PMOr atleast in that area ?
Ambert
05/14/2024, 5:39 PMOr it overlaps a bit with the Models reference I guess
7 Views