Query: POS Back Office - Mark Pending articles details and count ...

        Most of the Post offices have Mark Pending article in POS Back Office. The same can  be viewed under POS Back Office --> IPVS--> Mark Pending articles.

          But we are unable to export the articles and find the total pending articles count form the above scenario.

          Now lets see, the procedure to full fill our need.

 1) Open  Sybase Central


2) The interface of Sybase Central is as follows.


3) Open "SQL Anywhere 16" and click on " Open Interactive SQL" under  Tools.


4)  Connect  to the Database with the given credentials.


5) Now execute the following query. It will generate the all Mark Pending articles details. The same       can be exported .


 6)  Execute the following query and get the total count of Mark Pending articles details.


Query to Delete Mark Pending articles..???