The Pragmatic Programmer

Appian, Pega, Java, DevSecOps, Quality Engineering

May 2020

  • Automated Testing With Cucumber For Appian Cucumber For Appian https://github.com/azmiratania/CucumberForAppian-20.1 https://cucumber.io/docs/gherkin/ Prerequisites for running the test: Run the appropriate setupCustomPropertiesFor… script Replace BROWSER with either FIREFOX or CHROME Replace APPIAN_URL with Appian URL, beginning with https:// and including /suite at the end (e.g. https://forum.appian.com/suite) Replace APPIAN_VERSION with (17.3, 17.4, 18.1, 18.2, 18.3, 18.4, 19.1 or… Read more

  • Extract a substring from a string https://www.w3schools.com/sql/func_mysql_substr.asp Read more

  • DECODE function

    Read more

  • https://docs.appian.com/suite/help/19.2/testing-applications.html Automated Testing With FitNesse for Appian Read more

  • DevOps with Appian

    https://docs.appian.com/suite/help/19.2/devops-with-appian.html Read more

  • Appian Architecture

    Enterprise Architecture Overview https://docs.appian.com/suite/help/19.2/Enterprise_Architecture_Overview.html#_ Read more

  • Appian & Apache Tomcat

    You would need a JEE compliant application server for running Appian. Tomcat is only a HTTP server and a servlet container. So you can use Apache Tomcat as a mere web server, with JBoss or other JEE application servers running Appian. https://docs.appian.com/suite/help/19.2/Configuring_Apache_Web_Server_with_Appian.html What does Java EE compliant means? It means that it passes the Java… Read more

  • https://forum.appian.com/suite/sites/licenses The following are the reasons for which a new license is required. Changes to: The operating system The CPU count -The FQDN (Fully Qualified Domain Name) of the machine on which the license is installed If the subdomain change does not alter the FDQN then a new license should not be required. https://forum.appian.com/suite/sites/support A… Read more

  • a!fromJson() Function Converts a JSON string into an Appian value. https://docs.appian.com/suite/help/19.4/fnc_system_a_fromjson.html List of Dictionary: 1 item Dictionary /*64-Bit Integer converted to Text*/ transId: “9223372036854775807” /*UTC Datetime without Seconds converted to Date and Time*/ submitTimeUTC: 7/16/2019 10:52 AM EDT /*Datetime without Timezone converted to Date and Time*/ submitTimeLocal: 7/16/2019 3:52 AM EDT /*Boolean data type*/ transactionOk:… Read more

  • Read Excel File

    readexcelsheet() function Plugin: https://community.appian.com/b/appmarket/posts/excel-tools NOTE: When deploying this plug-in, please delete all old versions of the ExportableDataSubset CDT AND update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset Read more