search

WSDOT / HATS

Highway Activity Tracking System Issue Tracker
6 stars 0 forks source link

Close Pending Activities #1290

Closed joeschmit closed 5 years ago

joeschmit commented 5 years ago

Need a mass close of pending activities where org code is 43, feature type Pavement Markings.

Thanks

Joe

jhudsonWA commented 5 years ago

Yep, I'll run this after 5 pm today. Here is the query with the records that will be completed.

select * from PendingActivity pa inner join [Event] e on e.EventId = pa.TriggeringEventId where pa.CompletedDate is null and e.OrganizationCode like '43%' and LocalFeatureTypeId = 26

jhudsonWA commented 5 years ago

Done

joeschmit commented 5 years ago

Thanks.

On Feb 20, 2019, at 15:27, Joshua Hudson notifications@github.com<mailto:notifications@github.com> wrote:

Done

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/WSDOT/HATS/issues/1290#issuecomment-465797334, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AA2Az8TtGEPfnQwKf76flYblWuu-RyIhks5vPdnygaJpZM4bFof-.