Hi,   We have in CS three separate Categories A, B, C for our both separated Support Teams A and B. Category B has 'Only Member has Access', and only Teams B User are the Member in this category; Category A has not this Limit. In the User role, the Teams A User can read/edit all requests, the Teams B User can only read/edit Requests in own Categories. If Teams B need 2-Level Supports from Teams A, he can change Ticket to Category C, it's the Under-Category of B and all User of Teams A and B are the Member of this Category. With this Configuration it works fine, both Teams get separated Visibilities and access to their Tickets in separated Categories and get common Access to the Tickets in Category C for 2nd-Level Support in our one Ticketsystem. Now the Isses is, if Teams A User find that Ticket is not for his Teams and changed to Category B which he has not Visibility, it raised up an Error Message: and it created a new empty Ticket, only filled Field are Ticket ID and created Time at current Time. I asked our SO Local Suppprt Teams to check that Error Message and see more information: An exception occurred in script: "Service: Saving a request: Message for closing Tickets" at: line 97, char 7 Original exception: DbODBC::FatalException at , line 97, char 7 An exception occurred in script: "Screen: Edit ticket 80 copy, Button: ok" at: line 138, char 16 Original exception: EjScript::RunTimeException i have checked both Scripts. By crm-scripts for Trigger 'Saving a request', the error message was caused by t.save(). I know in this Trigger we don't need this code to save a Ticket, but without this, the set Value of user-defined Fields (UDF) will not be saved to the current Tickets. By Scripts to OK-Button for Screen of Edit-Ticket, the Error Message was caused by red-arrow indicated code. I know all UDFs will be saved in default code: t.setValue(se.getField(0), extraField.toString()); But for some UDFs related to Tables i have set separated in the Screen, because I set special Simple Value to get limited Results of Output of the UDF related Tables. That means, i need both codes in Scripts which caused the Error message. Now the question is, how could i optmize the Scripts to avoid this Issues with Error Message and new created empty tickets by User changed Ticket to Category with limited Access which he dos not have? The correct Output instead of that Error Message after this Changing should be for that User sth. like: You have no rights to access this Ticket. Many thanks! 

Hi!  Version 11.6 added support for UTM parameters to forms, but is it possible to set these through scripts aswell?  One of our customers are using crmscript based endpoints where they get data and they would like to set the UTM data that way aswell, so they can make selections on persons to see which endpoint they came from.  Is it possible to create these rows without an formsubmission and is it via a NSClass or do you have to use the searchengine to insert the row?

Hi all, We have an application that still uses the SOAP interface for searching, but we’ve run into a small problem. We have a new customer running On-Prem 10.3 , and we need to search for phone numbers. We are using the following code: string phoneFullNumber = "4723354000"; using (SuperOffice.CRM.Services.FindAgent find = new SuperOffice.CRM.Services.FindAgent()) {     var archiveColumns = new string[] { "phone.SearchPhoneNumber", "phone.owner_id", "phone.ptype_idx", "phone.phone_id" };     var restriction = new SuperOffice.CRM.ArchiveLists.ArchiveRestrictionInfo[]     {         new SuperOffice.CRM.ArchiveLists.ArchiveRestrictionInfo("phone.SearchPhoneNumber", "EQUALS", phoneFullNumber)     };     SuperOffice.CRM.Services.FindResults results = find.FindFromRestrictionsColumns(         restriction,         "Dynamic",         archiveColumns,         int.MaxValue,         0     );     foreach (var row in results.ArchiveRows)     {         // Process results     } } We believe this approach has worked in the past, but it no longer returns any results.   We also tried setting IsActive = true on the restriction, but it didn’t make a difference.   When logging the request, this is what is sent: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:ApplicationToken xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88">519a79b0aeaa3984c78da6a4abc50d49</h:ApplicationToken><h:Credentials xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><h:Ticket>7T:NwAwADcANgA5ADEAMgBiADMAMAAzAGQAMwBkADkAZABiADgANAA3AGEAMwAwADQANwBkADYANgBkAGIAZgAzADsAOQAwADEAOQA2ADMAMwA0ADMA</h:Ticket></h:Credentials><h:TimeZone xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><h:SoTimeZoneId>0</h:SoTimeZoneId><h:SoTimeZoneLocationCode/></h:TimeZone></s:Header><s:Body><FindFromRestrictionsColumns xmlns="http://www.superoffice.net/ws/crm/NetServer/Services88"><Restrictions xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><ArchiveRestrictionInfo><Name>phone.SearchPhoneNumber</Name><Operator>EQUALS</Operator><Values xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><a:string>4723354000</a:string></Values><DisplayValues xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><ColumnInfo i:nil="true"/><IsActive>true</IsActive><SubRestrictions i:nil="true"/><InterParenthesis>0</InterParenthesis><InterOperator>And</InterOperator><UniqueHash>-1164823746</UniqueHash></ArchiveRestrictionInfo></Restrictions><ProviderName>Dynamic</ProviderName><DesiredColumns xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><a:string>phone.SearchPhoneNumber</a:string><a:string>phone.owner_id</a:string><a:string>phone.ptype_idx</a:string><a:string>phone.phone_id</a:string></DesiredColumns><PageSize>2147483647</PageSize><PageNumber>0</PageNumber></FindFromRestrictionsColumns></s:Body></s:Envelope> And this is the response we get: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:ExceptionInfo i:nil="true" xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"/><h:ExtraInfo i:nil="true" xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"/><h:Succeeded xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88">true</h:Succeeded><h:TimeZone xmlns:h="http://www.superoffice.net/ws/crm/NetServer/Services88" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><h:SoTimeZoneId>0</h:SoTimeZoneId><h:SoTimeZoneLocationCode/></h:TimeZone></s:Header><s:Body><FindFromRestrictionsColumnsResponse xmlns="http://www.superoffice.net/ws/crm/NetServer/Services88"><Response xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><TableRight i:nil="true"/><FieldProperties/><ArchiveColumns/><ArchiveRows/><RowCount>0</RowCount></Response></FindFromRestrictionsColumnsResponse></s:Body></s:Envelope> As you can see, no rows are returned ( RowCount=0 ), and there are no errors.   Has anyone encountered this before or have suggestions on why this might be happening? Could this be related to provider availability, configuration, or permissions in On-Prem 10.3?   Thanks in advance for any advice!  

What I was trying to do I created an “After request saved” trigger that uses a yes/no EventDataDialogDefinition to display a dialog asking the user whether they want to send an email when the ticket status is changed, on mobile CRM. What I expected to happen I expected the dialog to appear every time the ticket status is changed in Mobile CRM. What actually happened In the online CRM version, everything works as expected. In Mobile CRM, the behavior is inconsistent: When changing the status using the pen icon and updating it that way, the trigger runs and the dialog opens. When changing the status using quick change or the top-right options button, the trigger does not behave the same. With “After saving request” , the trigger does not run at all. I then tested additional trigger types ( “ Request changed status ” and “ Request saved ” ). These triggers did run when updating via quick change / options, but the dialog did not open. Steps to reproduce the problem Create an "After request saved", “Request saved”, or "Request changed status" trigger that uses EventDataDialogDefinition to open a yes/no dialog. Open a request in Mobile CRM. Change the status via the pen icon → dialog opens. Change the status via quick change or the options button → trigger may run, but the dialog does not appear. #setLanguageLevel 4; // Displays delete ticket yes/no dialog Void DisplayDialog(EventData ed) { // Display dialog EventDataDialogDefinition dialog; dialog.setIcon("question"); dialog.setType("yesno"); dialog.setPrefix("openDialog_"); dialog.setTitle("Some title"); dialog.setText("Some text"); ed.showDialog(dialog); } EventData ed = getEventData(); String dialogResponse = ed.getInputValue("openDialog_button"); if (dialogResponse.isEmpty()) DisplayDialog(ed); // Do nothing if (dialogResponse == "no") return; if (dialogResponse == "yes") // Send email   Question Is this intended behavior in Mobile CRM, or could this be a potential bug?    

Hello! In this guide I found for task menus , I found a fatastic piece of code that looks like this:  ed.setStateValue( "command:ticket.tab.close" , ticketId); I have many scripts where I want to do things like this, and have before this used soprotocol to navigate around the environment using code. But, soprotocol has it's limitations in the documentation and mainly navigating to new places and creating new enitytys is possible. So I tried looking around the documentation for more commands, and I have not found anything, not in the EventData class or the class method documentation for SetSateValue. So, I was wondering, where do I find the documentation for the state value commands for event data? And as a sub-question, is there a command to force-reload the page you are on? Or specific spaces in SuperOffice? That would also be a wonderful thing, to not have to use html and the window-methods to force a reload. 

Hi everyone! I'm working with data from our CRM system and modeling it in Power BI. I’ve encountered a structural issue between two tables: Ticket Contains a field called tags , which stores a foreign key array . The values in this field are text strings , not numeric IDs. Tags Contains a field called tags_id , which is the primary key . This PK is a numeric indexed field (clustered, unique). The problem is that the Ticket.tags field contains text-based identifiers, while the Tags.tags_id field is numeric. Because of this, it's not possible to create a direct relationship in Power BI between the two tables. I'm looking for guidance on: How the CRM system expects these fields to be related; Whether there is a missing mapping table or lookup logic; Or if there's a recommended method for converting the text values in Ticket.tags into the numeric tags_id values so they can be modeled properly in Power BI. Any insight into how these two fields are intended to connect would be greatly appreciated.

Hi, i have a field definied for contact the field is SuperOffice:43. By more contact are this field set to 44444. How can i make a SearchEngine, to give me, all the contact that have SuperOffice:43 = 44444 ? Have you got any Idea? Thanks

I have a simple flow which adds a person to a static selection when a person is added as a project member to a project. The flow works fine when you manually adds a project member. But when I do it by CRM-script, the flow doesn't trigger. I use the code below to add project memeber. Is this a bug? NSProjectAgent pAgent; NSProjectEntity project = pAgent.GetProjectEntity(16); NSProjectMember[] members = project.GetProjectMembers(); NSProjectMember pMember; pMember.SetProjectId(project.GetProjectId()); pMember.SetContactId(809); pMember.SetPersonId(1143); members.pushBack(pMember); project.SetProjectMembers(members);   project = pAgent.SaveProjectEntity(project);