2. PHPRunner General questions
  3. [SOLVED]  phprunner 9.8 strip datetime filter
This topic is locked
[SOLVED]

 phprunner 9.8 strip datetime filter

 		7/6/2017 11:20:48 PM
PHPRunner General questions
F
 firecloud author

This code bellow working version on 9.7



AND t1.STARTTIMESTAMP BETWEEN CONVERT_TZ(

'2017-07-06 10:08',

'+07:00',

'+00:00'

)

AND CONVERT_TZ(

'2017-07-07 10:08',

'+07:00',

'+00:00'

)



after the upgrade all code behind : will striped



AND (

`t1`.`STARTTIMESTAMP` BETWEEN CONVERT_TZ(

'2017-07-06 10',

'+07',

'+00'

)

AND CONVERT_TZ(

'2017-07-07 10',

'+07',

'+00'

)

)



this query bellow also not working tested in Build 29111

SELECT

ID,

convert_tz(DT, '+00:00', '+07:00') AS DT,

SYS,

GRP,

IN,

OUT,

OUTOK,

INOK

FROM SYSSYS
admin 7/11/2017

We will fix this issue in couple of days. Related to new "variables" functionality we added in PHPRunner 9.8.