Filter Query Parameters in ORDS with AutoREST Tables

News, , , , , , , , , , , , , , , , ,

Demo, show me the demo! Make your power points and blog posts come to life! Demonstrating a REST API via cURL or Postman can be tedious, or even boring.

If I had time, I’d make a local web app to show it off. But since I don’t have much time, I’ll do the next best thing, have my AI Agent build an app for me!

I have Oracle AI Database (26ai, but 19c, 21c, or 23ai are fine too.) I have Oracle REST Data Services (ORDS) 25.4. I have a table, EMPLOYEE. It is registered for ORDS, to enable the AutoREST feature.

Our Oracle AI Database REST API tables make working with your data easy. I can EARN

JSON

About 5 minutes later, I had a working app.

Quite a lot, meaning I needed to make the following corrections in the follow-up instructions:

My app lets me toggle/enter filters and sorting criteria, and it simply prints the QBE JSON, and previews the full ORDS URL for the GET request.

And our application takes that input and decides that it can be obtained via this QBE JSON payload in the query parameters:

JSON

My web page source is below. I did QA for about 10 minutes, so I’m sure more cleanup is needed, but it’s a good start.

The interesting part of the code above is the FILTER BUILDER section which starts at line 700.

HTML

People would think I’ve done it all, but no. We have some cool things cooking in version 26.1 which will be released in a few weeks. Think… VECTOR SEARCH.

PakarPBN

A Private Blog Network (PBN) is a collection of websites that are controlled by a single individual or organization and used primarily to build backlinks to a “money site” in order to influence its ranking in search engines such as Google. The core idea behind a PBN is based on the importance of backlinks in Google’s ranking algorithm. Since Google views backlinks as signals of authority and trust, some website owners attempt to artificially create these signals through a controlled network of sites.

In a typical PBN setup, the owner acquires expired or aged domains that already have existing authority, backlinks, and history. These domains are rebuilt with new content and hosted separately, often using different IP addresses, hosting providers, themes, and ownership details to make them appear unrelated. Within the content published on these sites, links are strategically placed that point to the main website the owner wants to rank higher. By doing this, the owner attempts to pass link equity (also known as “link juice”) from the PBN sites to the target website.

The purpose of a PBN is to give the impression that the target website is naturally earning links from multiple independent sources. If done effectively, this can temporarily improve keyword rankings, increase organic visibility, and drive more traffic from search results.

Jasa Backlink

Download Anime Batch