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
4 replies
Subscribers
11 subscribers
Views
1640 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Is there any way that we can search record by date field given in the title of t
satishs
over 8 years ago
Is there any way that we can search record by date field given in the title of the record.It doesn't work if we give the date field directly.
OriginalPostID-170377
OriginalPostID-170377
Discussion posts and replies are publicly visible
0
siddharthg837
over 8 years ago
Hi Satish, are you trying to display your date field as a text in your record title. As anything that user will be entering on the search box, is by default taken as string and searched accordingly.
You can make use functions of text/datetext to render your date on title.
If this still doesn't work, please feel free to share your code so that I/other forum members can look whats going wrong !
Hope it helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
satishs
over 8 years ago
Hi Siddharth,
I tried with below two option still records are not searchable on date field.
title:concat(rf!ID," - ",tostring(rf!CREAT_DT))
and
title:concat(rf!ID," - ",text(rf!CREAT_DT,"mmmm dd, yyyy"))
where ID is of type text
and CREAT_DT is of type date.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
satishs
over 8 years ago
Record is of type Entity Backed Record.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 8 years ago
To achieve this you'd have to have a field in the database entity that displays the date as text; you could use a view to format the date as text and use that as the source of the record, and then concatenate the date on the title of the list view item.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel