{{
`${userDetail.user.displayName}${userDetail.user.cachedBungieGlobalDisplayNameCode ? `#${standardizeBungieGlobalCode(userDetail.user.cachedBungieGlobalDisplayNameCode)}` : ""}`}}
{{getUserClans()}}
originally posted in:BungieNetPlatform
View Entire Topic
6/8/2015 8:20:13 PM
1
Finding items by name?
In order to find items by name (specifically their item hashes), do I need to download the manifest and use it to populate/query a database or is there a ready-made endpoint for doing this that I've missed?
English
-
I thought the explorer could do this but it doesn't look like it lets you search by name or hash. Easy enough to do it with the manifest though... to search by name or some other text: SELECT json FROM DestinyInventoryItemDefinition WHERE json LIKE "%Abyss Defiant%" to search by hash: SELECT json FROM DestinyInventoryItemDefinition WHERE id = hash The main gotcha is that while the hash value is a uint32, it is stored in the id column as an int32, so you have to convert before you search.
