+13Trying 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
Best answer by AdrianEgley
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
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
+13Anytime 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
+21jbernardo,
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
+9Honestly 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?
+21JULIAN,
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
try them
They are working for me in FSM 6 Update 4 but also should work in older versions.
As you mentioned that Yesterday isn’t working, it’s working in my system:
+21Most likely it is version related. We are using FSM6 Update 2 and I get the following:
+21Apperently not:
Left the Planned Start blank and filled the Created field.
+13try them
They are working for me in FSM 6 Update 4 but also should work in older versions.
As you mentioned that Yesterday isn’t working, it’s working in my system:
Unfortunately none work in FSM 5.7 :(
+13try them
They are working for me in FSM 6 Update 4 but also should work in older versions.
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!
+14
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
+13
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!
<Now.AddDays(-14) is what you are looking for
also I include this document from Reference doc with some adaptations of my own
+13<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!
+24
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
