Blog

All Blog Posts | Next Post | Previous Post

Customize your Select queries in StellarDS.io with Select, Distinct and new Operators!

Thursday, September 12, 2024

StellarDS.io has been released for a little less than a month already. One of the more requested features was more ways to customize the select queries performing server-side filtering. With the latest version of StellarDS.io, you are now able to select distinct values, select only a few fields of your table and you can customize your where query with extra SQL operators to get the most optimized result you need in your application.

Select

If you only require a few columns of your data to process, you can now implement the new select parameter. Simply add the required fields you need, and the service will only return those. This increases the performance of your queries as you'll no longer need to retrieve unnecessary data.

https://api.stellards.io/v1/data/table?project={projectID}&table={tableId}&distinct=true&select={fieldA}

Distinct

If you want all unique records in your table, you can now use the Distinct query parameter. You'll need to combine this with the Select parameter so that the database knows which distinct values to check for. By default, this list will be ordered on the first select field you've added, but you can override this using the Sort Query.

Where Operators

The following operators have been added to the list of operators you can use to customize which data needs to be fetched. Instead of using the written operators you can now also use the symbols like <=, >=, !=, =, ... to create your queries.

https://api.stellards.io/v1/data/table?project={projectID}&table={projectID}&WhereQuery={fieldName}%3Bnull%3Btrue%26{fieldB}%3Blike%3B{Value}&distinct=false

Operator	Description	Example
smallerthan_equal \| <=	returns all values that are smaller or equal to x	fieldA;<=;5
largerthan_equal \| >=	returns all values that are larger or equal to x	fieldB;largerthan_equal;6
not_equal \| <> \| !=	Checks if values are different	fieldB;!=;stringvalue
null	Checks if the value is null or not null	FieldA;null;true
notlike	checks if the value does not correspond with a certain pattern	FieldC;notlike;%string%

TMS WEB Core & FNC Cloud Pack

The latest version v2.6 of TMS WEB Core will already support these new features out of the box and you can experiment with these right now. TMS FNC Cloud Pack support for these features will come soon. In the spirit of low-code RAD component based development, these components will make setup even faster. You will only need to provide a few settings to get you up and running, no endpoints to learn or HTTPs requests to make yourself.

You can read more about these components here:

Or use our Start Guide and set everything up manual in every framework or language to you want.

Launch Offer!

To celebrate the launch of StellarDS.io we are offering a 10% discount on your first year when purchasing a yearly license or a 10% discount for the first 6 months when purchasing a monthly license.

TMS Software Delphi Components

Use code LAUNCHYEAR or LAUNCHMONTH respectively at checkout to apply the discount.

Ready to learn more?

Want to experience the power of StellarDS yourself? Don’t miss the TMS Training Days session on Thursday, September 26th. Join us for an in-depth guide and get ready to create back-ends without effort!