XMod Additional Form Settings - Advanced Search (Optional Form)

With Business Directory, you may use several forms. In Step 3 (Configure Main Form) we discussed configuring the main data entry listing form. Business Directory also includes the additional forms DNNP-BD6.1 Inquiry Form, DNNP-BD6.1 Inquiry Form 2, DNNP-BD6.1 Sharing Form, and the DNNP-BD6.1 Advanced Search Form. In this section we will discuss the Advanced Search form.

Setup Your Advanced Search Page

Note: The Advanced Search Form is intended to be used with the DNNP-BD6.1 Single Category Form and the DNNP-BD6.1 Sub Category Form. It is currently not compatible with the DNNP-BD6.1 Multiple Categories Form.

We will now assume that you have already setup your main Business Directory listing page as explained in Step 2. Configure XMod.

Next, decide what DotNetNuke portal page that you want to contain your advanced search module. This could be on a new separate search page or on any existing page on your site.

Next add a XMod FormView module to this page.

Your module should now look like this:

 

After saving your changes the module will now look like this:

Configure Advanced Search Form Settings

Business Directory includes an Advanced Search form (DNNP-BD6.1 Advanced Search Form). The DNNP-BD6.1 Advanced Search Form is designed to optionally be used as a search dashboard module that can be placed on any page of your portal site. It is designed to be used as a drill-down search form that is database driven and will return company, category, and location values that are related to existing Business Directory listings.

Save Settings

 

Parameter changes to match your portal configuration:

1. DBobjectQualifier - This parameter is used for the SQL database calls in the form. It is a combination of the database user permission and the database qualifier. The parameter default is .dbo. In most cases you can leave this parameter set at its default value. If you have set a unique qualifier, during the DotNetNuke wizard installation, you will need to replace the default value with the user permission and qualifier. Note: This value is the prefix to all of your DotNetNuke database tables. Example: dbo.portal2_
    
2. BDFormId - Replace this parameter default value with the XMod FormId number of the Business Directory main form that you decided to use. The choices, as explained in Step 3. Configure Main Form are DNNP-BD6.1 Single Category Form, DNNP-BD6.1 Multiple Categories Form, and  DNNP-BD6.1 Sub Categories Form.
   
   To find the XMod FormId on your DotNetNuke portal site you will need to log into your portal using the portal Host account.
   
   Next, go to Host >> SQL and run the following SQL query.
   
   
   Step 1.
   
   
   
   Step 2.
   
   Run the following SQL query.
   
   
   
   Note: If you are using a object qualifier for your DNN portal inatallation you will need to add it to the above SQL query to obtain the results. Example: from dbo.qualifierName_KB_XMod_Forms
   
   Step 3.
   
   Locate the FormId that matches the Business Directory form that you are using and replace the BDFormId parameter value with your formId number.
   
   
    
3. SearchURL- Replace this parameter default value with the full URL of the page where your Business Directory advanced search XMod formview module resides.
   Example: http://dnnprofessor.com/DNNDirectory/DNNDirectoryAdvancedSearch.aspx
    
4. redirURL- Replace this parameter with the full URL of your main Business Directory listings page. Example: http://dnnprofessor.com/DNNDirectory.aspx
    

Save Form

Click Done

Good Job!

Next >> Step 6 Configure Templates Settings 1