• Blank Run screen after runtall

  Support January 16th, 2024 @ 3:34 pm
  

  The issues with version 7.14.2 have been resolved as of Jan 16, 2024 and a new install file SQLQuery_V172.zip is posted/available to download. Thank you for your patience and support.

  View Comment
  
  
• Blank Run screen after runtall

  Support January 12th, 2024 @ 2:40 pm
  

  Reported issue with version 7.14.2 - please see [https://community.suitecrm.com/t/upgrade-to-v7-14-2-causes-php-fatal-error/91519] (https://community.suitecrm.com/t/upgrade-to-v7-14-2-causes-php-fatal-error/91519)

  View Comment
  
  
• Create a list of Save Queries

  Support January 9th, 2024 @ 7:59 pm
  

  Hello, Queries are stored in the SavedSearch table with search_module = 'SqlQuery'. Thank you and hope this helps.

  View Comment
  
  
• How to Allow certain non-admin user to edit queries

  Support November 1st, 2023 @ 11:32 am
  

  By design, creating and editing of queries is allowed only for admins, since queries can impact the overall performance of the CRM system. Often times queries can be designed to take advantage of database various values as parameters based on users running them. Thank you and hope this helps.

  View Comment
  
  
• How to Allow certain non-admin user to edit queries

  Support October 31st, 2023 @ 11:47 am
  

  Please see User Guide section at the end - Non-administrator users can access the module provided they are given the SQLQuery module URL [./index.php?module=SQLQuery&action=query] AND one of the following:

  1 - they are assigned a SqlQuery role by an Administrator 2 - Authorized users can optionally create a dashlet from the SuiteCRM Dashboard: Add Dashlets > Click Web Tab > Website = paste the URL from above > Add

  Thank you and hope this helps.

  View Comment
  
  
• Not working with version 8.2.4

  Support April 15th, 2023 @ 11:14 am
  

  Hello, the license interface for versions 8.+ have not been implemented. Very sorry for the inconvenience, and we will update this in the description. Please request a refund thru the store.

  View Comment
  
  
• Version compatible

  Support December 21st, 2022 @ 3:28 pm
  

  Greetings, SQLQuery has been working with versions 7.10.*, 7.11* and 7.12.* (that includes 7.12.5 and 7.12.7) Thanks and hope this helps.

  View Comment
  
  
• Is there any Errors alert on the full version ?

  Support December 20th, 2022 @ 2:49 pm
  

  Greetings, All error handling is the same across all versions. The documentation indicates that unforeseen errors are recorded in the suitecrm.log. We often recommend using EverSQL SQL Query Syntax Check & Validator tool Thanks and hope this helps.

  View Comment
  
  
• Regarding Report Enhancer Plugin

  Support December 19th, 2022 @ 1:09 pm
  

  Greetings, Try using the LIMIT clause in queries on large tables with thousands of records or impose additional where conditions to limit the size of the result set being returned. Also, take a look at the suitecrm.log of your instance for other underlying issues cause by queries. Thanks and hope this helps.

  View Comment
  
  
• Version 8.0.3

  Support August 26th, 2022 @ 2:46 pm
  

  Sorry - our support for versions 8 of SuiteCRM is still pending.

  View Comment
  
  
• Version 8.0.3

  Support August 25th, 2022 @ 1:36 pm
  

  Yes it works with all versions and admins can embed any SQL. Hope this helps and thanks for your interest.

  View Comment
  
  
• No result return

  Support December 8th, 2021 @ 12:50 pm
  

  Greetings, We are going to get back to with our tests with version 7.12. Do you see any errors in the suitecrm.log file? Please see https://store.suitecrm.com/docs/SQLQuery/user-guide for assigning an SQLQuery role to a non-admin user.

  View Comment
  
  
• No result return

  Support December 7th, 2021 @ 11:21 am
  

  Greetings, Most often the suitecrm.log shows SQLQuery errors and hence no results returned. Did you try the sample demo queries?

  View Comment
  
  
• Can the module update the db?

  Support October 11th, 2021 @ 7:32 pm
  

  Hello, Please check out Quickedits - a tool that can do updates easily. Thank you and hope this helps.

  View Comment
  
  
• Targets upload

  Support June 18th, 2021 @ 11:23 am
  

  Greetings, The record ids are created automatically when creating ANY module records. Thank you and hope this helps.

  View Comment
  
  

infospectrum has not rated any add-ons.

infospectrum has not verified any add-ons.

infospectrum has not created any Wanted Add-ons.