chip
chip
Explore posts from servers
CDCloudflare DevelopersTTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by chip on 2/5/2024 in #help
CAST(<json column> with LIKE seems to be buggin
Figured it out. Solution: 
  return query.where(
    and(
      eq(logs.teamId, teamId),
      or(
        ...metadata.map((meta) => {
          const likePattern = `%${meta}%`;
          return sql`CAST(${sql.raw('logs.metadata')} AS CHAR) LIKE ${likePattern}`;
        }),
      ),
    ),
  );
  return query.where(
    and(
      eq(logs.teamId, teamId),
      or(
        ...metadata.map((meta) => {
          const likePattern = `%${meta}%`;
          return sql`CAST(${sql.raw('logs.metadata')} AS CHAR) LIKE ${likePattern}`;
        }),
      ),
    ),
  );
3 replies
DTDrizzle Team
Created by chip on 2/5/2024 in #help
CAST(<json column> with LIKE seems to be buggin
This query works just fine when running it in my db query console,fyi
3 replies