XMLWordPrintable

    • 1
    • 1

      Hi,I'm currently evaluating Insight (along with JIRA Service Desk) as a possible replacement to our current ITSM solution and am very impressed so far about it's ease of use and flexibility .One thing I'm struggling with tough is that IQL is limited in its expressiveness (at least of what I can see at https://documentation.riada.se/pages/viewpage.action?pageId=13573623).Here are some concrete use cases I had during LDAP and CSV imports where I'd need some string manipulation possibilities:* LDAP import: Remove the first part of an LDAP distinguishedName (e.g. remove "cn=someuser," from "cn=someuser,ou=unit1,dc=example,dc=com" so I can create a reference to the object represented by "ou=unit1,dc=example,dc=com")* CSV Import: object1 consists of 2 fields: name, path; object 2 consists of 2 fields: name, path; I'd like to create a reference from object2 to object1 using object2.path=object1.path + "\" + object1.nameIn general I'd expect the following possibilities to be usable in IQL:* String concatenation* String splitting and joining using delimiter* Different ways to build substrings * See https://commons.apache.org/proper/commons-lang/apidocs/org/apache/commons/lang3/StringUtils.html for inspiration* Substitution, RegEx matching, Search/Replace* Convert to lowercase/Uppercase/lowerCamelCase/UpperCamelCase/words-with-dashes/words_with_underscores* Replace special characters to generate safe words for URLs, filenames, ...* Encode/decode strings (e.g. urlencode/urldecode, HTML/XML, JSON, base64)* IP address and netmask matching and manipulation* Math functions (add, substract, multiply, divide, power, exponent)* More boolean expressions (NOT and OR)* Bitwise operators (AND, OR, XOR)* Maybe more I did not yet think of ;-)If the use cases I mentioned above are already possible in a way I had not seen, please let me know.Thanks,Andreas

            Assignee:
            Unassigned
            Reporter:
            Alex Cooksey (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: