Zuñiga Formation Lap

I want to make a report that shows all the changes registered in the month and the relationships that you have with requests, problems and projects.



Change IDTitle ChangeRequest IDTitle RequestProblem IDTitle ProblemProject IDTitle Project









Can you support me with the query? I appreciate the attentions

Replies (7)

Hi,

Please send us the below details to develop the SQL query.

1) Database: MYSQL or MSSQL or PGSQL.

2) Version and Build of ServiceDesk Plus you are using.
Login to ServiceDesk Plus, click on Help > About to the top right hand side to find the build number.
Hi,

Please send us the below details to develop the SQL query.

1) Database: MYSQL or MSSQL or PGSQL.

2) Version and Build of ServiceDesk Plus you are using.
Login to ServiceDesk Plus, click on Help > About to the top right hand side to find the build number.
Hi,

Please send us the below details to develop the SQL query.

1) Database: MYSQL or MSSQL or PGSQL.

2) Version and Build of ServiceDesk Plus you are using.
Login to ServiceDesk Plus, click on Help > About to the top right hand side to find the build number.
Zuñiga Formation Lap
Hello!,

1) Database: PGSQL
2) Versión 9304

Thanks, 

Lissette 5 Laps
Hello,
      Is it possible to add a column that says what module the Change is associated to and the ID of the module. Also, total the charges for the change so there are no duplicate lines. Also, please add the ability to be able to filter if the Change is associated to a module (Yes or No). Is it possible to also be able to still have the link to the change or module on the report?


SELECT sdo.NAME AS "Site", subcatadef.NAME AS "Subcategory", chdt.CHANGEID AS "Change ID", chdt.TITLE AS "Title", chargeTable.TOTAL_CHARGE AS "Total Charges", chdt.SCHEDULEDSTARTTIME AS "Scheduled Start Time", chdt.SCHEDULEDENDTIME AS "Scheduled End" FROM ChangeDetails chdt LEFT JOIN SubCategoryDefinition subcatadef ON chdt.SUBCATEGORYID=subcatadef.SUBCATEGORYID LEFT JOIN ChangeToCharge changeCharge ON chdt.CHANGEID=changeCharge.CHANGEID LEFT JOIN ChargesTable chargeTable ON changeCharge.CHARGEID=chargeTable.CHARGEID LEFT JOIN SiteDefinition siteDef ON chdt.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID WHERE  ((subcatadef.NAME = 'Pgec') AND (((chdt.CREATEDTIME >= 1483246800000) AND ((chdt.CREATEDTIME != 0) AND (chdt.CREATEDTIME IS NOT NULL))) AND ((chdt.CREATEDTIME <= 1514782799000) AND (((chdt.CREATEDTIME != 0) AND (chdt.CREATEDTIME IS NOT NULL)) AND (chdt.CREATEDTIME != -1)))))  ORDER BY 3 NULLS FIRST
Zuñiga Formation Lap
Thks!,

But when running the query you do not return data...

Now, I want to add in this query the project code field.

Can you help me please!!.



Lissette 5 Laps
Hello, any luck on the below request?? Please and thank you.



Hello,
      Is it possible to add a column that says what module the Change is associated to and the ID of the module. Also, total the charges for the change so there are no duplicate lines. Also, please add the ability to be able to filter if the Change is associated to a module (Yes or No). Is it possible to also be able to still have the link to the change or module on the report?


SELECT sdo.NAME AS "Site", subcatadef.NAME AS "Subcategory", chdt.CHANGEID AS "Change ID", chdt.TITLE AS "Title", chargeTable.TOTAL_CHARGE AS "Total Charges", chdt.SCHEDULEDSTARTTIME AS "Scheduled Start Time", chdt.SCHEDULEDENDTIME AS "Scheduled End" FROM ChangeDetails chdt LEFT JOIN SubCategoryDefinition subcatadef ON chdt.SUBCATEGORYID=subcatadef.SUBCATEGORYID LEFT JOIN ChangeToCharge changeCharge ON chdt.CHANGEID=changeCharge.CHANGEID LEFT JOIN ChargesTable chargeTable ON changeCharge.CHARGEID=chargeTable.CHARGEID LEFT JOIN SiteDefinition siteDef ON chdt.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID WHERE  ((subcatadef.NAME = 'Pgec') AND (((chdt.CREATEDTIME >= 1483246800000) AND ((chdt.CREATEDTIME != 0) AND (chdt.CREATEDTIME IS NOT NULL))) AND ((chdt.CREATEDTIME <= 1514782799000) AND (((chdt.CREATEDTIME != 0) AND (chdt.CREATEDTIME IS NOT NULL)) AND (chdt.CREATEDTIME != -1)))))  ORDER BY 3 NULLS FIRST