Anton Šperov

For me editing theese ../env-production/top-request-mgmt-itil/model.itop-request-mgmt-itil.php i deleted the values 'impact' and 'urgency' from the constant: PORTAL_USERREQUEST_FORM_ATTRIBUTES did'nt change anything.

https://sourceforge.net/p/itop/discussion/1113906/thread/c565e9a0/ Answered there

Instead of making it this complicated, i fugured out the correct way. SELECT FunctionalCI WHERE org_id = :current_contact->org_id

ye, Dataadministration ->catalogs -> organisations on top right you have 3 options New, Other Options, and toolbox logo. CLick on it and choose "excel export" new window will open and there are 3 rows Excel option , Available columns from organisation -- here tick the id(Primary key) and you wil lsee the id appear. Maybe not the correct way but if it works then it´s not stupid Anton

Also, when i try to replace the C.id =:current_contact_id part with C.id =17 (checked manualy for a certain user), i still get the same error.

Hi. Im trying to set up a request template, which allows the user to pick a device (from his/her organisation) and add it to the ticket description. Im using this line: SELECT FunctionalCI AS FCI JOIN Contact AS C ON C.org_id = FCI.org_id WHERE C.id =:current_contact_id and getting this error: An error occured while running the query: Wrong format for Join clause (right hand), expecting an id, found 'org_id' in: SELECT FunctionalCI AS FCI JOIN Contact AS C ON C.org_id = FCI.org_id WHERE C.id =:current_contact_id...

What i think john johnny means is somekind of synronisation. The link you provided will import user accounts - yes, but if users will have to be removed? or even added - i wouldn´t mind having an option to add a person to a AD group "itop_county" and having it pop up magically into itop users-contacts, with correct (predefined by AD group) organisation. I managed to setup my AD_import file so that it will setup users by LDAP, but it is still importing users, not linking the LDAP authentication.

intresting question, just started using it and indeed, when i open up a subservice, and try to modify it, then i see the request template page, but there is no option to add an existing one.