Posted on 07/08/2014 11:22:11
As far as your database structure goes, pages have no content, so you can't search them. Pages have paragraphs and paragraph have content. Each paragraph have a reference to a page ID, but each paragraph also has its own ID.
Even when you search, you get references to paragraphs and not unique references to pages. If a page contains 5 paragraphs, and 2 of them contains the search phrase, the page will show up twice in the search result. If you included the id of the paragraph you could use that as an anchor, and even make the target page scroll to the paragraph with the content you searched for.
Just thought it would be very useful to have the paragraph. But in my scenario, and a lot of others.
The customer has the datalist module, so I can easily make my own SQL search, and get the output that I need. And I can even make that SQL as a stored procedure, and have the datalist execute that in stead. Will make it much faster... *hint, hint*