Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
Read above post and implemented the same.Need to implement search feature only for 3 columns out of 10 columns of my grid.But search is working for all the columns.Please help me!
Solved! Go to Solution.
Hi @KN_9774047
You can refer to the attached entities to implement search feature in an Advanced Grid and use Query Parameter in your search.
Hope it will help!!
Hi @KN_9774047
Can you not modify your Query Filter to include those column names to which you want the apply the search to.
Here is a link with examples on Query Filter for search: Searching and Filtering in Advanced Grid
Do revert for more queries.
I am directly binding inbuilt property queryfilter to the service input now.
In that example it shows like below :
{"maxItems":100000,"query":{"filters":{"type":"OR","filters":[{"fieldName":"id","type":"LIKE","value":"%Rain%"},{"fieldName":"date","type":"LIKE","value":"%Rain%"},{"fieldName":"max_temp","type":"LIKE","value":"%Rain%"},{"fieldName":"min_temp","type":"LIKE","value":"%Rain%"},{"fieldName":"cold","type":"LIKE","value":"%Rain%"},{"fieldName":"visibility","type":"LIKE","value":"%Rain%"},{"fieldName":"wind","type":"LIKE","value":"%Rain%"},{"fieldName":"precipitation","type":"LIKE","value":"%Rain%"},{"fieldName":"events","type":"LIKE","value":"%Rain%"},{"fieldName":"image","type":"LIKE","value":"%Rain%"},{"fieldName":"key","type":"LIKE","value":"%Rain%"},{"fieldName":"location","type":"LIKE","value":"%Rain%"},{"fieldName":"source","type":"LIKE","value":"%Rain%"},{"fieldName":"sourceType","type":"LIKE","value":"%Rain%"},{"fieldName":"tags","type":"LIKE","value":"%Rain%"},{"fieldName":"timestamp","type":"LIKE","value":"%Rain%"}]}}}
But I donot want to specify any value.Value can be anything in the search field.How do I achieve it?
Hi @KN_9774047
You can refer to the attached entities to implement search feature in an Advanced Grid and use Query Parameter in your search.
Hope it will help!!
Thank you!!
Hi @KN_9774047.
If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.
Regards.
--Sharon