How to specify date and time range query in scripted rest api
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2024 12:13 AM
Hello,
How to specify and call start date and end dates queryparameter in scripted rest api.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2024 12:40 AM
Hi @lucky6
first define the respective date range filter in the list view of the related table, like
Then take the encoded query into the clipboard and paste it into the "query" field of the REST API explorer
Then perform the query to get an idea how you can restrict the results to a certain date range.
Maik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2024 12:45 AM
How to add dynamic filters in above query?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2024 12:52 AM - edited 01-12-2024 12:52 AM
Hi @lucky6
always with the same approach. First configure the filter in the list view and then take the encoded query with you.
Maik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2024 12:35 AM
Hi @lucky6
What is your requirement regarding Dynamic Filters ?
Thanks & Regards
Amit Verma
Please mark this response as correct and helpful if it assisted you with your question.