how do I search specific entity in grid Advanced??

[RM12]

Hello,

          I'm using Thingworx 9.0 version ,I want to find specific entity in grid Advanced I have ticked EnableGridSearch property How do I search specific entity in grid advanced??please refer below attachment.

Thanks in advance

[emscur]

Hello @RM12,

The search functionality is related to the Filter event and Query property of the Advanced Grid. 

1. Add a Query input parameter to the custom service returning infotable
2. Edit custom service and apply the query to the infotable 
   • Now your service will return the queried infotable every time it is called
3. Bind the Filter event of Advanced Grid to the service
   
   • Whenever the search query changes, the service will be called
4. Bind the Query property of Advanced Grid to the service input parameter of type Query

Find the code snippet to be implemented in your custom service below:

var params = {
	t: <your infotable> /* INFOTABLE */,
	query: <the input query> /* QUERY */
};

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].Query(params);

Regards,

Emmanuel

[RM12 · Accepted solution]

Thank you so much for your answer! It works

[slangley]

Hi @RM12.

Since you have resolved the issue, could you please mark the post from emscur as the Accepted Solution?

Thank you for participating in our community!

Regards.

--Sharon