how to use loop inside query on firestore?

Question

Is it possible to use loop inside query?

  Future<void> addServiceConfig(String uid, List<ServiceConfigModel> model) {
    _db.collection('users').document(uid).updateData({
      'businessDetails':{
        'serviceConfig':FieldValue.arrayUnion([
          {
            for(int i = 0;i <model.length;i++){
              if (model[i].inShop != null) 'inShop': model[i].inShop,
              if (model[i].inShopAndClientLocation != null)
                'inShopAndClientLocation': model[i].inShopAndClientLocation,
              if (model[i].clientLocation != null)
                'clientLocation': model[i].clientLocation,
              'serviceLocations': model[i].serviceLocations,
              'subCategoryId': model[i].subCategoryId
            }
        }
        ])
      }
    });
  }

I got this error:

[ERROR:flutter/lib/ui/ui_dart_state.cc(148)] Unhandled Exception: Invalid argument: Instance of '_CompactLinkedHashSet>'

BIS Tech · Accepted Answer · 2019-11-17 16:52:08Z

1

You can't use a loop (or many other statements) inside an expression, like the value of a field. One solution is to pull construct the value outside of the update() all and then pass it in:

//var config = new Map()

var result = new List();

for(int i = 0;i < model.length; i++){
  var config = new Map();
  if (model[i].inShop != null) config['inShop'] = model[i].inShop;
  if (model[i].inShopAndClientLocation != null) 
    config['inShopAndClientLocation'] = model[i].inShopAndClientLocation;
  if (model[i].clientLocation != null) 
    config['clientLocation'] = model[i].clientLocation;
  config['serviceLocations'] = model[i].serviceLocations,
  config['subCategoryId'] = model[i].subCategoryId;
 result.add(config);
}

_db.collection('users').document(uid).updateData({
  'businessDetails':{
    'serviceConfig': FieldValue.arrayUnion(result)
  }
});

edited Nov 17, 2019 at 16:52

BIS Tech

19.8k15 gold badges117 silver badges156 bronze badges

answered Nov 17, 2019 at 15:09

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

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

2 Comments

BIS Tech Over a year ago

thanks. I tried it. but only insert 1 value to database.. model length is 3. but insert only 1 to database

BIS Tech Over a year ago

I think issue is, config variable is not a list of map

Collectives™ on Stack Overflow

how to use loop inside query on firestore?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related