topic Query on last_edited_date attribute in ArcGIS JavaScript Maps SDK Questions

Query on last_edited_date attribute

KARIMLABIDI — Mon, 23 Jan 2023 11:43:13 GMT

Hello everybody,

I would like to query on the editor tracking attributes, especially last_editor_date on the last month. I tried but I Doesn't wok, I think I'm very far away the answer! I didn't find anything on internet, it would be nice if someone could help me. Thank you!!

//Assign a where clause, returnGeometry, and outFields to the Query class. let query = fl_prod.createQuery(); query.where = ???, //The where clause query.returnGeometry=false, //The boolean property for returning the geometry query.outFields= ["IDARRET", "NOMARRET","MNLP_HASTUS","EDITED"] //The fields to return from the query fl_prod.queryFeatures(query) .then(function(response){ let stats = response.features[0].attributes; console.log(stats.Edited); });

Re: Query on last_edited_date attribute

jcarlson — Mon, 23 Jan 2023 15:10:15 GMT

The were clause will be in SQL, so the precise answer can depend on your database backend. This blog article covers the basics, though: https://www.esri.com/arcgis-blog/products/api-rest/data-management/querying-feature-services-date-time-queries/

Re: Query on last_edited_date attribute

KARIMLABIDI — Tue, 24 Jan 2023 11:22:32 GMT

Thank you @jcarlson , i found the solution 🙂

query.where = "Edited > CURRENT_TIMESTAMP - 30"

Thank you