需要在登录时仅菜单选项过滤为用户
问题说明
需要过滤菜单选项以仅选择已分配给已登录用户的问题。
如何完成此操作？
表:: Master_file
idno name region officer_in_charge
---------------------------------------
001 pet east james
002 pal east james
003 ama east james
004 joe east james
005 jon east paul
006麦克东保罗
0051 dav east allen
Login_file
--------- -
user_id
-------------------------------- ----
james
paul
allen
你好链接登录文件，如果詹姆斯选择菜单选项来处理分配给他的问题他只会得到那些只有那些被分配给他的人
idno name region officer_in_charge
------------ ---------------------------
001宠物东詹姆斯
002 pal east james
003 ama east james
004 joe east james
Please协助
我尝试了什么：
做了我自己的研究和试图在网上看到一个类似的
Need to filter a menu option to only pick issues which have been assigned to a user who has logged on.
How do you accomplish this ?
Table ::Master_file
idno name region officer_in_charge
---------------------------------------
001 pet east james
002 pal east james
003 ama east james
004 joe east james
005 jon east paul
006 mic east paul
0051 dav east allen
Login_file
----------
user_id
------------------------------------
james
paul
allen
How do you link the login file such if james select the menu option to work on the issues assigned to him he will only get those and only those which have been assigned to him
idno name region officer_in_charge
---------------------------------------
001 pet east james
002 pal east james
003 ama east james
004 joe east james
Please assist
What I have tried:
Done my own research and tried to see a similar one on the net
正确答案
我会假设您在应用程序的某处保留了用户登录值。
从数据库中获取数据集时，需要在officer_in_charge == LoginUserName上过滤集合
I would assume you retain the user login value in your application somewhere.
When you get your dataset from the database you need to filter the collection on the officer_in_charge == LoginUserName
这篇好文章是转载于：学新通技术网
