velocity - Comparing dates from PocketQuery -



velocity - Comparing dates from PocketQuery -

i'm trying create simple programme takes date , marks red, greenish or yellowish depending how far "today()" is.

i'm using pocketquery http://www.scandio.de/en/atlassian-en/plugins/pocketquery utilize log time oracle database, query loads fine , have nice little $result list.

this date

below used illustration template found in pocketquery doc utilize first step in getting script work. simple datetime compare. variable log_time in datetime format.

this script loops through result , x each row.

i've tested $dateformatter.getcurrentdatetime() , outputs right time. must reading of result think.

the next step compare more finegrained, check if log_time say...30 min set date , color yellowish first step compare working.

<style> .high { background: red; } .low { background: yellow; } </style> <table class="pocketquery-table confluencetable"> <tr> #foreach ($column in $columns) <th>$!column</th> #end </tr> #foreach ($row in $result) <tr class="#if($row.log_time < $dateformatter.getcurrentdate())high#{elseif} ($row.log_time > $dateformatter.getcurrentdatetime())low#end"> #foreach ($column in $row) <td>$!column</td> #end </tr> </table>

tldr:

how compare date got pocket query date velocity (dateformat, date, whatever)?

i update guys on progress. i've got code working closely want.

<style> .high { background: red; font-weight: bold;} .low { background: greenyellow; font-weight: bold; } </style> ##create instance of calender #set($todayateight = $calendar.getinstance()) ##set time, todo..check if there improve way of doing this... $todayateight.set(15, 10) $todayateight.set(12, 46) $todayateight.set(13, 5) $todayateight.gettime() <br/> <table> ##loop result #foreach ($row in $result) ##save parameter rowdate #set($rowdate = $calendar.getinstance()) $rowdate.settime($row.logg_tid) #if($todayateight.before($rowdate)) <tr class="low"> #else <tr class="high"> #end <td> $dateformatter.formatgivenstring("yyyy-mm-dd hh:mm:ss", $row.logg_tid) </td> <td> $row.dvh_area </td> </tr> #end </table>

velocity confluence

Comments

Post a Comment

Popular posts from this blog

java Multi query from Mysql using netbeans -

java Multi query from Mysql using netbeans - i have java code retrieve info mysql appropriate code in netbeans.the code below. want multi query such illustration finding total number of products , on.could help me please. in advance import java.sql.*; public class javamysqlselectexample { public static void main(string[] args) { seek { string mydriver = "com.mysql.jdbc.driver"; string myurl = "jdbc:mysql://localhost/sample"; class.forname(mydriver); connection conn = drivermanager.getconnection(myurl, "root", "mypasscode1"); string query = "select * products"; statement st = conn.createstatement(); resultset rs = st.executequery(query); while (rs.next()==true) { int code = rs.getint("code"); string productname = rs.getstring("product_name"); string producttype = rs.getstring("product_type"); system.out.format(" %d, %s, %s\n", code, pr
Read more

c# - DotNetZip fails with "stream does not support seek operations" -

c# - DotNetZip fails with "stream does not support seek operations" - i using dotnetzip in c# unzip stream follows: public static void unzipfromstream(stream stream, string outdir) { //omit seek grab block using (zipfile zip = zipfile.read(stream)){ foreach (zipentry e in zip){ e.extract(outdir, extractexistingfileaction.overwritesilently); } } } stream obtained using webclient client = new webclient(); stream fs = client.openread(url); however, got next exception exception during extracting zip stream system.notsupportedexception: stream not back upwards seek operations. @ system.net.connectstream.get_position() @ ionic.zip.zipfile.read(stream zipstream, textwriter statusmessagewriter, encoding encoding, eventhandler`1 readprogress) on server side(asp.net mvc 4), returning filepathresult or filestreamresult both caused exception. should obtain stream differently on client side? or how create server homec
Read more

c++ - StartServiceCtrlDispatcher don't can access 1063 error -

c++ - StartServiceCtrlDispatcher don't can access 1063 error - i write on c++ service , have error, , don't can fixed it. my service main function int main (int argc, tchar *argv[]) {dword f; for(int i=0;i<113;i++) f = getlasterror(); servicepath = lptstr(argv[0]); outputdebugstring(_t("my sample service: main: entry")); //installservice(); service_table_entry servicetable[] = { {service_name, (lpservice_main_function) servicemain}, {null, null} }; // startservice(); if(!startservicectrldispatcher(servicetable)) { f = getlasterror(); //addlogmessage("error: startservicectrldispatcher"); } else if( memcmp(argv[argc-1],"install",7)) { installservice(); } else if( memcmp(argv[argc-1],"remove",6)) { removeservice(); } else if( memcmp(argv[argc-1],"start",5)) { startservice(); } else if( memcmp(argv[argc-1],"stop",4))
Read more