The only way of discovering the limits of the possible is to venture a little way past them into the impossible.

— Arthur C. Clarke               

Inside Time Matters: SQL Filtering Tip

We were doing a Webinar for MobileTM this week when I realized there is feature in TM Enterprise that is not well known.

This feature has to do with viewing and copying the current filter/search criteria in SQL Syntax. I was explaining one of MobileTM's advanced features, being able to use an inline SQL filter in any datalist. To demonstrate I opened the Contact list in Time Matters (you may want to follow along here), any list will do but the Contact list is easy to follow.

1) Make sure you are displaying the filter droplist in the toolbar (this was removed in 9.0 for some reason).

 Filter Selector

2) Select a filter from the drop-down or create any search with one of the search options.

3) Right click on the filter drop-list, select show filter.

4) In the bottom portion of the display you now have the specific SQL syntax needed to reproduce the filter Time Matters is using to display the list.

Filter Display