Query for 'Ready for Verify'

[bbobo]

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
------------------------------

[Ben.Lyons1 · Accepted solution]

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
------------------------------

[bbobo]

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
------------------------------