Publishing Error with Definition query

kapalczynski

I am getting an error when trying to publish am Oracle SDE Feature Class to AGOL.  It works in CASE 1 below but when I add the date it fails to publish.. 

NOTE:  It does not throw an error when I add the definition query.  In fact the definition query works fine as you can see from the image below.. there are over 700 records in this dataset and it is only showing 1. 

QUESTION: Why does it fail to publish with the date but does not throw an error in Pro

 

CASE 1

 

( PERMITSTATUS LIKE 'COMPLETED' OR PERMITSTATUS LIKE 'CANCELED' 
OR PERMITSTATUS LIKE 'DENIED' OR PERMITSTATUS LIKE 'Maintenance')

 

CASE 2

 

(( PERMITSTATUS LIKE 'COMPLETED' OR PERMITSTATUS LIKE 'CANCELED' 
OR PERMITSTATUS LIKE 'DENIED' OR PERMITSTATUS LIKE 'Maintenance') 
AND PERMITCHANGEDATE >= ADD_MONTHS(TO_DATE(SYSDATE),-10))

 

 

 

kapalczynski

The below worked when I built it... looking at the SQL it created,,, but this does not look correct 

But not sure how to use NOW or SYSDATE and then minus 10 months

PERMITSTATUS = 'COMPLETED' Or (PERMITSTATUS = 'CANCELED' And PERMITCHANGEDATE < TO_DATE('2023-05-01 15:52:58', 'YYYY-MM-DD HH24:MI:SS'))