MapInfo Pro

Has anbody experience with a :"search all" query that searches a browser independently of column names, type of data etc and returns the search results in a browser

------------------------------
Ad van Ooststroom
Bergen op Zoom, NL
------------------------------

Hi Ad

Can you give this tool a try?
When you run it, it adds a button to the Table tab in the Sort and Filter group.

It works on the table in the active browser window and will search through most columns for the given value.

This is the structure that controls which columns to search:
Do Case ColumnInfo(sTab, sCol, COL_INFO_TYPE)
  Case COL_TYPE_CHAR
    sCond = sCol & " Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_INTEGER, COL_TYPE_SMALLINT, COL_TYPE_LARGEINT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DECIMAL, COL_TYPE_FLOAT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DATE, COL_TYPE_DATETIME, COL_TYPE_TIME
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
End Case

As you can see numeric and date/time columns are cast to string before searching.
I'm using the Like operator and I ensure the value you search does include at least one "%".
If no "%" has been entered, I'll add one at each end of the string.

For now, the command used to search is written to the Message window. We can consider turning this off once you are happy with the result.

The attached file contains the source code and compiled MBX.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 06-27-2022 11:32
From: Ad van Ooststroom
Subject: "seach all"

Has anbody experience with a :"search all" query that searches a browser independently of column names, type of data etc and returns the search results in a browser

------------------------------
Ad van Ooststroom
Bergen op Zoom, NL
------------------------------

Hi Ad,

Here's a new version where I have removed the commend from the Message window.
I'll get the tool cleaned up a bit more and added to the MapInfo Marketplace later.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 06-28-2022 02:56
From: Peter Møller
Subject: "seach all"

Hi Ad

Can you give this tool a try?
When you run it, it adds a button to the Table tab in the Sort and Filter group.

It works on the table in the active browser window and will search through most columns for the given value.

This is the structure that controls which columns to search:
Do Case ColumnInfo(sTab, sCol, COL_INFO_TYPE)
  Case COL_TYPE_CHAR
    sCond = sCol & " Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_INTEGER, COL_TYPE_SMALLINT, COL_TYPE_LARGEINT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DECIMAL, COL_TYPE_FLOAT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DATE, COL_TYPE_DATETIME, COL_TYPE_TIME
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
End Case

As you can see numeric and date/time columns are cast to string before searching.
I'm using the Like operator and I ensure the value you search does include at least one "%".
If no "%" has been entered, I'll add one at each end of the string.

For now, the command used to search is written to the Message window. We can consider turning this off once you are happy with the result.

The attached file contains the source code and compiled MBX.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 06-27-2022 11:32
From: Ad van Ooststroom
Subject: "seach all"

Has anbody experience with a :"search all" query that searches a browser independently of column names, type of data etc and returns the search results in a browser

------------------------------
Ad van Ooststroom
Bergen op Zoom, NL
------------------------------

Hi Ad

I made a tool from your request and some additional features.
Check out this: https://community.precisely.com/discussion/multi-search-tool

Peter

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 06-29-2022 03:03
From: Peter Møller
Subject: "seach all"

Hi Ad,

Here's a new version where I have removed the commend from the Message window.
I'll get the tool cleaned up a bit more and added to the MapInfo Marketplace later.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 06-28-2022 02:56
From: Peter Møller
Subject: "seach all"

Hi Ad

Can you give this tool a try?
When you run it, it adds a button to the Table tab in the Sort and Filter group.

It works on the table in the active browser window and will search through most columns for the given value.

This is the structure that controls which columns to search:
Do Case ColumnInfo(sTab, sCol, COL_INFO_TYPE)
  Case COL_TYPE_CHAR
    sCond = sCol & " Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_INTEGER, COL_TYPE_SMALLINT, COL_TYPE_LARGEINT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DECIMAL, COL_TYPE_FLOAT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DATE, COL_TYPE_DATETIME, COL_TYPE_TIME
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
End Case

As you can see numeric and date/time columns are cast to string before searching.
I'm using the Like operator and I ensure the value you search does include at least one "%".
If no "%" has been entered, I'll add one at each end of the string.

For now, the command used to search is written to the Message window. We can consider turning this off once you are happy with the result.

The attached file contains the source code and compiled MBX.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 06-27-2022 11:32
From: Ad van Ooststroom
Subject: "seach all"

Has anbody experience with a :"search all" query that searches a browser independently of column names, type of data etc and returns the search results in a browser

------------------------------
Ad van Ooststroom
Bergen op Zoom, NL
------------------------------

Thanks Peter, I am using the previous "searchall" version all the time and will check out the new versions.

------------------------------
Ad van Ooststroom
Bergen op Zoom, NL
------------------------------

Original Message:
Sent: 09-22-2022 09:33
From: Peter Møller
Subject: "seach all"

Hi Ad

I made a tool from your request and some additional features.
Check out this: https://community.precisely.com/discussion/multi-search-tool

Peter

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 06-29-2022 03:03
From: Peter Møller
Subject: "seach all"

Hi Ad,

Here's a new version where I have removed the commend from the Message window.
I'll get the tool cleaned up a bit more and added to the MapInfo Marketplace later.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 06-28-2022 02:56
From: Peter Møller
Subject: "seach all"

Hi Ad

Can you give this tool a try?
When you run it, it adds a button to the Table tab in the Sort and Filter group.

It works on the table in the active browser window and will search through most columns for the given value.

This is the structure that controls which columns to search:
Do Case ColumnInfo(sTab, sCol, COL_INFO_TYPE)
  Case COL_TYPE_CHAR
    sCond = sCol & " Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_INTEGER, COL_TYPE_SMALLINT, COL_TYPE_LARGEINT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DECIMAL, COL_TYPE_FLOAT
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
  Case COL_TYPE_DATE, COL_TYPE_DATETIME, COL_TYPE_TIME
    sCond = "Str$(" & sCol & ") Like " & Chr$(34) & msInput & Chr$(34)
End Case

As you can see numeric and date/time columns are cast to string before searching.
I'm using the Like operator and I ensure the value you search does include at least one "%".
If no "%" has been entered, I'll add one at each end of the string.

For now, the command used to search is written to the Message window. We can consider turning this off once you are happy with the result.

The attached file contains the source code and compiled MBX.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 06-27-2022 11:32
From: Ad van Ooststroom
Subject: "seach all"

Has anbody experience with a :"search all" query that searches a browser independently of column names, type of data etc and returns the search results in a browser

------------------------------
Ad van Ooststroom
Bergen op Zoom, NL
------------------------------