Uses ILS User source.

Display Fields:

ILS User -> Last Name
ILS User -> First Name
ILS User -> Middle Name
ILS User -> User ID (Count)

Filters:

ILS User -> Active (Equals) ("true")
ILS User -> Is Deleted (Equals) ("false")
ILS User -> User ID (Count) (Greater than) ("1")


{"version":5,"core_class":"au","select":[{"alias":"Last Name","path":"au-family_name","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"family_name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"First Name","path":"au-first_given_name","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"first_given_name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"Middle Name","path":"au-second_given_name","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"second_given_name","transform":"Bare","transform_label":"Raw Data","aggregate":false}},{"alias":"User ID","path":"au-id","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"id","transform":"count","transform_label":"Count","aggregate":true}}],"from":{"alias":"fe21ca9ecd516f33ec379ecc11aa7051","path":"au-au","table":"actor.usr","idlclass":"au","label":"ILS User"},"where":[{"alias":"Active","path":"au-active","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"active","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"=":"t"}},{"alias":"Is Deleted","path":"au-deleted","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"deleted","transform":"Bare","transform_label":"Raw Data","aggregate":0},"condition":{"=":"f"}}],"having":[{"alias":"User ID","path":"au-id","field_doc":"","relation":"fe21ca9ecd516f33ec379ecc11aa7051","column":{"colname":"id","transform":"count","transform_label":"Count","aggregate":1},"condition":{">":"::P0"}}],"display_cols":[{"name":"family_name","label":"Last Name","datatype":"text","index":0,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"first_given_name","label":"First Name","datatype":"text","index":1,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"second_given_name","label":"Middle Name","datatype":"text","index":2,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":""},{"name":"id","label":"User ID","selector":"usrname","datatype":"id","index":3,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","transform":{"label":"Count","transform":"count","aggregate":true},"doc_text":""}],"filter_cols":[{"name":"active","label":"Active","datatype":"bool","index":0,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","operator":{"op":"=","label":"Equals"},"transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":"","value":"t"},{"name":"deleted","label":"Is Deleted","datatype":"bool","index":1,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","operator":{"op":"=","label":"Equals"},"transform":{"transform":"Bare","label":"Raw Data","aggregate":false},"doc_text":"","value":"f"},{"name":"id","label":"User ID","selector":"usrname","datatype":"id","index":2,"path":[{"label":"ILS User","id":"au","classname":"au","struct":{"name":"au","label":"ILS User","table":"actor.usr","core":true,"pkey":"id","pkey_sequence":"actor.usr_id_seq","core_label":"Core sources","classname":"au"},"table":"actor.usr"}],"path_label":"ILS User","operator":{"label":"Greater than","op":">"},"transform":{"label":"Count","transform":"count","aggregate":true},"doc_text":"","value":"1"}]}