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

.
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).