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
6 replies
Subscribers
10 subscribers
Views
3874 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Record search criteria
ajinkyab277
Certified Lead Developer
over 7 years ago
Is there any way to search for record under Record tab by cutom search field
OriginalPostID-249010
Discussion posts and replies are publicly visible
Parents
0
PhilB
A Score Level 1
over 7 years ago
Another option for an entity backed record is to create a view and map the record to that view rather than simply using the table. You'll then be able to add custom fields in that view (and related CDT) just for searching, and use the (officially unsupported) method to enable them as searchable.
A good example of this is dates. Add a field to the database view that casts a date (eg a start date) to text using a date format function so that you get a text field containing values such as "24 November 2016", add it to the record via the concat() method, and your record will be searchable using values like "nov 2016" or "24 nov".
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
PhilB
A Score Level 1
over 7 years ago
Another option for an entity backed record is to create a view and map the record to that view rather than simply using the table. You'll then be able to add custom fields in that view (and related CDT) just for searching, and use the (officially unsupported) method to enable them as searchable.
A good example of this is dates. Add a field to the database view that casts a date (eg a start date) to text using a date format function so that you get a text field containing values such as "24 November 2016", add it to the record via the concat() method, and your record will be searchable using values like "nov 2016" or "24 nov".
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data