Format for where filter in Function

Format a WHERE filter for comparison operators in ChronoForms.

Overview

The issue occurs when using "greater than" or "less than" operators in a WHERE clause for a read data function.
Use the format `column_name/>:value` in the WHERE filter field, such as `year/>:2009` to retrieve rows where the column value is greater than the specified number.

Pr Proximate 15 Aug, 2018

Hi can someone please help me.
I have no idea how to format the where clausel for a read data Function inside ChronoConnectivity6.

ModelName: Match

the column year contains at which year this match was (1986 until 2018).

year:{var:>2019} /year:{data:>2019} / Match.year:{var:>2019} / Match.year:{data:>2019} are not working.

I have done those filters already in another project but never with "larger then / lower then"....

Query in words:
"Give me all Rows from table x where the value in column year is larger then 2009"

The "Give me all rows" part is already working ;-)

Thanks for a Hint

he healyhatman 15 Aug, 2018

Answer

1 Likes

year/>:2009

Pr Proximate 15 Aug, 2018

NICE!
thank you ;-)

This topic is locked and no more replies can be posted.