Wishlist 0
Compare 0
Account Cart 0
Start Selling
-85% OFF PHP SCRIPTS Data Builder — Visual Reporting, REST API  GraphQL for Perfex CRM
PHP SCRIPTS

Data Builder — Visual Reporting, REST API GraphQL for Perfex CRM

Create cross-module reports inside Perfex CRM without writing SQL. Data Builder provides visual tools for combining tables, filtering records, and generating custom data views from a single interface. Teams gain faster access to operatio…

★★★★★ 4.7 (237 reviews) · 3,137 sales · In stock
₹9 ₹59 Save 85%
  • Go to Data Builder > Builder from the side menu.
  • Type “View Name” as Client Invoices and “Route” as client-invoices.
  • Select Data:Search and add tblclients (Base Table).Search and add tblinvoices. The system will auto-detect the join (tblclients.userid = tblinvoices.clientid).
  • Search and add tblclients (Base Table).
  • Search and add tblinvoices. The system will auto-detect the join (tblclients.userid = tblinvoices.clientid).
Instant DownloadRight after payment
30-day RefundNo questions asked
Secure CheckoutRazorpay protected
WHAT'S INCLUDED

Everything You Need Out of the Box

Carefully crafted features that ship with this product — no extra setup, no hidden costs.

Go to Data Builder > Builder from the side menu.

Type “View Name” as Client Invoices and “Route” as client-invoices.

Select Data

Search and add tblclients (Base Table).Search and add tblinvoices. The system will auto-detect the join (tblclients.userid = tblinvoices.clientid).

Search and add tblclients (Base Table).

Search and add tblinvoices. The system will auto-detect the join (tblclients.userid = tblinvoices.clientid).

Design View

Drag company field from tblclients to the canvas. Rename Alias to “Client Name”.Drag total and status fields from tblinvoices.

Drag company field from tblclients to the canvas. Rename Alias to “Client Name”.

Drag total and status fields from tblinvoices.

Customer Rating

4.7/5 From 237 verified buyers

Sales

3,137+ Trusted by businesses worldwide

Setup Time

< 5 min From download to live
ABOUT THIS PRODUCT

Built to Scale & Convert

Create cross-module reports inside Perfex CRM without writing SQL. Data Builder provides visual tools for combining tables, filtering records, and generating custom data views from a single interface. Teams gain faster access to operational insights while keeping reporting workflows simple and controlled.
Data Builder is a visual query builder and custom reporting module designed for Perfex CRM. It allows administrators and staff to combine data from multiple CRM modules and generate structured views, reports, or dashboards without manually writing SQL queries.
In many CRM environments, important data such as clients, invoices, tasks, or projects resides in separate database tables. Data Builder addresses this limitation by offering a visual environment where users can join tables, apply filters, and build structured data outputs that can be viewed or exported. This approach helps teams produce cross-module insights while maintaining a manageable reporting workflow.

Quick Start

Follow these simple steps to build a “Client Invoice Report”:

  • Go to Data Builder > Builder from the side menu.
  • Type “View Name” as Client Invoices and “Route” as client-invoices.
  • Select Data:
    1. Search and add tblclients (Base Table).
    2. Search and add tblinvoices. The system will auto-detect the join (tblclients.userid = tblinvoices.clientid).
  • Design View:
    1. Drag company field from tblclients to the canvas. Rename Alias to “Client Name”.
    2. Drag total and status fields from tblinvoices.
  • Filter: Click “Add Filter” -> Select tblinvoices.status -> Operator = -> Value 2 (Overdue).
  • Preview: Click the “Run Preview” button to see the data visually on screen.
  • Save: Click “Save View”. You can now access this report at /admin/data_builder/runtime/view/client-invoices.

Core Features

1. Visual Builder

The builder interface is the core of the module. It features:

  • Drag & Drop Canvas: Intuitively arrange your data columns.
  • Concatenated Fields: Combine multiple database columns (e.g. First Name + Last Name) into a single virtual field with custom separators. Supports merging fields from different joined tables.
  • Smart Table Search: Quickly find database tables by searching for their display name, internal system name (e.g., tblclients), or short name. The module fully supports querying data from core Perfex tables as well as any third-party module tables based on the database schema.
  • Field Management: Rename columns with user-friendly Aliases. Toggle visibility to hide ID columns used only for joining/filtering.
  • Live Preview: See the results of you r query in real-time as you design.
Get this product
HOW IT WORKS

From Purchase to Launch in 4 Simple Steps

Get up and running in minutes — no fluff, no waiting around.

01

Purchase Securely

Complete checkout via Razorpay-secured payment.

02

Instant Download

Files are available immediately in your account.

03

Quick Setup

Follow the included docs — usually under 5 minutes.

04

Launch & Grow

Customize, deploy, and scale to your audience.

CUSTOMER REVIEWS

What Buyers Are Saying

4.7
★★★★★

Based on 237 verified reviews

5★
70%
4★
22%
3★
5%
2★
2%
1★
1%
R
Rohit K.Verified Buyer
★★★★★

"Excellent quality and instant delivery. The documentation is super clear and setup was a breeze. Highly recommend!"

P
Priya S.Verified Buyer
★★★★★

"Perfect for our use case. Saved us weeks of development time. Support team responded within an hour."

A
Amit P.Verified Buyer
★★★★☆

"Clean code, easy to customize. Worth every rupee. Looking forward to future updates."

READY TO LAUNCH?

Get Data Builder — Visual Reporting, REST API GraphQL for Perfex CRM

Join 3,137+ customers who trust this product to power their business.

₹9-85% OFF

DDTECH Digital Products

Login
Shopping Cart
Your cart is empty

Add some digital goodies and they'll show up here.

Browse Shop →