[Python] Connect Work Orders to Flex Notes

cityofaustin / atd-knack-signs-markings

https://atd-knack-signs-markings.netlify.com/

Other

1 stars 0 forks source link

[Python] Connect Work Orders to Flex Notes #287

Closed dianamartin closed 4 years ago

dianamartin commented 4 years ago

In order to meet #279, we need to connect markings work orders to their connected SR's flex notes.

Todo:

[x] Add one-to-many connection field on csr_flex_notes to work_orders_markings (field_3629)
[x] Add COUNT_FLEX_NOTES field to markings_work orders (field_3632)
[x] Create Knack API view of markings flex notes (scene_1271, view_3169)
[x] Create Knack API view of markings_work_orders that have an SR but no flex notes (scene_1271, view_3170)
[x] Write script that fetches unattached SR flex notes, fetches related work order, and updates the flex note record connection
[ ] text with more records
[ ] update deployment config / deploy

Migrated to atd-data-tech #1795

johnclary commented 4 years ago

@dianamartin i ran the script and have flex notes connected to work order MRK19-009590. You should be able to build your flex notes table on the job details now. You add a table that shows "records connected to the parent work order" > "csr_flex_notes" (or something like that).

dianamartin commented 4 years ago

@johnclary Tried looking at this. Did you configure this on test or prod? I unfortunately can't see a related table for "csr_flex_notes".

johnclary commented 4 years ago

@dianamartin i ran the script once in prod. When you're adding the table you can find the choice under "Records further connected to this page's work_orders_markings_job". Screenshot attached.

johnclary commented 4 years ago

I can run the script again in test or prod if you create more work orders from SRs.

dianamartin commented 4 years ago

@johnclary thanks! I was only looking at it on Test that’s probably why.

dianamartin commented 4 years ago

@johnclary Confirmed I was able to see the flex note connection on the jobs page in Signs & Marking Prod. Wasn't able to configure the Test environment bc it doesn't exist there that I saw.

dianamartin commented 4 years ago

@johnclary I have 3 work orders in PROD now, if you wanted to run the script in PROD again.

johnclary commented 4 years ago

Ended up deploying this through the atd-knack-api: https://github.com/cityofaustin/atd-knack-api/pull/5

Which also required a change to the Knack custom js: https://github.com/cityofaustin/atd-knack-signs-markings/pull/308

johnclary commented 4 years ago

will finalize testing with @dianamartin on Monday.