Started: 9/20/2018 8:55 AM
Picture: Mike Odeh
Mike Odeh
SQL Connector - Query current user login

Hi, I was trying to set a dynamic where Clause ​in the SQL Connector control, where the current user login equales the employee login name in the sql table's column, but the query always returns nothing becuase the current user login fubction returns 'i:0#.w|domain\login_name

any ideas ?


 

Picture: Mike Odeh
  • Mike Odeh
http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/mike_MThumb.jpg?t=63624568071" alt="Picture: Mike Odeh" />
Mike Odeh

Hi, I was trying to set a dynamic where Clause ​in the SQL Connector control, where the current user login equales the employee login name in the sql table's column, but the query always returns nothing becuase the current user login fubction returns 'i:0#.w|domain\login_name

any ideas ?


 

19/20/2018 8:55 AM9/20/2018 8:55 AMNoCodes & Scripts
6.7223468522355
19/20/2018 8:47 AM1
Jim Hidson
Posted: 9/23/2018 5:45 AM
Picture: Jim Hidson
Jim Hidson
You can use the JS replace() function to remove the LDAP data from the current user login name, and these are fixed for all users on the system except if you have several domain forests.

 



Picture: Jim Hidson
  • Jim Hidson
http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/jim_MThumb.jpg?t=63627189186" alt="Picture: Jim Hidson" />
Jim Hidson
You can use the JS replace() function to remove the LDAP data from the current user login name, and these are fixed for all users on the system except if you have several domain forests.

 



Mike Odeh3709/23/2018 5:45 AM9/23/2018 5:45 AM
9/19/2018 7:49 AM