I'm trying to understand how the SearchEngine work. What is the difference between the 2 searchengines below? I get 2 different results. In case  In the second case I get a row, where y_eb_eval_koder.x_ft_heading == '82', which it shouldn't be allowed to.   Case 1: String null; SearchEngine se; se.addField('y_eb_eval_koder.id'); se.addField('y_eb_eval_koder.x_ft_heading'); se.addCriteria('y_eb_eval_koder.x_ft_heading', 'Equals', '80', 'And', 1); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Is', null, 'Or', 2); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Equals', '0', 'And', 2); se.buildSql() gives: select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where a0.x_ft_heading = ? and (a0.x_eb_post is NULL or a0.x_eb_post = ?) //reducing parantheses select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where a0.x_ft_heading = ? and (a0.x_eb_post is NULL or a0.x_eb_post = ?)   Case 2: String null; SearchEngine se; se.addField('y_eb_eval_koder.id'); se.addField('y_eb_eval_koder.x_ft_heading'); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Is', null, 'Or', 1); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Equals', '0', 'And', 1); se.addCriteria('y_eb_eval_koder.x_ft_heading', 'Equals', '80', 'And', 2); Using se.buildSql() and reducing parantheses again, I get this: select a0.id,a0.x_ft_heading from y_eb_eval_koder a0 where ((a0.x_eb_post is NULL or a0.x_eb_post = ?) and ((a0.x_ft_heading = ?))) //reducing parantheses select a0.id,a0.x_ft_heading from y_eb_eval_koder a0 where (a0.x_eb_post is NULL or a0.x_eb_post = ?) and a0.x_ft_heading = ?)   Trusting the printed SQL I end up with the following: Case 1 : select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where a0.x_ft_heading = ? and (a0.x_eb_post is NULL or a0.x_eb_post = ?) Case 2 : select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where (a0.x_eb_post is NULL or a0.x_eb_post = ?) and a0.x_ft_heading = ?   Isn¨t those the exact same expressions, just with the 2 where-statements switched?  

Not sure if this belongs in this forum, but: Consider a installation, planned for upgrade to V. 10 with about 120 users (on-premise). Currently running on a 2017 SQL. With it reaching EOL, customer is considering SQL 2022 (Standard) Considering lisensing per core. What are the mimimum/suggested # of cores that should be considered ?   regards      

Hi, We are working from a webpanel on the SuperOffice logo, and we need to open the dialog window to create a new appointment with pre-filled data. We can open up specific appointments just fine with: SuperOffice.ClientCrossMessaging.executeSoProtocol('appointment.main[refresh=false]?appointment_id='+id);   But, when running the following code, the Sale is not populated (but, it works when we are actually standing on the sale in the gui) SuperOffice.ClientCrossMessaging.executeSoProtocol('appointment.main[new=true]?appointment_id=0&sale_id=12345'); How can this be achived? Regards Pär Pettersson

Hi, When will the old SuperOffice marketing template stop working? I am quite sure I have seen som notice about that the old marketing template editor will stop shipping in some version? But I can not find that information again. Anyone having informatiion about this? I have developed 3 templates long ago to a customer and need to rebuild them if they will not work anymore (10.3.3) seems ok. Is it possible to convert them to new editor somehow or do I need to create them from scratch. //Anders

Hi,   I would like to know if it is possible to Hide/Show custom Fierlds based on the value of the fields? If the field is empty, then hide it otherwise show it to the enduser.   Thanks   /Siavash

Hello!  When I use a SSO login.microsoft.com I get an error saying " The loading of “ https://login.microsoftonline.com/common/oauth2/authorize? .... in a frame is denied by “X-Frame-Options“ directive set to “deny“. I understand that this is by design, but are there anyone that have solved this in some way, and they want to share it? Regards Martin

Hello SuperOffice team, We are currently trying to integrate a SO form as plain HTML into our CMS Drupal.  However, our agency gets this error message when trying to integrate the form. Do you know why we get the error message and how we can solve the problem? Many thanks and best regards, Zornitsa Nenova

Hi All, I have been advised by Guttorm to log this query on community, and it relates to the new Outlook web application, which users are getting prompted to move to.  Currently with this web app you can only archive emails to the online version of SuperOffice, however our on-premise customers are asking when this will be available for them.  Do we have any updates on where this is in the development roadmap? Many thanks, Trevor

Dear all, One of our customers has several international branches. Two of these countries work with SuperOffice using the same tenant. We are currently trying to move the documents to Sharepoint but are having problems with our colleagues from abroad. In the Microsoft world we have different tenants per country. The authorizations are set so that the AT colleagues can see and edit the documents on the GE Sharepoint. Unfortunately, SuperOffice does not seem to support this, ALL users with user plan must be in the same Microsoft Entra subscription . We made some tests to see what happens. Transfer to sharepoint worked fine. The AT users can open and edit the documents from SO. Our only problem is that the AT users cannot create new documents. They get a 400 error. Has anyone had this problem and solved it? Thanks in advanced Georg