Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
1693 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
HI All
rameshm
over 7 years ago
How to fetch data from database the past 1 week data between 10 am of last week to 10 am.
we have two columns in database (submitted date and Completed date)
Please any suggestions appreciated.....
Thanks........
OriginalPostID-234899
Discussion posts and replies are publicly visible
Parents
0
ChristineH
Certified Lead Developer
over 7 years ago
If the week and times are always known, I like to create a view with this criteria. Then I allow Appian to pull the data back that is needed and not have to worry about doing the filtering. Not sure if that works in your use case, but something to think about.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
ChristineH
Certified Lead Developer
over 7 years ago
If the week and times are always known, I like to create a view with this criteria. Then I allow Appian to pull the data back that is needed and not have to worry about doing the filtering. Not sure if that works in your use case, but something to think about.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data