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
2592 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
komalc3
A Score Level 1
over 9 years ago
Hi Nick
Thank you for the explanation of userdatetime().
I have used userdatetime() as the data being displayed on my SAIL is on the basis of this only.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
komalc3
A Score Level 1
over 9 years ago
Hi Nick
Thank you for the explanation of userdatetime().
I have used userdatetime() as the data being displayed on my SAIL is on the basis of this only.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data