cityofaustin / atd-knack-data-tracker

The primary work & asset management system for Austin Transportation
3 stars 1 forks source link

(DTS19-104865) Update "Follow-up Ticket" filter on Signal Work Orders #2

Closed dianamartin closed 5 years ago

dianamartin commented 5 years ago

Project Name Update "Follow-up Ticket" filter on Signal Work Orders

Requested By Billy Bolander

Requesting Division

How would you rate the impact of this issue?

Is your feature request related to a problem? Please describe. n/a

Describe the solution you'd like On the Follow-Up Tickets filter: http://transportation.austintexas.io/data-tracker/#work-orders4/

The "Follow-Up Ticket" filter is not filtering out inactive statuses. It is showing "Closed", "In Progress", etc...

Billy would like the filter to do this: Parent Work Order is not blank + Status is "Unassigned"

Describe alternatives you've considered n/a

Additional context n/a

Needed By Date n/a

Customer Priority

Service Group

dianamartin commented 5 years ago

I updated the "Follow-Up Tickets" filter and the "Unassigned" too. Check it out: http://transportation.austintexas.io/data-tracker/#work-orders/

Unassigned is now: 47 records Follow-Up Tickets: 295 records

Updated "work_orders_signals" object table

Add New field "FOLLOW_UP_UNASSIGNED_Only" - NUMBER FIELD

Added Conditional Rules:

"PARENT_WORK_ORDER" IS NOT BLANK "WORK_ORDER_STATUS" IS "Unassigned" Set to custom value 1 "PARENT_WORK_ORDER" IS BLANK Set to custom value 0 "WORK_ORDER_STATUS" IS NOT "Unassigned" Set to custom value 0 Change filter for "Follow-Up Tickets" on page: https://builder.knack.com/atd/7-feb-2019--test-atd-data-tracker#pages/scene_243

Work Orders table

From: "PARENT_WORK_ORDER" IS NOT BLANK To: "FOLLOW_UP_UNASSIGNED_Only" is HIGHER THAN 0

Add New field "UNASSIGNED_PARENT_WO_NOT_BLANK_Only" - NUMBER FIELD

Added Conditional Rules:

"WORK_ORDER_STATUS" IS "Unassigned" "PARENT_WORK_ORDER" IS BLANK Set to custom value 1 "WORK_ORDER_STATUS" IS NOT "Unassigned" Set to custom value 0 "PARENT_WORK_ORDER" IS NOT BLANK Set to custom value 0

Change filter for "Unassigned" on page: https://builder.knack.com/atd/7-feb-2019--test-atd-data-tracker#pages/scene_243

Work Orders table

From: "WORK_ORDER_STATUS" IS "Unassigned" To: "UNASSIGNED_PARENT_WO_NOT_BLANK_Only" is HIGHER THAN 0