AnsweredAssumed Answered

pgSQL applied to query definition in ArGIS

Question asked by Sunnyhanxi on Jun 7, 2017
Latest reply on Jun 8, 2017 by Sunnyhanxi

I was using the following code to query out the record in ArcMap. when I used verify button for the code, it returned error. Anybody can tell me why? 

 

replace(split_part( image_path_filename, '_', 5), '.pdf', '')::timestamp > CURRENT_TIMESTAMP - INTERVAL '545 day' and split_part( image_path_filename, '_', 5) not like 'sn-%' and split_part( image_path_filename , '_', 5) <> ' ' and maptype = 'Appraisal'

 

Thanks,

Outcomes