Foundation

Greetings All, I am looking for some experiences with interfacing with CRM systems.  Our team has looked at Salesforce and Microsoft for CRM, but they are asking us to dive deeper to find out what is out there that might be integrated with Appian or at least have some better off-the-shelf integrations. One that we happen to like is Creatio CRM.  It obviously has its own BPA capabilities.  But it does not have key features important to us.  So I am thinking INTEROPERABILITY with Creatio CRM via Appian workflows or possibly some other CRM? Thanks for your thoughts!! Paul

Hi Experts, I have a local variable which store list of array, I need to get the col2 value where col1 is "RF", Kindly help with the expression as when i tried below expression but its not returning the correct value. localVariable( local!a: {{col1: "TX", col2: "Gaurav Singh"}, {col1: "Civil", col2: "Gaurav Singh"}, {col1: "RF", col2: "Gaurav Singh"}}, local!RF:  index( index(local!rows,"col2",{}), wherecontains(  tostring( index( local!rows, "col1", {}  )  ),  "RF" ), {} ))) Kindly help

Hello All, does anybody know how can I export text from DSE and preserve the formatting defined by HTML tags? The use case is following: 1) I have a grid with fields where text can be formatted (bold, italic, underline, strikethrough text) 2) Formatted text is added thru the component richTextField from plugin created by Appian, which provides with a simple editor for rich text. 3) Formatted text is saved in DB as HTML text and it is converted to Rich Text display field only for displaying. 4) Customer is requesting the function which exports the data to Excel file and also preservers the formatting. 5) The export process works fine, but Excel does not correctly interpret HTML tags used for formatting. It is imported as a pure text. This is the process model that I use. Any advices on how to solve this case? Thank you, Michal

I have created an expression rule, which retrieves all colors based on a "lot number".  The rule works fine. But when I try to use the result on choiceLabels and choiceValues, it gives the error "The choiceLabels and choiceValues arrays must be the same length, but choiceLabels was length 2 and choiceValues was length 1". Both the choicelabel and choicevalue have been passed on the same rule. My database currently has 2 colors for lot number 1. May I know what did I do wrong? Code of choice label and choice value: choiceLabels: rule!LN_Fetch_colors(local!lotId).data.colorsAvailable, choiceValues: rule!LN_Fetch_colors(local!lotId).data.colorsAvailable, This is the output of the rule: This is my entry in database:

Hi I am having issues with the following sql running too slow so that the Tempo report using it fails. CREATE    OR REPLACE VIEW TCAP_PROPOSAL_RECORD_VW ASSELECT DISTINCT S.SECURITY_ROLE AS SECURITY_ROLE    ,Z.ID AS ID    ,Z.COLLEGE_CL_CODE AS COLLEGE_CL_CODE    ,Z.COLLEGE_CL_DESC AS COLLEGE_CL_DESC    ,Z.TYPE_OF_CHANGE AS TYPE_OF_CHANGE    ,Z.LEVEL_OF_CHANGE AS LEVEL_OF_CHANGE    ,Z.PROPOSAL_TITLE AS PROPOSAL_TITLE    ,Z.PROPOSAL_FOR AS PROPOSAL_FOR    ,Z.ACADEMIC_FAN AS ACADEMIC_FAN    ,Z.ACADEMIC_NAME AS ACADEMIC_NAME    ,Z.INITIALISED_BY AS INITIALISED_BY    ,Z.INITIALISED_BY_NAME AS INITIALISED_BY_NAME    ,Z.STATUS AS STATUS    ,Z.FOLDER_ID AS FOLDER_ID    ,Z.COURSE_TOPIC_CODES AS COURSE_TOPIC_CODES    ,Z.UNRESOLVED_COMMENTS AS UNRESOLVED_COMME

How to Improve Performance of Query expression?

How to write a code to get even numbers between 1 to 100?

Hi All,      we have QA environment as 20.4 and the prod as 20.3,      can anyone help, how we can deploy the application in QA to PROD. Warm Regards Vineeth

Hi All,    Is there a way we can recall a Mail sent from Appian Process Model. Warm Regards Vineeth

I need to display the groups say 5 group and corresponding its users available in that particular group using drop-down options. I also need to add new member to that group.   Can someone please share the code how to achieve this.

I've enabled SANL Authentication and changed default sign-in page as other than native "Appian Sign-in page". The problem now, my SSO sign in page not working as expected and I am unable to proceed with it. Now I want to reset back to "Appian Sign-in page" as default sign-in page, however I am unable to reset it back as its always displays SSO sign-in page and unable to navigate to "Admin Console" -> SAML Authentication settings. Could someone please suggest the solution approach to resolve this? Thanks.

Hi all, We have a site based app where we display all pages with full width. However, when a user receives a notification about a new task and clicks on the link, the task is loaded on an appian site page with the standard width, not with full width. Can I set the width of a form to be displayed in full width when we load it from an email notification link? Thanks a lot!

Hi All, Is there any way to validate number without using regex. Here is the requirement, Need to enter  only number upto 15-18 character. I can't use here integer or floating-point field so I am using textbox with regexmatch function to validate but my requirement to not use regexmatch function. Is there any way to achieve this ?

I want to retrieve user name on the basis of first name . How can I achieve this ?

when i use normal database using through expression rule it will be show in multiple card's when i use web integration so it will showing all information in only one card layout , how can i spilt this information into multiple card layout's

I need to reactivate all the Deactivated user. I am using getdeactivatedusersby() function but am getting error. I have used this code:  getdeactivatedusersby("email","@",2).    but am getting error: "Expression evaluation error at function 'getdeactivatedusersby': Null argument not allowed"  Can someone help what mistake am making.

Hi, I'm trying to use GCP "Cloud Identity" as my IDp LDAP Server. in order to establish the trust b/w LDAP Client(Appian Application) and LDAP Server(GCP Cloud Identity), GCP instructs to upload the SSL certificate to client application. Unfortunately, I could not find the place to upload security certificate on Admin Console -> LDAP Authentication Screen.  Could someone please suggest the recommended approach here? Does anyone successfully using this LDAP authentication with external cloud based active directory please?  Cloud Identity LDAP Client configuration screen, Appian Application Admin Console LDAP Authentication Configuration, (Example)   

Hi, I am trying one interface where I can upload a Photo and want to view the same in a Box(Preview). Could someone please me here please? Thanks Faisal

Hi, I am using the rule APN_getSiteUrl, to get the environment specified URL.  But when user places cursor on the link that received in the mail, is showing original url as DEV instead of TEST.   Can any one help on this? In Dev: In TEST: But in email : 

Hi, Is there a way to retrieve the 'Requested By' userId in a post deployment process? It looks like the a!deployment() function currently does not retrieved details like requestedBy, reviewedOn, etc.,  Although the documentation contains an example: deployment(101, "reviewedDate") returns 12/21/05 2:28 PM GMTI get an error: Expression evaluation error at function a!deployment: The requested property “reviewedDate” is not available. Regards, Sunil Zacharia

I need to send and receive mails in appian 21 version. But I have not configured anything yet. Can someone tell me how to configure mails in appian ?

Is there a way to get a list of all possible outputs a decision table can output? A = apple B = bannana C = cat What if I want {apple,bannan, cat}? What if I want {A, B, C} ?

Hi,I have a question regarding accessibility of an updated CDT in active instances of Parent Process (PM1) which exists prior to deployment. Scenario: I have a CDT which has 3 new columns. My process models flow is as below:Process Model (PM1) --> Subprocess (PM2) --> Subprocess (PM3)All the above processes has process variable of this CDT, where it is passed from parent to its subprocesses (not as a reference).Data for new fields are set in subprocesses. I am wondering that even if I succeed in updating the CDT PV in subprocesses, will it still be available in parent PM1 which handles the "Write to DB" of this CDT.I am assuming the old instance of CDT must be running (myCDT^1) and hence might not be having these fields. Please suggest if I am correct. Note: PM1 will the first process, and the call to subprocess will have have updated CDT but the parent still remains with old CDT is my concern. Please suggest how to tackle this situation.

Hi All,      if am not wrong, the Document Expiration was available till Appian 18.1, later i dont see any option on the same, is there any way, we can set an Expiration and delete the douments. Warm Regards Vineeth

We have several Process Model that have nodes for user tasks.  A lot of these nodes need to terminate based on a couple of decisions.  The first being a timer (that is configured to skip this node when the timer expires) and the second being a rule such as "and(not(pv!isManageSubmit),pv!isUnlock)".  We are seeing a lot of orphaned processes that never complete and most seem to be stuck on a node with this type of a configuration.  In one process we were able to put the rule before the node in an XOR and just have the timer for the exception and it works great.  Has anyone else experienced this situation?  Is this a bad practice? Thanks in advance for any information someone can share.