Skip to main content
K
KN_97740471-Visitor
1-Visitor
February 23, 2021
Solved

Search functionality on Advanced grid for selected columns

  • February 23, 2021
  • 2 replies
  • 2657 views

https://community.ptc.com/t5/ThingWorx-Developers/how-do-I-search-specific-entity-in-grid-Advanced/td-p/687561

 

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!

Best answer by suverma

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!!

2 replies

S
suverma14-Alexandrite
14-Alexandrite
February 23, 2021

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.

K
KN_97740471-VisitorAuthor
1-Visitor
February 23, 2021

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?

S
suverma14-AlexandriteAnswer
14-Alexandrite
February 24, 2021

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!!

S
slangleyCommunity Manager
Support
February 25, 2021

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

Terms & ConditionsAccessibility statement