-
Display Nameinfospectrum
-
Website
-
Member SinceOctober 31st, 2014
-
Last SeenJanuary 21st, 2025
infospectrum does not have any add-ons for sale.
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Support August 26th, 2022 @ 2:46 pm
Sorry - our support for versions 8 of SuiteCRM is still pending.
View Comment
-
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
-
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
-
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
-
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
-
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.