[TYPO3-english] pt_extlist use daysInYear to sort dates

[Simon Schaufelberger (Schaufi)]

hi,
yes, what you write in the fields array will produce direct sql.

here are some examples: 
http://extlist.punkt.de/examples/typo3mysql/grouped-rows-single-column.html

Am 20.03.15 um 08:02 schrieb Sebastian Gärtner:
> Hi, Am trying to set up pt_extlist to give me a list sorted and sortable
> by the daysInYear (php is using %j in its strftime function)
> I dont really get what i can access with the field definition
>
> fields {
>          field1 {              table = table1
>            field = field1
>            isSortable = 1
>          }
> }
>
> Is this the pure access to one column eg. field or can i access
> something that i define in the baseFromClause
> Lets say this would work
>
> baseFromClause (
>              SELECT
>                  domain,
>                  years_paid,
>                  date_registered,
>                  date_registered + INTERVAL(YEAR(CURRENT_TIMESTAMP) -
> YEAR(date_registered)) + 0 YEAR AS currPeriod,
>                  date_registered + INTERVAL(YEAR(CURRENT_TIMESTAMP) -
> YEAR(date_registered)) + 1 YEAR AS nextPeriod
>              )
>
> It works in phpMyAdmin when i add the FROM clause which is not needed in
> baseFromClause or am i wrong?
>
> Now my question is can i define nextPeriod as a field and use as a
> column. What do i have to do to use it as a column?

-- 
Regards, Schaufi