[SOLVED] Use Query by Appwrite correct method | Appwrite | Page 1

opal pawn Jun 23, 2023, 9:41 PM

#

const fetchReviews = useCallback(async (placeId) => { const cleanPlaceId = placeId.replace(/[^a-zA-Z0-9_.-]/g, '').replace(/^[^a-zA-Z]/, ''); const truncatedPlaceId = cleanPlaceId.substring(0, 34); const truncatedPlaceId1 = a${truncatedPlaceId}`;
try {
const response = await databases.listDocuments(
process.env.REACT_APP_DATABASE_ID,
process.env.REACT_APP_COLLECTION_ID,
Query.equal('coordinates',[truncatedPlaceId1])
);

  const fetchedReviews = response.documents.map((document) => document.review);
  setReviews((prevReviews) => ({
    ...prevReviews,
    [placeId]: fetchedReviews,
  }));
} catch (error) {
  console.error('Error fetching reviews:', error);
}

}, []);
`
I don't know what's causing the error below

Error fetching reviews: AppwriteException: Invalid queries: Value must a valid array and Value must be a valid string and no longer than 4096 chars
at Client.<anonymous>

civic hawk Jun 23, 2023, 9:47 PM

#

Try

const response = await databases.listDocuments(
    process.env.REACT_APP_DATABASE_ID,
    process.env.REACT_APP_COLLECTION_ID,
    [
      Query.equal('coordinates',[truncatedPlaceId1])  
    ]  
  );

opal pawn Jun 23, 2023, 9:51 PM

#

yes thanks error went away

#

hey could you clarify this error this is the new error

Error fetching reviews: AppwriteException: Index not found: coordinates
at Client.<anonymous>

civic hawk Jun 23, 2023, 9:58 PM

#

Thinks you use cloud

#

You need to create index for equal queries

#

You can create index directly via console (website)

opal pawn Jun 23, 2023, 10:05 PM

#

okay thanks Bouahaza for your so much fast and correct help

glossy moat Jun 23, 2023, 10:38 PM

#

Use Query by Appwrite correct method

glossy moat Jun 23, 2023, 10:38 PM

#

opal pawn `const fetchReviews = useCallback(async (placeId) => { const cleanPlaceId = ...

FYI, it's best to use 3 backticks for multiline code (https://www.markdownguide.org/extended-syntax/#syntax-highlighting.

#

and FYI, the queries are documented here: https://appwrite.io/docs/databases-queries

#

[SOLVED]Use Query by Appwrite correct method

opal pawn Jun 23, 2023, 11:21 PM

#

okay thanks Steven I will remember this 😊😊

#[SOLVED] Use Query by Appwrite correct method