Discussion Categories

There are "System Groups"   in Appian and General groups(All Users, Administrators )  which we create for security purpose .  Just wanted to understand on which scenario we can go for each of them . Is there any real time difference .

I have a scenario where I use exportEntityToExcel smart service to export a VIEW data (script below) in an excel file. There is one filed which has datatime (CREATED_ON) in it. I want to display/export to excel the timezone along with datetime in this field. Existing Format: 11/27/23 02:43  Expected Format: 11/27/23 02:43 AM/PM PST/CST/MST/EST  .CREATE VIEW `DUMMY_VW` AS SELECT `b`.`CITY` AS `CITY`, `i`.`CREATED_ON` AS `CREATED_ON`, `i`.`CREATED_MONTH` AS `CREATED_MONTH`, `i`.`CREATED_YEAR` AS `CREATED_YEAR`, FROM (`DUMMY_STATUS` `i` left join `DUMMY_PROFILE` `b` on(`i`.`ID` = `b`.`D_ID`)) ;

We have use case where currently we are sharing the document to external system via Appian Web API ( created through existing Appian API document download template ). External system is requesting to share the data as base64 string. We could achieve same via plugin available in App Market  ( [mention:e7b082a6b98049899e3541011e57f30e:f7d226abd59f475c9d224a79e3f0ec07] ). I wanted to confirm what are the advantages and disadvantages of sharing document via base64 string over existing approach. If anyone used base64 string encoded method to share document, can you share the advantages, and disadvantages over the approach. 

We have tried implementing google reCaptcha in our portal,The google recaptcha connection is successful,We have used verifyRecaptcha and tested , it doesn't tally with the scores which we provide in the conditions on success or error,   We tried to find the score value by creating a table and writing the fv!score to the db through start process on success of verifyRecaptcha.   Is there any way to find the score values, Could anyone help to get the recaptcha working in appian portal

How to list all the members of a group and store them to a local variable to show them in a grid also select multiple members to delete and add the members, using groupmember function?

Hi  I need advice. Read CSV file and want to find duplicate value. if there are duplicate values .I want to display error msg.. I was able to load the CSV and remap it to the map list, but I was unable to check for duplicates values and unable to add error msg. Image like the attached image

Hello, I have editable grid where I'm trying to save all the selections in rule input after that I will use the rule input to push the data to database. The problem is that I'm not able to save the multi drop down as an array when I select more then one option it save only one and not all in the rule input. Full code below: rows: a!forEach( items: ri!AOS_Documents_Required, expression: a!gridRowLayout( id: fv!index, contents: { a!dropdownField( choiceLabels: {"Option 1", "Option 2", "Option 3", "Option 4", "Option 5", "Option 6", "Option 7", "Option 8", "Option 9", "Option 10", "Option 11", "Option 12"}, choiceValues: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12},

I want to implement single sign on in appian using saml authentication so in implementaing , we have to provide webaddress identifier and service provider meta ,what kind of data that we have to provide service provider metadata?  we are refering this url : SAML for Single Sign-On - Appian 24.1

I am getting this error "type (Data Inputs) " in send E-mail smart service, How can i solve this one? i am getting this error when i use record type process variable in this smart service, otherwise it is working fine.

Hello everyone, I'm looking to archive process instances that are currently active, paused, or paused due to an exception. We've already configured process instance archival after 5 days with deletion after 3 days, but we now have over 10,000 process instances in these states that we want to archive instead of deleting, as we may need them in the future. Is there a script or another method we can use to archive these instances? Thanks, Manish

Code: a!forEach(pv!addedResearchItems_cdt, if(and(rule!APN_isBlank(index(fv!item,"id",{})),rule!APN_isBlank(fv!item.url)),cast('type!{urn:com:appian:types:gngp}GNGP_RESEARCH_ITEM',updatecdt(fv!item,{file_name:if(not(isnull(fv!item.file_name)),fv!item.file_name,if(not(isnull(fv!item.document_id)),document(todocument(fv!item.document_id), "name") & "." & document(todocument(fv!item.document_id), "extension"),{})   )})),   fv!item)) Getting below error: (Expression evaluation error at function a!forEach: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'updatecdt' [line 5]: Length of input arrays must equal length of CDT/Dictionary array) (Data Outputs) Please help to rectify the above error as what code changes needs to be done

Hi, I'm trying to update the DB whenever there is an user interaction in the record action but it is creating new row instead of updating the existing one. Please let me now if I'm missing something to configure. Below are screenshots of the Write record 

i got this error where i used remove() but i tried remove(null, index) will return null instead of error, so what could cause this error?

User not able to see write up in ipad  as shown below  But able to see write up in laptop as shown below Can someone please help on what needs to be done here or how to resolve

The "user" parameter has a value that does not exist, has been deleted, or you do not have sufficient privileges to access its data .  I am using record events and tracked the changes in the history table which are auto created in the events   ,  As an admin i can able to view the data , whereas normal users are getting this week , i have check all the records type user records they are having viewer permission  Please let me know what could be the problem 

Hi, I have a requirement to download the grid data along with the documents in to excel. I have seen there is a plugin  Embed Image into Excel  but, i dont see any success stories on it and it is not updated recently. Can someone suggest the way on this. THanks Soujanya

Hello everyone, i am trying to upgrade from 20.4 to 22.1. All the services start normally, but on tomcat log, i get the following :  Using CATALINA_BASE: "C:\appian\tomcat\apache-tomcat"Using CATALINA_HOME: "C:\appian\tomcat\apache-tomcat"Using CATALINA_TMPDIR: "C:\appian\tomcat\apache-tomcat\temp"Using JRE_HOME: "C:\Appian\java"Using CLASSPATH: "C:\appian\tomcat\apache-tomcat\bin\bootstrap.jar;C:\appian\tomcat\apache-tomcat\bin\tomcat-juli.jar"Using CATALINA_OPTS: " -Dfile.encoding=UTF-8 -Duser.timezone=GMT -Djava.naming.factory.initial=com.appiancorp.tomcat.naming.TomcatInitialContextFactory -Djava.awt.headless=true -Djava.net.preferIPv4Stack=true -Dorg.osgi.framework.security=osgi -Dsun.net.inetaddr.ttl=60 -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dtomcat.cacheArchiveEntries=true -Dio.opentracing.contrib.jdbc.excludeFastQueryThresholdMs=100 -Dio.opentracing.contrib.jdbc.slowQueryThres

So when the user selects a particular interface, a document is generated and if the user selects the 'cancel' button then the document is deleted. There are cases where the document might get deleted through another form so if you try to select the cancel button, then an error message appears. Right now this is the idea for the process model but its not fixing the issue so please let me know if you see anything that might fix the issue. the 3PI exchange node generates the document, then the XOR node checks to see if the pv!download_doc is null or not and if it is, then move to the end event, if not then to delete the document and end the event. I tried a few other options for the XOR node but this is basically as far as I know what to do?

Hello,  I'm using excel plugin tools and i can read excel databut i don't need null of row so i want to delete null row.I tried to loop list of text string but cannot get it.How can i convert list of text string to list. here is my test rest of screen shot here is my excel data image

Hi Folks, I am using Appian AI Skill to extract the data from a pdf document. I uploaded multiple documents in the same batch and some of the documents are failing and giving the below-mentioned error.  Did anyone face the same issue or any insights into it? Your help is much appreciated.

Hi All,  i want remove the tooltip message for both record action and related action ,is this possible? i too tried by removing the description ,still i getting the tooltip contains display name.But i need display name for record action button. Any help in this regard is highly appreciated.  Thanks!

Hi all, User complains he is not able to see the application content on ipad but able to see in the laptop. Can anyone help on this

Hi Team, I have a Text Box and Button beside that text box, when I enter anything in the text box and hit on "ENTER" button on keyboard I want the Button to submit the data. Is it possible in Appian ? Thanks  Bihitak

Let me explain  I want to get to see the summary view of a user but with all the related action bar that appears up top  of the summary view  interface I'm being  able to redirect to the interface of the summary  but i can't see the things that  i see  when Im  on the record type with all the the actions . i hope any of  you guys could help me  or tell me if this is possible or not thanks  

Use case is that we have to remove the selected multiple users from multiple groups. The issue is when I select one user then the entire row is selected of groups listed users. I want to select the users in multiple from the selected group. a!localVariables( local!selectionValue: {}, local!selectedGroup: ri!initialGroup, local!actionTaken: if( isnull(ri!btnAction), false, or(ri!btnAction = "ADD", ri!btnAction = "MOVE") ), local!distinctUsers: if( a!isNullOrEmpty(local!selectedGroup), "Please select a group", a!flatten( a!forEach( items: local!selectedGroup, expression: a!localVariables( local!group: fv!item, a!forEach( items: getdistinctusers({ fv!item }), expression: a!map( id: fv!index, Group: local!group, Members: fv!item ) ) ) ) ) ), local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10),