Hi All,
In the database the createdBy field holds "userid@test.com" which is the userid of the user. When i create a recordist using the respective table and have the OOTB search on createdBy field to get the record on using "John" or "Smith" as the search value , it doesnt return any record. But if search on email return the data. ( Note: John and Smith is the first and last name of the user). The custom grid in front end holds the Display field using user function. But as the recordlist is created on userid , search on First or Last name is not returning any record.
Multiple options tried: 1) Created a custom field , but user function cannot be called in custom field
2) Changed the data type field from text to User type in the mapped fields of RecordType and called in recordlist . Still not success , how the datatype conversion from Text to User is used. Maybe i am doing wrong here?
How can we leverage the OOTB search here instead of create a whole new search text box and its logic convert the first name and/last name to userid and then search.
Thanks in advance, appreciate the response.
Raj
Discussion posts and replies are publicly visible
Did you consider to add a custom record field that holds the data you want to search for?
I typically try to solve this by adding a drop down to select the user, instead of a free text search.
Thankyou for the response . It is for audit table and lot of users in system so the drop down list is bigger. Any other suggestions?
You can configure this record list in an interface via gridField() and should be able to create custom filters with any component you like. You can understand this in detail on my blog - appianspace.com/.../
That was my first sentence: "Did you consider to add a custom record field that holds the data you want to search for?"
Hi Harshit , Thanks for the response . We are using the custom gridField. I will check on the blog what we are missing to do .Will let you know if it works.
Thanks
Thanks for the response. I Tried with custom field, the issue was the common search box was not searching on display value . The search always does on the userid . Here custom field i was not able to make use of user function.