get symbol infomation through symbol name

[yikengboy]

I install sourcegraph v5.3 instance, I want to find method reference top 20 in a repo through codeintel function,
now i can build symbol name from codeintel_scip_symbol_names db, The complete structure is as follows semanticdb maven maven/com.qunhe.devops/moon.api 0.0.1-SNAPSHOT com/qunhe/devops/moon/common/DateUtils#().

I want through this symbol name to find symbol’s path and some information like Range, Is there a way to achieve this?

[varungandhi-src]

If you're a Sourcegraph customer, please file a support request through your assigned Customer Engineer or Support Engineer.

I'm tentatively closing this issue, as it's not clear what exactly you're trying to do. We cannot help you with reverse engineering the DB schema, as that may change in upcoming Sourcegraph versions.

At the granularity of Sourcegraph, you can use the references GraphQL API today using source ranges, similar to how it is used by our client-side code. At the granularity of a SCIP index, you'd have to iterate through the symbols field of every Document, and if a SymbolInformation with matching name is found, then you can search the occurrences in that Document for one with a Definition SymbolRole.