Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Unfortunately C5 doesn't provide a way to do this -- the only way to tap into the search index is with blocks. And even if you created a phony block just to pass content from the single_page through to the search index, there's no way to say that some content is from one URL while other content is from another URL (which you'd need to do since your single_page controller is handling many different URL's).</p> <p>I don't know of a way to achieve what you want to do (and it appears that nobody else does either -- <a href="http://www.concrete5.org/community/forums/customizing_c5/make-content-in-single-pages-searchable/" rel="nofollow">http://www.concrete5.org/community/forums/customizing_c5/make-content-in-single-pages-searchable/</a> ), other than building your own internal search engine.</p> <p>EDIT: I just did some digging, and thought that perhaps you could manually insert records into the <code>PageSearchIndex</code> table and specify the searchable content and the desired path there -- but this won't work because it relies on one cID (collection id, a.k.a. page id) per entry -- so you'd only be able to insert one record for the top-level single_page path.</p> <p>I think the simplest solution here would be to create your own searching infrastructure for your single_pages (like some kind of function in the controller that would return an array of page paths and searchable content for each one), then override the search block and perform an additional search of your single_page -- then combine the results on the search results page there. Or just use google site search for your site, which will actually crawl the pages and hence find your various single_page urls: <a href="https://www.google.com/cse/" rel="nofollow">https://www.google.com/cse/</a></p> <p>Best of luck.</p>
    singulars
    1. This table or related slice is empty.
    1. POSearching Single Pages with Dynamic Content
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJordan Lev
    1. USJordan Lev
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSearching Single Pages with Dynamic Content
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI really need some help on this one. I understand there aren't alot of options here. CSE from Google inst exactly an option because they return adds which in our case show ads for our competition. Any ideas on how i could go about making my own search inside of concrete5. I mainly need to search 3 tables of data to look for words inside of them but how i would even go about this inside of concrete5 is a labyrinth.
      singulars
      1. PO
      1. USJohn Ayers
    2. COAdd a function to your single_page controller that accepts search keywords and runs a SQL query on them (e.g. `SELECT * FROM my_custom_table WHERE my_content_field LIKE '%search terms%'`). Construct the proper URL's with the proper querystrings that would get someone to the page that has those results on them. Return these as an array. Then in the Search block, override the view.php file and call your controller function from there. Loop through the results and output links to the matched pages. In other words, you are bypassing all C5-related functionality.
      singulars
      1. PO
      1. USJordan Lev
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload