filter-explain

Filter explain

Choose the project and input

Find the connected server's filter_* tools. Explain a missing connection. Keep calls on that server: names and IDs identify records only within the project it serves.

Use the complete original filter JSON. A filtered-list URL cannot be imported, and these tools do not fetch saved filters by name. If only a link or an unseen filter is supplied, ask for its JSON. For a successful build already in this conversation, reuse its confirmed finalSql and selected records instead of converting it again.

Freshly read the connected server's maintained, up-to-date entry point: filter_wiki_read with paths = ["README.md"].

Use its navigation and current tool guidance. Reuse pages within this explanation. Examples below name a tool and the arguments that carry the request; fill in the rest from the schema the server exposes. Use the actual input and returned paths. Tool names may have a server prefix.

1. Convert the original JSON to SQL

Pass the complete JSON unchanged to filter_json_to_sql as its filterJson object — for example this filter, customers aged 30 and over:

{
  "entityType": "User",
  "filterFactory": "and",
  "innerConditions": [{
    "entityType": "User",
    "filterFactory": "age",
    "value": {"mode": "concrete", "value": {"range": {"from": "30", "to": ""}, "unit": "Years"}}
  }]
}

Read the returned sql, selected records and warnings. The tool already attempts to resolve catalogue IDs to names; do not repeat successful lookups. status: read means the JSON was read, not that the platform has accepted the filter. unlabelled means some values remain unnamed; unsupported or UNSUPPORTED_FILTER(...) marks conditions the conversion cannot explain. Keep the original JSON and these gaps visible in your reasoning. Do not reconstruct a simpler filter to make them disappear.

2. Read the meaning and resolve remaining labels

Identify the root, fields, relations, operators and business concepts in the SQL. Search the wiki for each distinct concept whose meaning or limitations you need to establish, combining related terms in a regex and reusing relevant pages already read: