Introduction to React Query Builder

How to Create a React App With React Query Builder Using npm

Add Fields and Operators to React Query Builder

Getting started

How to Build a Multilingual React Site with Query Builder

Customize or Replace Default Component in React Query Builder

How to Configure Built-in Input Types in React Query Builder

How to Customize the React Query Builder ValueEditor Component

Configuration

Create SQL Queries With React formatQuery and valueProcessor

Push a React Query Builder API Server to Heroku With Git

Add a PostgreSQL Database to React Query Builder

How to Fetch Data From a React API

How to Build a Data Table in React With AG Grid

How to Visualize React API Data in a Graph With AG Charts

Integrating with an API

How to Build a New React API Endpoint

How to Add a New API and Variables to React Query Builder

How to Fetch and Display Data With React Query Builder

How to Add a Google Maps Object to a React Site

Geographic data

How to Bulk Edit Data With React Query Builder

How to Add Features to the React onClickUpdate Feature

How to Build Custom ValueEditor Components in React

Bulk edits

react

react-querybuilder

node-sass

postgresql

typescript

In this course we teach you how to create admin reports with React using a query builder. Admin reporting is a broad topic, and getting started can be overwhelming.

In five modules, we cover configuration of the query builder, setting up a server, displaying data in a grid, chart, and map, as well as some more advanced uses of the query builder. It's about three hours long and comes with code samples.

The course is taught by Jake Boone, who uses React Query Builder in real, mission-critical applications for a large engineering and construction firm.

In this course, we'll be using React Query Builder to create admin reports with complex filtering, bulk editing, data grids, charts, and maps.

Building Advanced Admin Reporting in React

 component of our query builder and tailor it to the different data types.

Create a React component in a file called 

. For now, the component should simply return 

; otherwise it should return the default 

import {
  ValueEditor as DefaultValueEditor,
  ValueEditorProps,
} from "react-querybuilder";

const ValueEditor = (props: ValueEditorProps) => {
  const { operator } = props;

  if (operator === "null" || operator === "notNull") {
    return null;
  }

  return <DefaultValueEditor {...props} />;
};

export default ValueEditor;

import React, { useState } from "react";
import QueryBuilder, { formatQuery, RuleGroupType } from "react-querybuilder";
import combinators from "./combinators";
import CombinatorSelector from "./CombinatorSelector";
import fields from "./fields";
import getOperators from "./getOperators";
import translations from "./translations";
import { Language } from "./types";
import ValueEditor from "./ValueEditor";

function App() {
  const [query, setQuery] = useState<RuleGroupType>({
    id: "root",
    combinator: "and",
    rules: [],
  });
  const [language, setLanguage] = useState<Language>("en");

  return (
    <>
      <select value={language} onChange={e => setLanguage(e.target.value as Language)}>
        <option value="en">English</option>
        <option value="es">Spanish</option>
      </select>
      <QueryBuilder
        fields={fields}
        getOperators={getOperators}
        query={query}
        onQueryChange={(q) => setQuery(q)}
        translations={translations[language]}
        combinators={combinators[language]}
        controlElements={{
          combinatorSelector: CombinatorSelector,
          valueEditor: ValueEditor,
        }}
      />
      <pre>{formatQuery(query, "sql")}</pre>
      <pre>{formatQuery(query, "json")}</pre>
    </>
  );
}

export default App;

---
title: How to Customize the React Query Builder ValueEditor Component
description: How to provide your own value editor in order to take full control of the rule manager
privateVideoUrl: https://fullstack.wistia.com/medias/aijufv4ftg
---

# Custom value editors

Now we'll customize the `ValueEditor` component of our query builder and tailor it to the different data types.

## Using the default `ValueEditor`

Create a React component in a file called `ValueEditor.tsx` and use that component as your custom `ValueEditor`. For now, the component should simply return `null` if the `operator` is `null` or `notNull`; otherwise it should return the default `ValueEditor` component from `react-querybuilder`.

```typescript { actualFilename=./protected/src/ValueEditor.tsx endChar=331 endLine=17 startChar=0 startLine=1 statedFilename=client/src/ValueEditor.tsx url=https&#x3A;//gitlab.com/fullstackio/books/building-advanced-admin-reporting-in-react/module_02/lesson_02.04/protected/src/ValueEditor.tsx }
import {
  ValueEditor as DefaultValueEditor,
  ValueEditorProps,
} from "react-querybuilder";

const ValueEditor = (props: ValueEditorProps) => {
  const { operator } = props;

  if (operator === "null" || operator === "notNull") {
    return null;
  }

  return <DefaultValueEditor {...props} />;
};

export default ValueEditor;
```

```typescript { actualFilename=./protected/src/App.tsx endChar=1308 endLine=44 startChar=0 startLine=1 statedFilename=client/src/App.tsx url=https&#x3A;//gitlab.com/fullstackio/books/building-advanced-admin-reporting-in-react/module_02/lesson_02.04/protected/src/App.tsx }
import React, { useState } from "react";
import QueryBuilder, { formatQuery, RuleGroupType } from "react-querybuilder";
import combinators from "./combinators";
import CombinatorSelector from "./CombinatorSelector";
import fields from "./fields";
import getOperators from "./getOperators";
import translations from "./translations";
import { Language } from "./types";
import ValueEditor from "./ValueEditor";

function App() {
  const [query, setQuery] = useState<RuleGroupType>({
    id: "root",
    combinator: "and",
    rules: [],
  });
  const [language, setLanguage] = useState<Language>("en");

  return (
    <>
      <select value={language} onChange={e => setLanguage(e.target.value as Language)}>
        <option value="en">English</option>
        <option value="es">Spanish</option>
      </select>
      <QueryBuilder
        fields={fields}
        getOperators={getOperators}
        query={query}
        onQueryChange={(q) => setQuery(q)}
        translations={translations[language]}
        combinators={combinators[language]}
        controlElements={{
          combinatorSelector: CombinatorSelector,
          valueEditor: ValueEditor,
        }}
      />
      <pre>{formatQuery(query, "sql")}</pre>
      <pre>{formatQuery(query, "json")}</pre>
    </>
  );
}

How to provide your own value editor in order to take full control of the rule manager

Learn

The newline Guide to Building Your First GraphQL Server with Node and TypeScript

Teach

Amelia Wattenberger

Author of Fullstack D3

Community

Building Advanced Admin Reporting in React

WELCOMEIntroduction

Introduction:

Start Here

Module 1: Getting started

Introduction: (1:18)

Introduction to React Query Builder

Lesson 1: (11:12)

How to Create a React App With React Query Builder Using npm

Lesson 2: (4:13)

Add Fields and Operators to React Query Builder

Module 2: Configuration

Lesson 1: (7:20)

How to Build a Multilingual React Site with Query Builder

Lesson 2: (6:58)

Customize or Replace Default Component in React Query Builder

Lesson 3: (4:35)

How to Configure Built-in Input Types in React Query Builder

Lesson 4: (11:19)

How to Customize the React Query Builder ValueEditor Component

Module 3: Integrating with an API

Lesson 1: (5:24)

Create SQL Queries With React formatQuery and valueProcessor

Lesson 2: (12:38)

Push a React Query Builder API Server to Heroku With Git

Lesson 3: (16:28)

Add a PostgreSQL Database to React Query Builder

Lesson 4: (6:10)

How to Fetch Data From a React API

Lesson 5: (11:37)

How to Build a Data Table in React With AG Grid

Lesson 6: (7:05)

How to Visualize React API Data in a Graph With AG Charts

Module 4: Geographic data

Lesson 1: (2:28)

How to Build a New React API Endpoint

Lesson 2: (7:33)

How to Add a New API and Variables to React Query Builder

Lesson 3: (9:22)

How to Fetch and Display Data With React Query Builder

Lesson 4: (11:23)

How to Add a Google Maps Object to a React Site

Module 5: Bulk edits

Lesson 1: (12:15)

How to Bulk Edit Data With React Query Builder

Lesson 2: (7:54)

How to Add Features to the React onClickUpdate Feature

Lesson 3: (10:01)

How to Build Custom ValueEditor Components in React

How to Customize the React Query Builder ValueEditor Component