Solved

Searching Dates for Tasks - 2 weeks ago


Userlevel 3
Badge +8

Trying to search for all planned start dates that are 14 days old.

I can search using >TODAY but cant find out what other functions i could use to search for dates without actually using dates. Can’t use “Yesterday” or “Last Week”

 

if i do try one of those i get the following value

 

 

icon

Best answer by AdrianEgley 16 September 2020, 18:29

@jbernardo,

 

Just seen this from last month.

Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.

Basically it loads the task screen with these in the date fields.

 

So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.

 

Regards


Ady

View original

17 replies

Badge +3

Dear jbernardo, 

where are you trying to search? In the Search Menu?  Lobby? Business Rule?

Mostly you can use the SQL Possibilities.  For Lobbys there are specific Parameters that can be used. 

 

Best regards

Userlevel 3
Badge +8

Hi @Jacqueline.Lyra 

Anytime a user is trying to search for something. In this example want to look at what was created on (2 weeks ago for example)

 

i can put >TODAY but i cant put anything else as it wants a DateTime

 

Userlevel 5
Badge +9

jbernardo,

Weird that that seems to be the only one reacting. However >now performs the same (most likely the current time is also part of the selection).

Sorry of being of no real help,

Steve 

Userlevel 4
Badge +7

Honestly not an expert in aurena or mobile but I would expect the same substitution variables from the enterprise explorer to work there. 
 

are you familiar with the substitution variables in EE? 

Userlevel 5
Badge +9

JULIAN,

This is an FSM question. It seems that IFS has not, yet, come to the stage that the search options are build the same way in FSM and IFS Applications (be it EE or Aurena).

Help text of FSM reveals nothing at this moment (or I missed it).

Regards,

Steve

Badge +3

try them

They are working for me in FSM 6 Update 4 but also should work in older versions.

  • TODAY
  • TOMORROW
  • YESTERDAY
  • START_OF_THIS_WEEK
  • START_OF_NEXT_WEEK
  • START_OF_LAST_WEEK
  • START_OF_THIS_MONTH
  • START_OF_NEXT_MONTH
  • START_OF_LAST_MONTH
  • START_OF_THIS_YEAR
  • START_OF_NEXT_YEAR
  • START_OF_LAST_YEAR
  • END_OF_THIS_WEEK
  • END_IF_NEXT_WEEK
  • END_OF_LAST_WEEK
  • END_OF_THIS_MONTH
  • END_OF_NEXT_MONTH
  • END_OF_LAST_MONTH
  • END_OF_THIS_YEAR
  • END_OF_NEXT_YEAR
  • END_OF_LAST_YEAR

As you mentioned that Yesterday isn’t working, it’s working in my system:

Badge +3

I tried following example:

Userlevel 5
Badge +9

Most likely it is version related. We are using FSM6 Update 2 and I get the following:

 

Badge +3

It could has to do also with this column definition. Try it with created

Userlevel 5
Badge +9

Apperently not:

Left the Planned Start blank and filled the Created field.

Userlevel 3
Badge +8

try them

They are working for me in FSM 6 Update 4 but also should work in older versions.

  • TODAY
  • TOMORROW
  • YESTERDAY
  • START_OF_THIS_WEEK
  • START_OF_NEXT_WEEK
  • START_OF_LAST_WEEK
  • START_OF_THIS_MONTH
  • START_OF_NEXT_MONTH
  • START_OF_LAST_MONTH
  • START_OF_THIS_YEAR
  • START_OF_NEXT_YEAR
  • START_OF_LAST_YEAR
  • END_OF_THIS_WEEK
  • END_IF_NEXT_WEEK
  • END_OF_LAST_WEEK
  • END_OF_THIS_MONTH
  • END_OF_NEXT_MONTH
  • END_OF_LAST_MONTH
  • END_OF_THIS_YEAR
  • END_OF_NEXT_YEAR
  • END_OF_LAST_YEAR

As you mentioned that Yesterday isn’t working, it’s working in my system:

Unfortunately none work in FSM 5.7 :( 

Userlevel 3
Badge +8

try them

They are working for me in FSM 6 Update 4 but also should work in older versions.

  • TODAY
  • TOMORROW
  • YESTERDAY
  • START_OF_THIS_WEEK
  • START_OF_NEXT_WEEK
  • START_OF_LAST_WEEK
  • START_OF_THIS_MONTH
  • START_OF_NEXT_MONTH
  • START_OF_LAST_MONTH
  • START_OF_THIS_YEAR
  • START_OF_NEXT_YEAR
  • START_OF_LAST_YEAR
  • END_OF_THIS_WEEK
  • END_IF_NEXT_WEEK
  • END_OF_LAST_WEEK
  • END_OF_THIS_MONTH
  • END_OF_NEXT_MONTH
  • END_OF_LAST_MONTH
  • END_OF_THIS_YEAR
  • END_OF_NEXT_YEAR
  • END_OF_LAST_YEAR

As you mentioned that Yesterday isn’t working, it’s working in my system:

we will chalk this up to an version issue. Thanks everyone!

Userlevel 2
Badge +4

@jbernardo,

 

Just seen this from last month.

Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.

Basically it loads the task screen with these in the date fields.

 

So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.

 

Regards


Ady

Userlevel 3
Badge +8

@jbernardo,

 

Just seen this from last month.

Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.

Basically it loads the task screen with these in the date fields.

 

So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.

 

Regards


Ady

Yes this works! Thank you. Wish i could change this to the “Best Answer”

 

Much apprecaited!

Userlevel 1
Badge +3

<Now.AddDays(-14) is what you are looking for

 

also I include this document from Reference doc with some adaptations of my own

Userlevel 3
Badge +8

<Now.AddDays(-14) is what you are looking for

 

also I include this document from Reference doc with some adaptations of my own

This is amazing and a HUGE help

thank you so much!

Userlevel 4
Badge +4

@jbernardo,

 

Just seen this from last month.

Surprisingly its in the reference guide, the one I have for FSM5.7U11 is on Pg14. Look for Search Variables. But I have a Lobby that navigates to the Task screen with a pre-determined search.

Basically it loads the task screen with these in the date fields.

 

So if you were to have the created on search value have >today.AddDays(-14) that will give you the last 2 weeks of data.

 

Regards


Ady

Yes this works! Thank you. Wish i could change this to the “Best Answer”

 

Much apprecaited!

I’ll update the Best Answer for you :D 

Reply