CPM is showing result empty
Summary: I have created 4 custom fields and already have 4 custom fields in Incident level I want the same data from previous custom fields to new custom fields. but the result is showing empty. I am posting my ROQL query .
SELECT Incident.CustomFields.c.x_community1 as community, Incident.CustomFields.c.x_building1 as building,Incident.CustomFields.c.x_floor1 as floor,Incident.CustomFields.c.x_unit1 as unit FROM Incident Incident.CustomFields.CO.Community.ID IS NOT NULL AND Incident.CustomFields.CO.BuildingName.ID IS NOT NULL AND Incident.CustomFields.c.x_floor.ID IS NOT NULL AND Incident.CustomFields.c.x_unit.ID IS NOT NULL from Incident where id =119662 LIMIT 25