skills.rest
api-evangelist
api-evangelistOFFICIAL
Explore all skills by this author →
WebsiteGitHub

filter-and-query

Builds filter, search, and sort queries for Frontline CLI record listings.

Updated Jul 27, 2026
Search Tags:#cli#search#query#filter#records#sort#frontline
One-click install
npx skills add https://github.com/api-evangelist/frontline --skill filter-and-query-api-evangelist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: filter-and-query
Source: https://github.com/api-evangelist/frontline/tree/main/skills/vendor/filter-and-query
Command: npx skills add https://github.com/api-evangelist/frontline --skill filter-and-query-api-evangelist

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Finding specific records in Frontline tables and objects requires constructing JSON query conditions with the correct operators, field paths, and tag IDs, which is error-prone without a reference. ## Core Features & Use Cases - Condition Building: Construct single or nested AND/OR query conditions using operators for string, number, date, tag, relation, boolean, and formula fields. - Text Search and Sorting: Apply full-text search across fields and multi-level sort specifications via the --search and --sort flags. - Pagination and Record Type Filtering: Control result pages with --page and --page-size, and filter object records by numeric record type ID. - Use Case: Find all open deals worth over $10,000 linked to a company, sorted by amount descending, by composing a single frontline object record list command with a nested query JSON. ## Quick Start Ask the assistant to list all Frontline deals with status Open and amount greater than 10000, sorted by amount descending.

Frequently Asked Questions about filter-and-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I filter records in the Frontline CLI?▼

Pass a JSON condition to the --query flag of frontline table row list or frontline object record list. Each condition specifies a field path in bracket notation, an operator like equals or gte, and a value.

How do I combine multiple filter conditions with AND/OR logic?▼

Wrap conditions in a group object with operator set to "and" or "or" and a conditions array. Groups can be nested, so you can express logic like (Status is Open AND Amount >= 10000) OR Priority is Urgent.

Why does my tag field filter return no results?▼

Tag fields require numeric tag IDs, not tag names, in operators like containsAny or containsAll. Run frontline table field list or frontline object field list to find the tag IDs in each field's options array.

Can I filter records through a related record's field?▼

Yes, relation paths use dot notation such as [Company].[Name] to query a field on a linked record. Relation fields themselves support containsAny, notIn, isNull, and isNotNull operators.

What is the maximum page size for Frontline record listing?▼

The --page-size flag defaults to 50 and caps at 200 items per page. Use --page to navigate through additional result pages.

Related Skills

Explore More Data & Analytics Skills→
openaiopenai
5.3k

airtable-filters

Build Airtable record filters using field IDs, operators, and nested AND/OR logic.

Official
Intermediate
naveedharrinaveedharri
53

crm-prospect-mining

Cross-reference CRM pipeline records with LinkedIn company data to identify high-value prospects.

Community
Advanced
LeonChaoXLeonChaoX
783

gene-database

Retrieve NCBI Gene metadata via E-utilities and Datasets API.

Community
Intermediate
OneIdentityOneIdentity
24

api-patterns

Resolve Safeguard Web API failures with correct cmdlet selection and request shaping.

Official
Advanced