How dynamic add an array of functions to an javascript function?

Question

I do have this structure:

db.collection('users')

and want to make this:

db.collection('users')
   .where('works', 'array-contains', 'CASE_A')
   .where('works', 'array-contains', 'CASE_B')
   .where('works', 'array-contains', 'CASE_C')
   ...

In this case, I will make an array of
(( .where('works', 'array-contains',${variable}))

and i will add this in the beginning db.collection('users'), how can i make this?

I think you can use Javascript eval function and array join function. — TopW3
– TopW3, Commented Jan 13, 2020 at 2:21
If you want to write a query which contains ALL the cases, you will have to create a separate query for each case and merge the query results in your app. The following article explains how to do that (disclaimer, I'm the author). — Renaud Tarnec
– Renaud Tarnec, Commented Jan 13, 2020 at 16:03

Doug Stevenson · Accepted Answer · 2020-01-13 02:57:39Z

2

Just make an inline array:

db.collection('users')
   .where('works', 'array-contains', ['CASE_A', 'CASE_B', 'CASE_C'])

Or use a variable if you want:

const array = ['CASE_A', 'CASE_B', 'CASE_C']
db.collection('users')
   .where('works', 'array-contains', array)

If you actually want to find documents where all cases are present (not where any of the cases are present), you won't be able to use an array-contains type query. You will have to convert your array into an object and query it as shown in this question: Firestore: Multiple 'array-contains'

edited Jan 13, 2020 at 2:57

answered Jan 13, 2020 at 2:21

Doug Stevenson

321k37 gold badges458 silver badges474 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

eeerrrttt Over a year ago

will this return a query which contains ALL the cases ? I want the documents where all cases match.

Doug Stevenson Over a year ago

No, this will do a logical OR of each item. You can't do a logical AND of each item, as Firestore doesn't support multiple array-contains clauses in a single query. If you want to use an object instead of an array, use this: stackoverflow.com/questions/52837711/…

TopW3 · Accepted Answer · 2020-01-13 02:27:18Z

1

Please try this code.

const makeItem = value => `.where('works', 'array-contains',${value}`

const arrFuncs = [
    makeItem('CASE_A'),
    makeItem('CASE_B'),
    makeItem('CASE_C'),
]

const initialCmd = `db.collection('users')`
eval(initialCmd + arrFuncs.join(''))

answered Jan 13, 2020 at 2:27

TopW3

1,5371 gold badge10 silver badges14 bronze badges

Collectives™ on Stack Overflow

How dynamic add an array of functions to an javascript function?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related