Utilize the LIKE operator in typeORM Queries with Typescript for flexible WHERE conditions

Currently, I am attempting to query a specific column in an SQL database using Typescript with an endsWith condition.

const tracking_code = '65432'
repo.findValidOne({ where: { tracking_code }});

I aim to modify the query so that the tracking_code value ends with the available code's tracking value.

The corresponding SQL query would be:

SELECT * 
FROM repo 
WHERE tracking_code LIKE '%65432' 
LIMIT 1;

Although I have experimented with raw queries, they do not provide the desired outcome.

postgresqltypescripttypeorm

Answer №1

In order to search using the Like find operator, you should follow this example.

import {Like} from 'typeorm';

const tracking_code = '65432';
repo.findValidOne({ where: { tracking_code: Like(`%${tracking_code}`) }});

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Discovering a DOM Element Post Mouse Click Event Using HostListener in Angular 8

Is there a way to locate the current DOM element on a page after clicking the mouse? I am currently attempting to utilize HostListener in Angular 8. @HostListener('click') onClick(){ window.alert('Current DOM element is'); } ...

angulartypescriptangular8

How can one go about defining a (generic) type in TypeScript that includes certain defined properties, which may still be set as null?

I'm struggling to define a generic type in TypeScript that makes certain properties of Product optional while still allowing them to be nullable. I'm still learning TypeScript and finding it quite challenging. class Product { id: number | strin ...

typescript

Typescript causing undefined React Router match issue

Currently, I am working on a basic eCommerce Proof of Concept using react and TypeScript. Unfortunately, I am facing an issue where I am unable to pass props to a product detail page or access the match containing the params. This is how my Routes pages a ...

reactjstypescriptreact-router

Parameter decoration is leveraged in Aurelia factory resolver (instead of class decoration)

I have experience using the Aurelia factory resolver with the @inject class decorator: @inject(Factory.of(Foo)) export class NeedsFoo { foo: Foo; constructor(fooFactory: () => Foo) { this.foo = fooFactory(config); } } The config parameter is ...

typescriptaurelia

What causes a merge conflict to occur within a React and Typescript project?

I stumbled upon this code snippet in our React/Typescript - JSX/TSX project with an unresolved Git merge conflict. Interestingly, the code successfully compiles and runs in the browser! Upon transpilation, I noticed that the top element is recognized as t ...

javascriptgitreactjstypescriptjsx

Troubleshooting engine malfunction in Angular 9 caused by FormGroup usage

Here is a sample code snippet of a component: export class BaseFormComponent implements OnInit { basicFormGroup: FormGroup; constructor( protected basicProviderService: BasicProviderService, protected formBuilder: FormBuilder, protected di ...

angulartypescripttestingangular9

connect the validation of forms to different components

I am currently working on components to facilitate the user addition process. Below is an example of my form component: createForm(): void { this.courseAddForm = this.formBuilder.group({ name: ['', [ Validators.required, ...

javascriptangulartypescript

Trigger the D3 component to re-render in React after a state change occurs in the parent component

My React project consists of two components written in TypeScript. The first component contains menus, and I am using conditional rendering to display different content based on user selection. <Menu.Item name="graph" active={activeItem ...

javascriptreactjstypescriptd3.js

Ways to resolve: The JSX component does not contain any construction or call signatures

I've been grappling with a persistent issue regarding the creation of custom elements dynamically in React TypeScript. If you're curious, you can check out the question here. const generalButtons: MenuButton[] = [ { text: "New Cl ...

javascriptreactjstypescriptmaterial-ui

I am attempting to retrieve custom cellRendererParams within the CustomCellRenderer class

I'm currently working with Ag-Grid in my angular application and am trying to implement a custom cell renderer. The tutorial I followed uses ICellRendererParams for the parameter type passed to the init event. agInit(params: ICellRendererParams): void ...

angulartypescriptag-gridag-grid-angular

Using masonry-layout with Next Js leads to a ReferenceError stating that window is not defined

Implementing the masonry-layout library by David Desandro in my Next app has been a smooth process. You can find the link here. When I apply it, the masonry layout functions perfectly as intended. Here's how I'm incorporating it successfully: imp ...

reactjstypescriptnext.js

Is there a way to determine the width of a ChildNode within a React component?

In my React and Typescript project, I am working on building a carousel of tabs with varying sizes. It is important for me to accurately calculate the width of each tab in order to determine how many tabs can fit within each view. The challenge I am facing ...

reactjstypescript

Having trouble getting a local npm installation to work from a specific file path?

After following the instructions from this helpful link to install an npm package through a file path, I encountered an error when attempting to use it: Cannot find module '<module_name>' or its corresponding type declaration Are there an ...

javascripttypescriptnpm

Utilizing Global Variables and Passing Values in Ionic 3

It seems like my issue is rather straightforward, but there is definitely something eluding me. After logging in, I need to store a TOKEN for HTTP requests in a global variable. Upon successful login, the HTTP get method returns an object with the HTTP co ...

javascriptangularhttptypescriptionic3

What is the proper way to reference a computed symbol that has been inherited as a function in an extended class

As a newcomer to Typescript, my understanding of the code might be lacking. I am currently working with the Klasa framework, which is built on top of Discord bot framework using Discord.js. The framework recently introduced plugin functionality and there a ...

javascripttypescript

I am configuring Jest in my Vite and TypeScript-powered React project

I am having trouble with the relative path of the file I imported in App.test.tsx. It keeps showing me this error message: Cannot find module '@/components/items/card.tsx' from 'src/__tests__/App.test.tsx' Below is the code snippet: // ...

javascriptreactjstypescriptvitets-jest

Building Background Service Workers with React Scripts and webpack Configuration

I am currently developing a chrome extension using ReactJS and TS along with a service worker. Due to the new manifest V3 requirements, I am required to specify my service worker in a specific way: "background": { "service_worker": &q ...

reactjstypescriptgoogle-chromewebpackgoogle-chrome-extension

Seeking guidance on transforming a thunk-based create store into a promise-based one. Any suggestions?

I am currently transitioning my app from loading data from local storage to using Firebase. Firebase always returns a promise, so I need to adapt my existing store to work with the new Firebase data. Here is the original code snippet: export const loadSta ...

reactjstypescriptfirebase

When the boolean in RxJS skipWhile remains true

My current scenario involves a specific use-case: There is a service that queues calculation tasks assigned with a certain ID. I have set up an observable to monitor the status of the service. When the ID is still in the queue, the query result is true (i ...

javascriptangulartypescriptrxjs

Oops! The program encountered an issue where it couldn't access the "Point" property because it was undefined. This occurred while working with openlayers 3 and jsts on

I am currently working on implementing a buffer function for some features that have been drawn on a map following this particular example. However, I am encountering the following error: ERROR TypeError: Cannot read property 'Point' of undefin ...

angularjstypescriptbufferopenlayers-3jts