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
10 replies
Subscribers
9 subscribers
Views
2593 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi I have a scenario wherein I am displaying data in a grid on SAIL f
komalc3
A Score Level 1
over 9 years ago
Hi
I have a scenario wherein I am displaying data in a grid on SAIL form via. a!queryEntity.
I have to provide two filters to user of Start date and End date (both calendars) which actually will query the same column in my DB whose type is timestamp i.e. between the range of this start and end date selected, the data will be filtered in the grid.
If I try to achieve this via. where(search(....)) on a!queryEntity I get an output where my date in DB is equal to the date selected in user filter.
So I guess I need to do it via. a!queryEntity as a number of operators are available here, but not able to figure it out how to do the same.
Can any one please guide me how to achieve this functionality.
Thanks in advance....
OriginalPostID-182998
OriginalPostID-182998
Discussion posts and replies are publicly visible
Parents
0
Nick Vigilante
Appian Employee
over 9 years ago
I assume that the results you're getting are because Appian's global time is configured to be GMT-5. Is that correct?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Nick Vigilante
Appian Employee
over 9 years ago
I assume that the results you're getting are because Appian's global time is configured to be GMT-5. Is that correct?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data