<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
I’m not having any luck with the documents, so I’ll beg for help here. :-)</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
I’m trying to get the most simple example of a scriptedsql connection to work, simply as proof a of concept at this point, but I can’t seem to make it happen … could someone tell me what blindingly obvious thing I have overlooked this time? </div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
I took the samples and changed them minimally. It successfully gets a user list from the table I’m querying. The table it’s querying is very simple, this is everything in it:</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<div>+------------+---------------------+---------------------+-----------------+----+-------+</div>
<div>| name | timestamp | birthdate | notes | id | netid |</div>
<div>+------------+---------------------+---------------------+-----------------+----+-------+</div>
<div>| joe schmoe | 2018-06-05 13:08:08 | 2001-12-12 00:00:00 | new notes here | 2 | joe |</div>
<div>| fred jones | 2018-07-29 23:36:39 | 2001-12-12 00:00:00 | added from doit | 4 | fred |</div>
<div>+------------+---------------------+---------------------+-----------------+----+-------+</div>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div><font face="Calibri,sans-serif">So I told the SearchScript.groovy to use “id" as __</font><span style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">UID__</span><font face="Calibri,sans-serif"> and “netid" as __</font><span style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">NAME_</span><font face="Calibri,sans-serif">_.</font></div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Where it fails is: under Resources, I click on ACCOUNTS, and then on the “RESOURCE” button, then when I click on one of the users, it only shows me the connld UID and connld Name attributes for the user, but NONE of the other attributes show up. But they’re
all in the schema, why won’t they show up? </div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Also, what if the SELECT I do only has a single unique key, can I use only one instead of both UID and NAME ?</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
A totally unrelated question: How dow one increase the Timeout value for the Admin GUI? It logs me out all the time and I have to keep logging back in again. </div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Thanks in advance!!! </div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
</body>
</html>