topic Due Date - Javascript in Alfresco Archive

Due Date - Javascript

davedran — Fri, 25 Oct 2013 02:43:21 GMT

Hi!I am trying to filter and list all records that will be due in 7 days.Is this correct? var now = new Date();var filter = {filterueByDate:[MIN TO \"" + (now.getDate()+7) + "\"]};Thank you.David

Re: Due Date - Javascript

rjohnson — Fri, 25 Oct 2013 14:04:50 GMT

I believe that the dates must be ISO8601 with the - quoted.

Re: Due Date - Javascript

kaynezhang — Sun, 27 Oct 2013 01:02:39 GMT

It depends on what record you want to filter and where.
By Due Date I guess you mean to use a filter on tasks page or on workflow instance.If so you can use dueBefore and dueAfter paramter in webscript api url.I you want to search the model directly use dueDate property in iso08601 format.

Re: Due Date - Javascript

davedran — Mon, 28 Oct 2013 06:45:29 GMT

Hi!

Thank you for your replies.

I did the following and it almost works

var filters = [label:"Due next 7 days ",filter:"@dueDate:[MIN TO \"" + now.getFullYear() + "-" + (now.getMonth()+1) + "-" + (now.getDate()+7) + "\"]"}];

It will list all of due records that will due within next 7 days, but it will also list all records that dates are less than today's date.

I only need to list records that are GTE (than today) and LTE (7 days from today).

I was not able to find any method in JavaScript called dueAfter (which sounds prefect for my need), that will list all due date from today and show records for next 7 days.

Appreciate your guidance.

Thank you.

David