如何使用Golang在Firebase中搜索特定值？

Question

I am using Golang and Firego for connecting to Firebase. I am trying to search an admin with Email: [e-mail]. The following is my Database Structure

For this I have tried:

  dB.Child("CompanyAdmins").Child("Info").OrderBy("Email").EqualTo("[e-mail]").Value(&result)

but it does not produce expected result. How can I do this?

Answer 1

While @dev.bmax has the problem identified correctly, the solution is simpler. You can specify the path of a property to order on:

  dB.Child("CompanyAdmins")
    .OrderBy("Info/Email")
    .EqualTo("[e-mail]")
    .Value(&result)

Update (2017-02-10):

Full code I just tried:

f := firego.New("https://stackoverflow.firebaseio.com", nil)

var result map[string]interface{}

if err := f.Child("42134844/CompanyAdmins").OrderBy("Info/Email").EqualTo("[e-mail]").Value(&result); err != nil {
    log.Fatal(err)
}

fmt.Printf("%s
", result)

This prints:

map[-K111111:map[Info:map[Email:[e-mail]]]]

Which is the exact place where I put the data.

Update 20170213:

This is the index I have defined:

  "CompanyAdmins": {
    ".indexOn": "Info/Email"
  }

If this doesn't work for you, please provide a similarly complete snippet that I can test.