Hey all,An employee would like to search for the phone number of a customer in Account Contacts to find him/her faster, however, currently there is no formatting standard employed for phone numbers. By this, I mean that a phone number can look like any of the following examples:+46 123 4567012-345 67012-345670 1234567 etc…This means that if I wanna find all instances of this phone number, I would only get the phone numbers that are uninterrupted (which might not even exist). Before this employee was able to search for any phone number using the following sql search:replace(replace(replace(replace(replace(PHONE,'(0)',''),' ',''),')',''),'(',''),'-','') like '%760400560' orreplace(replace(replace(replace(replace(MOBILE,'(0)',''),' ',''),')',''),'(',''),'-','') like '%760400560'The issue currently is that the Advanced search in IFS Cloud does not recognize “replace”: CrmCustomerContact/CustomerContactOverviewPage (server error)Malformed Request.Error details: [{"code":"EXPRESSION_PROPERTY
Hey, I am trying to fix a broken excel migration job, but it keeps throwing the following error:Expected ',' or '}' after property value in JSON at position 222 (line 1 column 223) My issue is that I don’t know how I can check what the JSON file looks like that is created from the Excel file. Is there a way to see that, perhaps inside the debugger?Please let me know if you need more information regarding this problem to better understand.Thank you for your assistance in advance!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
