Menu

Welcome, Guest
Username: Password: Remember me

TOPIC: How do I create following report query from the GUI?

How do I create following report query from the GUI? 3 months 1 week ago #63554

  • nuke
  • nuke's Avatar
  • Offline
  • Premium Member
  • Learning as I go
  • Posts: 101
  • Thank you received: 8
  • Karma: 1
I'd like to report on which contacts haven't been contacted (call or email) in the period from April 1, 2017 to date.
I've been able to get a report that shows who was called in the period but I can't get the reverse ie. those not called.
I can't find an operator or set of options to get this.
How can I do it?

Thanks.
Last Edit: 3 months 1 week ago by nuke.
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 1 week ago #63589

  • suitecrm_developer
  • suitecrm_developer's Avatar
  • Offline
  • Elite Member
  • Posts: 207
  • Thank you received: 17
  • Karma: 3
Hi,
How you are getting those who have been called?
From Reports module? or custom query?
Can you please share the report screenshot or query text that is working for now??

Thanks
Sohaib Majeed
SuiteCRM Developer
Upwork ==>> www.upwork.com/fl/sohaibmajeed?viewMode=1
Skype ==>> sohaib.majeed44
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 6 days ago #63649

  • nuke
  • nuke's Avatar
  • Offline
  • Premium Member
  • Learning as I go
  • Posts: 101
  • Thank you received: 8
  • Karma: 1
Thanks for your question @Sohaib.

I created the query using the report module & GUI.

I can get a count of the number of calls but unfortunately can't get all the names. (I can get the contacts but not the leads but I can create another query for the leads)

I don't seem to be able to find a way to add a screenshot to this discussion board so I'll try to provide all the info below.

Report Module: Calls
Charts per row: 2
Fields
from left to right: Module|Field|Display|Link|Label|Function|Sort|Group|Format Options|Total
Row 1: Calls|Contact|Display yes|Link no|Label:Contact|Function:none|Sort:ascending|Group:yes|Format Options:none|Total:none
Row 2: Calls|Subject|Display yes|Link no|Label:Number of calls|Function:count|Sort:none|Group:no|Format Options:none|Total:none

Conditions
Fields
from left to right: Logic Module|Field|Operator|Type|Value|Parameter
Row 1: Calls|Status|Operator: Equal to|Type: Value|Value: Held|none
Row 2: Calls|Date|Greater than or equal Type: Value| 03.04.2017 00 00|none

Charts
none.

I get a total of all the calls with no contact (I assume these are leads) and all the contacts listed with the number of calls made to each.

I need to be able to identify who wasn't contacted or the inverse of this list.

Thanks again.
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 6 days ago #63659

  • suitecrm_developer
  • suitecrm_developer's Avatar
  • Offline
  • Elite Member
  • Posts: 207
  • Thank you received: 17
  • Karma: 3
Hi,
we can write a custom query to do that. For this we have to create a separate entry point. There we can write our own code to get list of All the Contacts/Accounts who had been never called.
I can help you out regarding this.

Thanks
Sohaib Majeed
SuiteCRM Developer
Upwork ==>> www.upwork.com/fl/sohaibmajeed?viewMode=1
Skype ==>> sohaib.majeed44
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 6 days ago #63662

  • nuke
  • nuke's Avatar
  • Offline
  • Premium Member
  • Learning as I go
  • Posts: 101
  • Thank you received: 8
  • Karma: 1
Thank again @Sohaib.

I could write a sql query but I don't know how to get this query to show up in the GUI.

If you can provide some guidance, I would appreciate it very much.

So I don't waste your time on easy stuff, is there some documentation that I missed that would cover some of the basics?
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 6 days ago #63664

  • suitecrm_developer
  • suitecrm_developer's Avatar
  • Offline
  • Elite Member
  • Posts: 207
  • Thank you received: 17
  • Karma: 3
Hi,
One solution is to create the Custom View of the current list view and there you can apply a query filter.
Second solution is to create a simple PHP entry point and then only list down the Accounts/Contacts with the same filter query.
I can't write all the code there. You know. It will take some time....

Thanks
Sohaib Majeed
SuiteCRM Developer
Upwork ==>> www.upwork.com/fl/sohaibmajeed?viewMode=1
Skype ==>> sohaib.majeed44
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 1 day ago #63954

  • nuke
  • nuke's Avatar
  • Offline
  • Premium Member
  • Learning as I go
  • Posts: 101
  • Thank you received: 8
  • Karma: 1
Hi @Sohaib
Thanks for your help.
So if I understand your suggestions correctly, it is not possible to create this report using the GUI.
I'm trying to learn about this as I go.

I was not able to find any documentation about "create the Custom View of the current list view and there you can apply the query filter". I can't find a way to create a Custom View from the report output list or design view. How do I do this?

Would this link Entry Points describe what you meant with your suggestions to create a simple PHP entry point and then list down the accounts/contacts with the same filter query?
The administrator has disabled public write access.

How do I create following report query from the GUI? 3 months 1 day ago #63955

  • suitecrm_developer
  • suitecrm_developer's Avatar
  • Offline
  • Elite Member
  • Posts: 207
  • Thank you received: 17
  • Karma: 3
Hi, Please check this link.

developer.sugarcrm.com/2011/12/23/creati...for-sugarcrm-module/

Select the files as per the list view.

Thanks
Sohaib Majeed
SuiteCRM Developer
Upwork ==>> www.upwork.com/fl/sohaibmajeed?viewMode=1
Skype ==>> sohaib.majeed44
The administrator has disabled public write access.

How do I create following report query from the GUI? 1 month 3 weeks ago #66601

  • nuke
  • nuke's Avatar
  • Offline
  • Premium Member
  • Learning as I go
  • Posts: 101
  • Thank you received: 8
  • Karma: 1
Thank you Sohaib.
I have tried a few times to access this link but it always goes to community.sugarcrm.com/community/developer. When I search for the terms, I am not able to find the page.
So I looked at the wayback machine and found the posting but it is incomplete. It is missing the screenshots.
There is a partial article on hirenprajapati.wordpress.com/2014/03/19/...r-sugarcrm-module-2/. It links back to the same post you have listed.
I feel like an idiot because I am not able to get to the page.
The administrator has disabled public write access.

How do I create following report query from the GUI? 1 month 3 weeks ago #66603

  • amariussi
  • amariussi's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 1034
  • Thank you received: 233
  • Karma: 54
If your report is correct, to do the inverse have you tried entering:

Value: Not Held

under the condition regarding status?

If you want to issue SQL queries, maybe you can try this:

github.com/audoxcl/SugarCRMCustomQueries
The administrator has disabled public write access.
Time to create page: 0.118 seconds
Powered by Kunena Forum