Change the doc reference format

[n-sviridenko]

Currently, the doc reference is an array of the document snapshots which are impossible to query by if needed to filter the entities which are having those.

I.e. I have a collection with candidates:

{
  "name": "John Doe",
  "job": [{"docPath":"jobs/123","snapshot":{"name":"First job"}}]
}

{
  "name": "Bob Darwin",
  "job": [{"docPath":"jobs/243","snapshot":{"name":"Second job"}}]
}

They look user-friendly inside firetable, but I'm unable to query candidates by a specific job, as I have to filter them by the entire object (where('job', 'array-contains', {"docPath":"jobs/243","snapshot":{"name":"Second job"}})) which might change (e.g. I rename the job) while its snapshot will stay same.

The goal is to come up with something I'll be able to filter by.

P.S. How do the other firetable users solve this problem?

[n-sviridenko]

@shamsmosowi @notsidney

[shamsmosowi]

Hi @n-sviridenko , while its not ideal currently the easiest way to solve firestore query limitations is by adding a derivative column that can transform the original column into something that is easier to query, you can find an example in the docs here.
We are considering multiple options to make it possible to query, such as allowing "job" to be a single object rather an array, by adding it as a column configuration option

[notsidney]

Hi @n-sviridenko, our current plan is to add a setting for Connect Table to store a single value in the next release in October, so you can filter by job.docPath.

The default would be an array:

{
  "name": "John Doe",
  "job": [ { "docPath": "jobs/123", "snapshot": { "name": "First job" } } ]
}

and with single values:

{
  "name": "John Doe",
  "job": { "docPath": "jobs/123", "snapshot": { "name": "First job" } }
}

or if the value is cleared:

{
  "name": "John Doe",
  "job": null
}

This matches the values returned by Single Select.

[harinij]

Released in v2.1