reporting on service catalogue custom field
hi
i have built a standard report but i wish to add into it a custom field that was set up on the service request
when i view query i get the below sql statement, what i would like to add to this is the custom column UDF_CHAR2 but have no idea how to do this. i assume i can add it to the select statement.
SELECT `aau`.`FIRST_NAME` AS `Requester`,`wo`.`WORKORDERID` AS `Request ID`,`aau`.`FIRST_NAME` AS `Requester`,`wo`.`TITLE` AS `Subject`,`wo`.`CREATEDTIME` AS `Created Time` FROM `WorkOrder` `wo` LEFT JOIN `SDUser` `sdu` ON `wo`.`REQUESTERID`=`sdu`.`USERID` LEFT JOIN `AaaUser` `aau` ON `sdu`.`USERID`=`aau`.`USER_ID` WHERE ((`wo`.`TITLE` LIKE _utf8 '%OL session reset with details%' ) AND (((`wo`.`CREATEDTIME` >= 1493593200000) AND ((`wo`.`CREATEDTIME` != 0) AND (`wo`.`CREATEDTIME` IS NOT NULL))) AND ((`wo`.`CREATEDTIME` <= 1496271599000) AND (((`wo`.`CREATEDTIME` != 0) AND (`wo`.`CREATEDTIME` IS NOT NULL)) AND (`wo`.`CREATEDTIME` != -1))))) AND wo.ISPARENT='1' AND wo.IS_CATALOG_TEMPLATE='1' ORDER BY 1
i have built a standard report but i wish to add into it a custom field that was set up on the service request
when i view query i get the below sql statement, what i would like to add to this is the custom column UDF_CHAR2 but have no idea how to do this. i assume i can add it to the select statement.
SELECT `aau`.`FIRST_NAME` AS `Requester`,`wo`.`WORKORDERID` AS `Request ID`,`aau`.`FIRST_NAME` AS `Requester`,`wo`.`TITLE` AS `Subject`,`wo`.`CREATEDTIME` AS `Created Time` FROM `WorkOrder` `wo` LEFT JOIN `SDUser` `sdu` ON `wo`.`REQUESTERID`=`sdu`.`USERID` LEFT JOIN `AaaUser` `aau` ON `sdu`.`USERID`=`aau`.`USER_ID` WHERE ((`wo`.`TITLE` LIKE _utf8 '%OL session reset with details%' ) AND (((`wo`.`CREATEDTIME` >= 1493593200000) AND ((`wo`.`CREATEDTIME` != 0) AND (`wo`.`CREATEDTIME` IS NOT NULL))) AND ((`wo`.`CREATEDTIME` <= 1496271599000) AND (((`wo`.`CREATEDTIME` != 0) AND (`wo`.`CREATEDTIME` IS NOT NULL)) AND (`wo`.`CREATEDTIME` != -1))))) AND wo.ISPARENT='1' AND wo.IS_CATALOG_TEMPLATE='1' ORDER BY 1