Live Chat Software by Kayako |
Knowledgebase: Material Control
Unable to check user Out of office
Posted by Syed Qutubuddin on 21 June 2017 01:29 PM
|
|
Problem: Unable to check user Out of office Solution: The issue is , If a user ‘A’ is already assigned as Stand by with other user ‘B’ , then other users can’t be a stand by of user ‘A’ ,the stand by option will disabled in user ‘A’ configuration. First we have to remove the user ‘A’ from the stand by option of user ‘B’ , then the stand by option will enabled for user ‘A’. In the case of big properties , it will be difficult find the user ‘B’ and some time it will be deactivated user. So you can use following sql query to find the user and stand by user. 1.select bst_id ,bst_name form besteller where bst_name like ‘A%’; 2.select bst_id,bst_name from besteller where bst_standin=(bst_id of user A); 3. update besteller set BST_OUTOFOFFICE=0 ,BST_STANDIN=null where bst_id = (bst_id of user B); Solution Provided by Mr. Mohammed Haris . | |
|
Comments (0)