Re: Searching Entire Table - Multiple Columns

Method_Audisho — Tue, 30 Jun 2015 13:42:08 GMT

Hi Jason,

Unfortunately, the only way to accomplish this in Method Classic is to do as you mentioned above with an SQL override field. Method New (M:N) uses a single search field that searches through all fields in the grid. Once all the features that you need have been implemented into M:N and you are ready to make the switch, this will no longer be a problem.

I hope this helps.

Audisho

Searching Entire Table - Multiple Columns

Jason Kim — Mon, 29 Jun 2015 22:43:33 GMT

I noticed that for each table, you are able to search by column individually, and typing into multiple columns would result in an "AND" type of search where the results would display only those that match all the column search criteria. However, I was looking for a search bar that would search ALL columns at the same time with one search query, and would return all the rows that matched the query in AT LEAST one column.

The only way I could accomplish this was to create another column and insert all the columns to search in the SQL Override - Filter Fields. The problem is that this creates an additional blank column that is pushed to the side and takes up additional unnecessary space. Is there a way to have a search bar with this function on the page anywhere, or above the grid?

http://imgur.com/a/bt394

Method:Classic General Q&A

Re: Searching Entire Table - Multiple Columns

Searching Entire Table - Multiple Columns