ParaSQL Release 22 now LIVE!

[ParaSQL Support]

New In Release 22 (July 2015)

• HTML Widget Enhancements:
  • HTML Widgets now dynamically recalculate and redisplay when any field they depend upon is modified.
  • HTML Widgets now have a predefined Navigate To snippet option - use to trigger Google Navigation to a specified address (works on mobile devices only).
  • HTML Widgets now have a predefined Send Email snippet option - use to open a new email with the specified To email address.
  • HTML Widgets now have a predefined Call snippet option - use to open the phone dialer with the specified phone number (works on mobile devices only).
  • HTML Widgets now have a predefined Pop Up Help Panel snippet option - use to display pop up help in your app.
• Advanced Filters with Full Text Search:
  • This feature only applies to ParaSQL accounts with a dedicated server.
  • You can now create a full text index across multiple columns in a table and search all of the text in all of the columns quickly and flexibly.
  • First, create a full text index across the columns you want to search by issuing the following command at the SQL prompt:
    ALTER TABLE MyTableName ADD FULLTEXT INDEX (col1, col2, col3)
  • Then in your app you can use an Advanced Filter to specify a full text natural language search as follows:
    MATCH (col1, col2, col3) AGAINST (@value(Virtual.QuickSearch) IN NATURAL LANGUAGE MODE)
  • A full text natural language search allows the user to specify one or more words. The results returned are sorted by relevance. Example: blood pressure devices
  • You may also create an Advanced Filter to specify a full text boolean search as follows:
    MATCH (col1, col2, col3) AGAINST (@value(Virtual.QuickSearch) IN BOOLEAN MODE)
  • A full text boolean search allows the user to specify one or more words, and use + and - syntax to require or eliminate specific words. The results returned are sorted by relevance. Example: +blood -pressure
• New Record object action method to Insert Record At Top (in addition to existing after current and append options).
• New Image Upload Field menu option to View Large Image.
• Miscellaneous smaller improvements.