LIKE & ESCAPE Feature in SQL Cockpit

Should wildcard characters be part of the search term? What should I do? The solution is very easy in our SQL Cockpit, LIKE statement must be told that for example ‘%‘ is understood as a simple character instead of wildcard character. This is done by placing a special character in front of it and specifying this character as an „ESCAPE character“ at the end of command. Example User wants to select the table line(s) which […]

Weiter lesen

Domain Text Feature in SQL Cockpit

I don’t see the domain description in the result SQL statement screen? What should I do? The solution is very easy in our SQL Cockpit, there is an user setting with which the user can see not only the fixed value, but the description of the value itself. There is no need to manual check the description, in case it exists it is displayed in the result screen. Example The “Business partner category“ domain contains […]

Weiter lesen