tmssoftware.com

Build my own Projection

BIZ TMS Aurelius
#1

Is it possible to create my own projection?
Is there an example of this?

I would like to create my own (complicated) calculation based on a projection.

As an example, I looked at the class function Substring in Aurelius.Criteria.Projections. I would like to create a unit with my own calculations that I can use within Aurelius.

Is there a documentation or an example project for this?

The calculations are not based on SQL, but are performed completely stand alone (I even want to put a REST API call there).

#2

Hi @Kaeswurm_Thomas.

Projections are used to be included in the SQL statement. If you don't want to use it in SQL statement, then it wouldn't make sense to use projections.

#3

I would like to use them already in queries built with Aurelius. However, they are not in the database, but are to be calculated in the server.

Use, just like e.g. "Substring" or like date functions e.g. "Year"

#4

But you said such calculations are not based on SQL, could be even a REST API call. I'm confused. Can you give a real example, please?

#5

I mean a function like "Substring", "Contains", ... which I program myself and which is called by Aurelius.

https://doc.tmssoftware.com/biz/aurelius/guide/queries.html#contains

I can use the function in QueryBuilder or general in "ObjectManager.Find" queries.

.Select(Linq['Name'].Substring(1, 5))
.Select(Linq['ProjectDate'].WorkingDaysUntil( '31.05.2023')

as an an example
.WorkingDayUntil( ADate: TDate) is a self-written function

© tmssoftware.com