Feature layer query returns wrong records

StuartMoore

so i want to query a feature layer thats accessed via AGOL but the actual features are served up from ArcGIS Server (i think its 10.3)

i have this in an ArcGIS Pro Notebook and it should be returning the second set of 100 records but instead its returning all 1800 records

UpdsFeat = FeatLyr.query(where = "DATEMODIFIED > (CURRENT_TIMESTAMP-45)",result_offset = 100, result_Record_Count = 100)

is is because the feature service is coming from an old version of ArcGIS Server that doesn't support the result_record_count & Results_offset?

thanks

Stu

StuartMoore

i couldn't get that to work so just used the objectIDs and did a filter to bring them back in small chunks of 1000, it then loads each chunk into a pandas dataframe

steps = 1000
z = 0
sOID = 1
MaxOID = 391283

while sOID < (MaxOID+steps):
    whereFil = "objectid >={0} and objectid < {1}".format(sOID,sOID+steps)
    Upd2k = xxdata.query(where = whereFil,out_fields = outFields)
    sOID +=steps
    if z == 0:
        resdf = pd.DataFrame(Upd2k.sdf)
        z +=1
    else:
        resdf = resdf.append(pd.DataFrame(Upd2k.sdf), ignore_index=True)