I am trying to create a list view for a record that allows me to use the search

brianc over 8 years ago

I am trying to create a list view for a record that allows me to use the search functionality to search for a specific date. I am currently using concat(rf!title, if(false,concat(rf!otherDatapoints,rf!otherDatapoints2),"") to allow the search function to search for variables that are not displayed in the title. Even with the date in the title, I cannot search for it. No matter how I try to manipulate the date variable(change to string, split by "/" and turn to string) coming into the list view via entity, I am still unable to search for the date. The search functionality works for every other field I am bringing in via entity, but the only one Appian cannot find is the date. Is there anyway to to enable search by date for a list view or a way to manipulate the date to allow the variable to be searched on?

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 8 years ago

@brianc To the best of my knowledge, your question can be answered in two parts:

1. Section 'Notes' under 'Record List' at https://forum.appian.com/suite/help/7.9/Record_Design.html says "When users search for records, only the rf fields of type Text and Integer that are used in the title value are searched. Avoid using fields of any other type in the title field because users may try to search on their values, but the expected records won't return in the search results."

2. If you format the contents of the field coming from entity, still it can't be used in the search criteria because only the fields are searchable in the search criteria but not the values which are modified while surfacing. Infact the formatted content should be a part of the columns in the source entity in order to use the same in the search criteria.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 8 years ago

@brianc To the best of my knowledge, your question can be answered in two parts:

1. Section 'Notes' under 'Record List' at https://forum.appian.com/suite/help/7.9/Record_Design.html says "When users search for records, only the rf fields of type Text and Integer that are used in the title value are searched. Avoid using fields of any other type in the title field because users may try to search on their values, but the expected records won't return in the search results."

2. If you format the contents of the field coming from entity, still it can't be used in the search criteria because only the fields are searchable in the search criteria but not the values which are modified while surfacing. Infact the formatted content should be a part of the columns in the source entity in order to use the same in the search criteria.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data