First Credit Release Date and Time

Hi Experts,

I am new to Celonis and PQL. I am trying to build a PQL query to fetch, First Credit Release date of of each sales order /Sales Order Item. Can some one guide me on this?

Thanks in advance
Babu

Hi Babu,

Thanks for your question! You can use the PU_FIRST Statement, which returns the first element of the specified column for each element of the given child table. An order by expression can be set to define the order that should be used to determine the first element.

The Syntax would be something like this:
PU_FIRST ( child_table, parent_table.column [, ORDER BY parent_table.column] )

Hope that helpds,
Celonis Data Science Team