topic RE: Query for 'Ready for Verify' in Product Forum

Query for 'Ready for Verify'

bbobo — Thu, 07 Oct 2021 22:26:00 GMT

I am querying the 'DecipherServerDb' to figure out if a batch is finished processing or not. I can query the dbo.Batch table status column and know that if the status is '6' then it is ready to be exported. The problem I'm running into is that if the batch needs data verification I can't rely on the status column. Previously I was checking if the status was '5' then I assumed verification was needed but that seems to be invalid because the status can show as '5' and then eventually move to '6'. Is there another table or column in the database that I can query to see if data verification is needed on a batch?

Thanks! (Decipher v1.2)

------------------------------
Ben Bobo
RPA Developer
Constellation Brands
America/New_York
------------------------------

RE: Query for 'Ready for Verify'

Ben.Lyons1 — Fri, 08 Oct 2021 15:16:00 GMT

Hi Ben,

You could try combining it with the last ID that was used. Data Verification will be after the capture stage.

In my environment the capture role is ID 20, so I would use

WHERE LastProcessedWithRoleId = '20' AND State = '5'.

Just in case, you can find your role ID's in the User Role table.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

RE: Query for 'Ready for Verify'

bbobo — Fri, 08 Oct 2021 16:00:00 GMT

Thanks Ben! That's the type of thing I was looking for. I'll give it a try.

------------------------------
Ben Bobo
RPA Developer
Constellation Brands
America/New_York
------------------------------