How do you store the Manager id in wp_usermeta?
Do you with “user object” mean as an ldap object, e.g. CN=X,OU=Y,OU=W,DC=XX,DC=YY
How about changing the “type” when importing the Manager field? We use “cn” as the type, maybe you can check if any other type works better for you?
I have managed to get the manager name just using CN now thank you.
I now need to retrieve the user login from the managers user profile so I can populate the “user” field in Gravity Forms. Any help on how I achieve this greatly appreciate 🙂
Select user_login from wp_users where display_name = "[Manger Name]"
But you might need to replace the doublequotes with apostrophes since this is what MySQL/MariaDB prefers.
Unless you already have it installed I would recommend install the “MySQL WorkBench” to work with your queries from the comfort of a UI.
I would also recommend that you setup a RO account in your DB and not use the WP DB account. Google for “Mysql add new user” and make to only Grant “select” for that account.
Finally I would recommend to install “Softerra LDAP Administrator” to roam around your AD, unless you already have such a tool.
