• How to use complex SQL

  Support January 4th, 2024 @ 11:39 am
  

  Hi Julio,

  The plugin can only add sections to the "Where" clause. We have not interrupted the select statement at all, so the "extra SQL" is only the additional Where statements that might be needed that cannot be added via the interface. looking at your SQL above you are trying to amend the Rows returned as well (the select part of the SQL statement), which this plugin does not currently support unfortunately.

  The second screenshot of the "complex query" is the SQL Analyser function that formats the resultant SQL in a legible format so you can find/see what will be run and work out table aliases etc to build your additional where statements.

  Kind regards

  Mark

  View Comment
  
  
• Is it available for 7.3.x version of the SuiteCRM

  Support March 3rd, 2023 @ 6:13 pm
  

  I have provided a new plan and upload specifically for SuiteCRM 7.3.

  View Comment
  
  
• Is it available for 7.3.x version of the SuiteCRM

  Support March 3rd, 2023 @ 1:21 pm
  

  I will take a look at Suite7.3 and test it and get back to you if thats okay, if it does work I will upload a specific version and get back to you.

  Regards

  Mark

  View Comment
  
  
• I don't have the option to quit Trail

  Support December 27th, 2022 @ 1:26 pm
  

  Hi Credge,

  This is not something that can be resolved here (or by me), you need to use the Contact Us section of this site:

  https://store.suitecrm.com/contact

  To request the end of the trial

  Kind regards

  Mark

  View Comment
  
  
• No results are found using this Plugin

  Support December 20th, 2022 @ 12:37 pm
  

  Can you send screen shots of exactly what you have in the "Additional SQL" section please, also a screen shot of the "Analyse SQL" results. please note that the additional SQL should be additional parts of the where (so in your cases axample you would put "name is not NULL" in the box). Also note that it needs to be valid SQL so the fields need to be valid and correct as per the Analyse SQL section so in my Cases for example I would need to put cases.name IS NOT NULL to avoid conflict with joins etc. (less important for simple non joined queries but a good habit to get into). I can tell you the cases example works for me here

  Regards

  Mark

  View Comment
  
  
• This addon is not suitble for us, pls refund

  Support February 15th, 2022 @ 12:21 pm
  

  Hi Tuanan,

  Sorry to hear the plugin isnt working for you, to get a refund you need to contact the store team using the Contact Us form

  Regards

  Mark

  View Comment
  
  
• Plugin not suited, please refund

  Support October 1st, 2021 @ 12:23 pm
  

  Hi,

  Many thanks for your feedback, the store team should be processing your refund shortly. In the meantime could I ask what it is you are trying to acheive within the report module that you can't do without customising other sections of the query please?

  We have always found that it is the Where portion that is lacking rather than the fields you can select or the ordering/grouping etc. As such more detailed feedback will allow us to improve our plugin.

  Kind regards

  Mark

  View Comment
  
  

IceStar Media Ltd. has not rated any add-ons.

IceStar Media Ltd. has not verified any add-ons.

IceStar Media Ltd. has not created any Wanted Add-ons.