-
To query all of the task values in the In Progress work instructions.
Each task has an associated set of data with it. If a work instruction has three
tasks, there will be three json records returned which will all be related to the
same work instruction.
curl -X GET "https://[j5 Server URL]/restserver/28.0/industraform/logbook-query-v2/work_overview?attribute_names=$Form.UUID,$Form.Area,$Form.Category,$Form.Status,$Form.SpecificationName,TaskDescription.DisplayValue,TaskDone.DisplayValue,TaskDoneComment.DisplayValue&pretty=true&query_repeating=true&status=In%20Progress" -H "accept: text/csv" -H "authorization: Basic [Encoded username and password]"
-
To query for all of the Completed work instructions that have a scheduled start time between 1 June 2023 and 30 June 2023.
curl -X GET "https://[j5 Server URL]/restserver/28.0/industraform/logbook-query-v2/work_overview?attribute_names=$Form.Area,Description,$Form.Category,$Form.Status,$Form.SpecificationName,FinishedWorkUser.DisplayValue,FinishedWorkTime&pretty=true&status=Complete&from_date_time=2023-06-01T00:00:00Z&to_date_time=2023-06-30T00:00:00Z" -H "accept: text/csv" -H "authorization: Basic [Encoded username and password]"
-
To query for all of the In Progress work instructions between 1 June 2023 and 30 June 2023 for a specific $Form.SpecificationName.
curl -X GET "https://[j5 Server URL]/restserver/28.0/industraform/logbook-query-v2/work_overview?attribute_names=$Form.Area,Description,$Form.Category,$Form.Status,$Form.SpecificationName,FinishedWorkUser.DisplayValue,FinishedWorkTime&pretty=true&status=In%20Progress&from_date_time=2023-06-01T00:00:00Z&to_date_time=2023-06-30T00:00:00Z&[form_spec_name]=j5.WorkInstructions.work_overview-fromplan" -H "accept: text/csv" -H "authorization: Basic [Encoded username and password]"