Discussion Categories

Hi folks, I want to know if Appian has got an anonymous reporting features(whistelblowing) by the user of an application/site, like this one in the link: Compliance & Government Affairs Hotline Solutions - Life Sciences | Appian. I don't find anything unfortunately, not in the documentation neither in the support section. Does anybody has some idea? Thanks in advance

The expression rule below should return a list of dictionary containing loanAmount and monthlyPrincipal. It gives me a strange Expression evaluation error : with no specific errors. If I change ri!loanAmount <= 0, to be ri!loanAmount <= 28824, it works for some reason. Not sure why and not sure what's going on. This rule has a rule input called ri!loanAmount of type number(decimal) which I am testing with 100000 as a test scenario to make this work.  Any ideas what's going on? If there are any other ways to get this to work without doing recursion, please let me know. a!localVariables( local!principalPayment: 100000, local!interest: 15, local!loanTermYears: 30, local!periodicInterestRate: (local!interest/100)/12, local!periodicInterestRateModified: 1+local!periodicInterestRate, local!periodicInterestRateModifiedToPower: power(local!periodicInterestRateModified, local!loanTermYears*12), local!xx: local!periodicInterestRateModifiedT

Hello, Is there any way we can automate the plugin discrepancy problem across all env (DEV< SIT< UAT< PROD) ? we are facing issues while release time, get to know that plugin version is different in Production env as compared to UAT. This is causing delay in release. i want to create an automated utility which get plugins data from Production env and compare UAT and PROD plugin, warns beforehand about all the discrepancies. or can we set privileges to certain developers for plugin upgrade in lower env. So that every developer can not update plugin in lower environment. 

Hi, I have link as below . To make it more noticeable to the user I would like to add a border to it and make it look like a button. I tried to use cardlayout but it is displaying like in 2nd image. Can someone help me how to display border just order the richtext link, not the entire row. a!cardLayout( contents: a!richTextDisplayField( value: a!richTextItem( text: "Add Meeting Minutes", link: { a!startProcessLink( processModel: cons!RGRACSLBL_PROCESS_LEAD_LAST_APPROVAL, processParameters: { requestId: ri!requestId, labelChangeCountryId: ri!labelChangeCountryId_int, fromHQ: if( local!requestDetails.workflowType_txt = cons!RGRACSLBL_LabelUpdate_WorkflowType[1], true(), false() ), labelChangeRequest: cast( typeof(

HII  i am getting this error - Expression evaluation error [evaluation ID = NYEY6] in rule 'gai_displaybatchrecordsummary' at function a!gridField [line 59]: Cannot update Map using null index (APNX-1-4522-005) How can i resolve this  i have added my code a!gridField( showWhen: a!isNotNullOrEmpty( ri!record['recordType!{43099841-b468-444e-97af-bc369b79a6fc}GAI Batch.fields.{c835857e-c9ec-40d4-a818-f2d8593b1100}batchNumber'] ), label: "Batch Details Grid", labelPosition: "COLLAPSED", data: a!recordData( recordType: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail.relationships.{3cd6a92f-954f-48e2-

Hi All, I have a query in export dse to excel. How many characters or word count can be exported in one column of excel? Thanks!

I have a requirement where based on condition I need to fetch the table name so am storing it in Data Store Entity Type. Am able to fetch the value, but I need to convert this to table name. Can some one help how to convert it. Do help with code or if we have any function Eg: Am getting value in Process Model in Pv!table: 473c45d0-5c99-4665-a335-f772838ccb37@2232 but I need to display exact table name. Note: table is of type Data Store Entity

Hello, I have stored different values of a grid in my local variable local!DatosLineas (read-only fields which result on querying another record  + extra column which must be completed by the user).  I want to "write" some of the fields of my local variable in another record fields. For example, the id_pedido of my local variable (which has been created by querying another record, "CPF_Lineas_Pedido") would be the id_Pedido in my other record ("CPF_Lineas_Recepciones") In this case, I don´t know how to match the fields and write my new record with the data of my local variable. I have to point that the INFO SHOWN IN THE VALUE OF EACH FIELD CORRESPONDS TO THE PREVIOUS RECORD (CPF_Lineas_Pedido), but I want to save the values in a NEW RECORD (CPF_Lineas_Recepciones) My code is below: a!localVariables( /*mirar para incluir columna extra en variable local*/ local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-42

We are getting an error on PROD saying "Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator". Checked the failed sync reason and it says "Unable to sync due to system failure".  And Event type for this error is "Write To source". This happened only on one particular day (17th September) and there is no error before or after that day.  We debugged and did not find any exact reason why it happened. The only reason we can see that there was some activity happened on DB side on that day and one of our scheduler Process in Appian runs everyday which updates the data in DB in batching of 65 rows so due to which this error might came. Can anyone please suggest on which logs we can refer to look out for root cause of this failure and find that this issue happened cause of some DB connection or any other reason. In tomcat-stdout.log also did not fou

I'm trying what should be a very simple task ... and I can't get it working!  I've created a Related Action to update a record - just used the automatic creation tool that built me an interface and a process.  In my user interface, if I include the related actions dropdown on the record view, this update works perfectly. The interface shows all the fields and allows me to update and hit Save. Perfect. But now instead of using that interface from the related action dropdown, i'd like to place it in a view so that it shows as a toolbar menu item across the top toolbar. But now, when I hit Save on that interface, nothing happens. It's like it's not calling the process at all.  Here's my related action and my view - what am I missing?

I have record type that get its source from data store entity and it has default filter and other user filters how can i query the same data using expression rule ? for example we have fields in the data store entity      startedBy , status , location , department  , empId , addedOn and the rule inputs for the expression rule are searchText , selectedLocation and createdOn this is the default filter  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field:"status", operator: "=", value: 2, applywhen: a!isUserMemberOfGroup(loggedInUser(), cons!SP_MANAGER_GROUP) ), a!queryFilter( field: "startedBy", operator: "=", value: loggedInUser() ) } ) and this is the user filters that i want to use (this for user search )  logicalExpressions:  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "empId", operator: "=", value:tointeger(ri!s

"An error occurred while retrieving the data. Details: The data source [jdbc/Appian] cannot be reached or its configuration is invalid. Details: could not extract ResultSet" I keep encountering this error while trying to add some filters to the data retrieved from a query entity. The query runs fine and retrieves all the data, however, when I go to add some dynamic filters to this data I keep encountering this error. I am reaching out to see if anyone from the community has come across the same error and what solution worked for them. Basically trying to add a few specific data filters to a search bar in the application. Any suggestions are welcome. Thank you

I'm using the connected onboarding solution for a demo and there are a bunch of really old tasks showing up in the My Tasks and Group Tasks view.  I thought if I cancelled the onboarding, it would clear out related tasks, but it didn't.  Now i'm stuck with a bunch of orphan tasks in the user interface which makes for a pretty messy demo.  How can I safely get rid of old tasks from the UI?

I have a local variable that holds an array. When I pass this local variable to a a!forEach items, it does not loop. When I take the array value and paste it directly into items, it works. Why is it not working when I pass in the array from the local variable? a!localVariables( local!groups: { cons!AX_ALL_USERS, cons!AX_MECHANICS, cons!AX_REGISTRARS, cons!AX_SUPERVISORS, cons!AX_ADMINISTRATORS_POINTER }, { a!sectionLayout( label: "Groups for " & loggedInUser(), contents: { a!gridField( label: "", labelPosition: "ABOVE", data: todatasubset(a!forEach( /* WORKS */ items: { cons!AX_ALL_USERS, cons!AX_MECHANICS, cons!AX_REGISTRARS, cons!AX_SUPERVISORS, cons!AX_ADMINISTRATORS_POINTER }, /* DOES NOT WORK */ /*items: local!groups,*/ expression: { {

Our Appian DB has setup for Enhanced Data Pipeline, follow the guide.We have a Python app that run through airflow to query data with a service account, and trying connect to Appian Dev Cloud Database. We're debugging right now on the connection and got this errorpymysql.err.OperationalError:(1045, "Access Denied for user 'appianViewer'@xx.xxx.xx.xxx' (using password: ***)") Is there anyway to connect to the dev DB through local machine to debug on the python library issue?

Hi Team, I would like to remove total words from a sentence, Below is the sentence Are the machines property stickered(external communication) I need to remove(external communication) from the above one, Strip with or clean with cant be used because it will remove other letters also Any suggestions ? Thanks

Hi, Does anyone know how to convert a document stored in appian to an url? to use it as a dynamic link in a json. Thanks!

Hello All, Could you please help us to redirect the URL using Appian webapi.  Below is the sample code I used . Now the URL is displayed in the body because i mentioned in the body. I tried to mentioned in headers  but nothing happened. Also i didn't see any keywords apart from body,statuscode,headers in a!httpResponse. Requirement is to download the documents using URL .(documents URL's are dynamic so we are trying to use redirect here). a!httpResponse( status Code: 302, body: {rule!example(fileName:concat( "537","Customer " "454", ".pdf" ))}, headers: {},),

Hello Everyone, does anyone have experience with test automation in Playwright? Dou you know if it is possible to use Appian Selenium API within Playwright? If yes, could you provide some config details? Thank you in advance, Chris

Hi all, We're currently working with the AVM and AIM plugins together with a deployment pipeline in order to automate our deployments. We are trying to make use of AVM for pushing our appian code to bitbucket.Anyone can suggest where we should configure AVM for that and how we can execute the script. We have configured AVM in /data-01/appian/AVM path, but while executing .sh script we are getting error saying  Linux prompt: version-application.sh -action addContents -vc_username <abc123> -vc_password <******* >-application_path <"Windows Sysytem path" >-commit_message “Adding account test record” Error: Could not find or load main class com.appiancorp.ps.automatedversioning.AutomatedVersioningManagerLinux prompt$: Thank you. Harikrishnan

Process Report showing an error "The per-resource  time limit for generating this report has been exceeded" Please review the report performance details for guidance on tuning the report

Hi is there any way to input this type of sticky pad into appian interface and the save the written values to the database without the use of process model.

Hi Could anyone help me to know how can i access the below "backup" Schema in appian cdt/record , whenever I create cdt/ record type I can only see tables from "Appian" schema, cannot access "Backup" Schema

Is it possible to build a process report that shows me all processes (and id's) that are showing as error ? i can use the existing report that lives under Perf Monitor to view how many instances have errors - but I want to build a house keeping task that will go back and cancel these cases and for that I need to get the process id's for a named procedure. (date filtered) Alternatively how much impact is there when deleting process instances in bulk.