Hello Ron,
Below is my query:
call apoc.export.csv.query("MATCH p = (sc:SITE_CODE_TABLE)<-[:site2sitecode]-(s:SITE)-[:site2container]->(c:CONTAINER)-[:container2mostatic]->(m:MO_STATIC_TABLE)
where c.EQUIP_TYPE = 'BBU'
RETURN
CASE
WHEN s.SITE_OWNER = 'RCOM' THEN 'P1-RCOM'
WHEN s.SITE_OWNER = 'RJIL' THEN 'P1-RJIL' END AS OWNER,
c.EQUIP_NAME AS LOGICAL_NAME,
c.EQUIP_VENDOR AS VENDOR,
c.EQUIP_SITE_NAME AS LOCATION,
m.type AS TYPE,
'ucmdb' AS UPDATED_BY,
c.EQUIP_STATUS AS ISTATUS,
c.EQUIP_NATIVENAME AS ASSET_TAG,
c.EQUIP_MAINTENANCEPOINT AS CORP_STRUCTURE,
c.EQUIP_TYPE AS TEMP_TYPE,
s.SITE_CIRCLE AS RIL_CIRCLE,
s.SITE_AREACODE AS RIL_AREA,
c.CREATED_DATE AS CREATED_BY_DATE,
c.MODIFIED_DATE AS SYSMODTIME,
s.POST_CODE AS RIL_ZIP,
s.SITE_MAINTENANCEPOINT AS RIL_MNTPOINT,
s.SITE_CITY AS RIL_CITY,
c.EQUIP_MODEL AS RIL_MAKEMODEL,
c.EQUIP_NEID AS RIL_CIID,
sc.SITE_REGION AS RIL_REGION,
m.parentci AS PARENTCI,
c.EQUIP_TYPE AS RIL_GRANITETYPE,
s.SITE_R4G_STATE AS RIL_R4GSTATE,
s.SAPID AS RIL_SAPID,
s.SITE_OWNER AS RIL_SITEOWNER,
s.SITE_LEASED_REFERENCE_CODE AS RIL_SITELEASEDOWNER,
s.SITE_FRIENDLY_NAME AS RIL_FRIENDLYNAME,
'https://www.google.com/maps/place/'+s.SITE_LATITUDE+'+'+s.SITE_LONGITUDE+'/@'+s.SITE_LATITUDE+','+s.... AS RIL_GISURL,
s.JIO_CENTER AS RIL_JIOCENTRE,
m.devicetype AS RIL_DEVICETYPE,
'ucmdb' AS SYSMODUSER,
'ucmdb' AS CREATED_BY,
s.JIO_CENTER_CODE AS PSTATUS,
s.SITE_TYPE AS RIL_SITETYPE limit 6","/tmp/neo4j/sample.csv",{d:','});
