[midPoint] scriptedsql example

[Frigerio, Joshua]

I’m not having any luck with the documents, so I’ll beg for help here. :-)

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?

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:

+------------+---------------------+---------------------+-----------------+----+-------+
| name       | timestamp           | birthdate           | notes           | id | netid |
+------------+---------------------+---------------------+-----------------+----+-------+
| joe schmoe | 2018-06-05 13:08:08 | 2001-12-12 00:00:00 | new notes here  |  2 | joe   |
| fred jones | 2018-07-29 23:36:39 | 2001-12-12 00:00:00 | added from doit |  4 | fred  |
+------------+---------------------+---------------------+-----------------+----+-------+

So I told the SearchScript.groovy to use “id" as __UID__ and “netid" as __NAME__.

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?

Also, what if the SELECT I do only has a single unique key, can I use only one instead of both UID and NAME ?

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.

Thanks in advance!!!


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180803/a51d38d7/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ExportedData_ResourceType_1533256915857.xml
Type: application/xml
Size: 13942 bytes
Desc: ExportedData_ResourceType_1533256915857.xml
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180803/a51d38d7/attachment.xml>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SchemaScript.groovy
Type: application/octet-stream
Size: 2731 bytes
Desc: SchemaScript.groovy
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180803/a51d38d7/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SearchScript.groovy
Type: application/octet-stream
Size: 4565 bytes
Desc: SearchScript.groovy
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180803/a51d38d7/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TestScript.groovy
Type: application/octet-stream
Size: 1003 bytes
Desc: TestScript.groovy
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180803/a51d38d7/attachment-0002.obj>