Data Assist Pages: search/result/details pages. No multiple words search. No advanced search (text box, List/Menu box, Group Radio box). Text formatting codes displayed in result pages.

1. Using Data Assist Pages, I created search/result/details pages.
a) PROBLEM 1: Search does not allow for multiple words search – only one word.
• How could I create Advanced search (text box, List/Menu box, Group Radio box) and result pages?
• How could I create a search text-box to search using multiple keywords?
b) PROBLEM 2: I use formatting widget for text boxes where users can format their text. The formatting codes are entered in the database along with the normal/plain text. The Data Bridge result page shows these formatting codes (<p><b> <div> </span></p><p><span style="color: rgb(0, 0, 0); font-size: 15px;"> etc) along with the plain text. I need result page to show only formatted text, no codes.
How to solve above problems?

a) you can update the Database Search server behavior on the results page to set up more advanced searches including multiple word search. You will see a lot of options in that server behavior that cover the scenarios you are looking for.

b) The code has built-in cross site scripting protection that prevents html and script from running when it comes from the database. You can manually override that code wherever you need to by adding a "false" argument in the getColumnVal() method call. It will look something like:

<?php echo($RecordsetName->getColumnVal("column",false)); ?>

instead of:

<?php echo($RecordsetName->getColumnVal("column")); ?>