how to count unique entries in database

Ask the community
,
2

It’s not —> .count() <— you need!!!

You need → .distinct() <—
Inside of your data-query.

import wixData from 'wix-data';

wixData.query("myCollection")
  .distinct("state")
  .then((results) => {
    if(results.items.length > 0) {
      let items = results.items;
      let firstItem = items[0];
      let totalCount = results.totalCount;

    } else {
      // handle case where no matching items found
    }
  })
  .catch((error) => {
    let errorMsg = error.message;
    let code = error.code;
  });

Good luck!