Jump to content
  • 0

Searching Multiple Unrelated Tables


Valik
 Share

Question

Hello. If I have multiple tables that are not related (i.e. there is no common field between them so I cannot combine them in a View) and  I want to run a search across ALL of them for some string and get a report saying which Table(s) have that string. can that be done with Caspio? Thank you.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 1

You can still combine all of them in a View, just that it would be OUTER JOIN, nothing is similar.

You can create another field in all your tables just to store the table name.

Use View as the Data Source for Reports DataPage, and use Keyword Search.

https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/

You might encounter some problems with joining all those tables tho, if you have so much records in each one. Setting up the Reports DataPage will be too much work, as well.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...