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
+1
person also asked this
people also asked this
Replies
10 replies
Subscribers
10 subscribers
Views
5163 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I am trying to search for records using the text box search feature and no matte
benjamins
over 10 years ago
I am trying to search for records using the text box search feature and no matter what I am searching for, I am getting back no "No records available".
I am searching for values that is in the title and details section of the list view item and I am getting back nothing. Even single letter queries are returning back nothing.
What am I missing?
OriginalPostID-145861
OriginalPostID-145861
Discussion posts and replies are publicly visible
0
benjamins
over 10 years ago
I can search on the id of the record, but that is not going to help the users as they want to be able to search for anything that is displayed in either the title or the details of the list view item.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
1. What kind of record is this?
2. Can you attach some relevant screenshots showing the behavior (expected vs observed)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Question #1 is because as stated here:
forum.appian.com/.../Records_Tutorial.html
users can automatically perform searches on entity-backed and process-backed records but for service-backed records, we need to enable it by capturing the search term from the query object in a local variable and then using the value to configure a filter on the data.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
benjamins
over 10 years ago
It is a Data Store Entity record. 10 is the ID of the record. If I search for TCR, I get nothing back
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Do you have any other entity back-ed records to test this feature with? To make sure the issue is limited to this record or if the whole feature is not working.
It works for me (see attachment)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
benjamins
over 10 years ago
I just have the one. I can search the default users records fine. I can search the reports fine. Its just the record I created that is causing issues.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
benjamins
over 10 years ago
I should also mention that I am referencing a database view that I created a datastore entry and CDT for if that makes a difference.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
That should work too. I suggest you follow the tutorial of
forum.appian.com/.../Records_Tutorial.html
just to make sure the issue is only with your specific entity back-ed record since none of the other records you mention are of this type.
I can also send you an example for you to import and test if you prefer that over creating the example from the tutorial.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 10 years ago
The search box searches only the data used for the id of the list view items and the text used for the title attribute of the list view items. If you want to search on additional fields, they must be used in the title attribute.
There is an (officially unsupported) workaround that allows you to search on fields that aren't displayed as part of the title - just configure the list view items something like the below. This means the fields are used in the title but never actually displayed, so they don't show but become searchable.
a!listViewItem(
title: fn!concat(
rf!title,
if(
false,
concat(
rf!someOtherField1,
rf!someOtherField2
),
""
)
)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
benjamins
over 10 years ago
I solved my issue.
Before I was using a view, I was using the rf!id to lookup the tables referencing database table data where appropriate. I did not realise that this data was then not searchable.
Once I updated my references to now use the view record fields, the data was searchable.
Thanks Eduardo and philb for your advice.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel