Discussion Categories

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. 

When applying an edit action to a dropdown field. Due to the lack of an enumeration data type, the dropdown field may inadvertently transform into a text field when an edit action is applied.

a!gridField( data:local!data, columns: { a!gridColumn( label: index(local!labels, "id", null), sortField: "id", value: fv!row.id ), a!gridColumn( label: index(local!labels, "createdBy", null), sortField: "createdBy", value: fv!row.createdBy ), }, pagingSaveInto: local!pagingInfo, selectable: true, selectionValue: ri!idDoc, selectionSaveInto: ri!idDoc )

if(a!isNullOrEmpty(fv!row['recordType!AX Vehicle.fields.image']) ,a!EXAMPLE_DOCUMENT_IMAGE(), fv!row['recordType!AX Vehicle.fields.image']) Hello AppiansI am new to Appian and following the Appian developer learning path I faced an error in "write a maintenance record" of the process model, tried to solve it but in the end, I deleted the project and started a new one and now I am facing this error "Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 51]: Invalid Content ID" this error shows up once I add a new Document Image column in the list of the vehicle record type and for some reason, the Acme Auto Solution Application already built has the same error So I guess the problem is not from the expression or the record

Hello everyone I have a requirement to remove the decimal point in the value. For example 15.50 into 1550. Is it possible? 

Having an issue while creating a Robot for windows, what will be the JRE Path (%JAVA_HOME%).

Hi All, I am getting this error while adding new column record the table. #1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTION ON UPDATE NO ) Could you please let me know how can we resolve this, 

Hi all, I'm trying to see what is the best way to check if a record already exists in the DB, specifically in a relationship table. I have 3 tables: manager, employess, managers_employess_relationship each manager can have multiple employees. Manager table : ID Name 1   Juan Employees Table ID Name 4   Liza 5  Emily managers_employess_relationship table ( has the foreign keys from both tables) ID   Manager_Id    Employee_Id 1         1                        4 2          1                        5 when a manager is adding its employees in a form what is the best way to check if its adding an already assigned employee, for example if manager juan tried to add Liza again, I want to make sure it gives him some type of validation saying that liza is already assigned to hi

Hello. I built some process flow logic that's checks if a value isn't null and then performs an action. The value is for a property of a CDT processVariable: Ex: if(  a!isNotNullOrEmpty(pv!requestItem.field),  do something, do nothing) I came across an issue where the flow was performing the action when the value is null (value is verified) I'm debugging in an expression rule and can replicate the issue when the query returns a Dictionary list, and I get the intended behavior when using data[1]. The issue makes sense here since the null checks were originally against the list. However, the process variable isn't a list, its a single entity ("Multiple? is No and verified). So I'm not sure why the behavior is happening. Has anyone experienced this and found a solution?

Hi Readers, I have two tables Table-A with columns:- ID_A, Job_Role, Company_NameTable-B with columns:- Member_ID, Name, PhoneNumber, ID_A which are related as one to many relations I have created record type for different these tables and added relation ships in the record type as well, Would like to know can we consolidate them as below requirement rows which i want to display are  Member_ID Job_Role Company_Name Name Phone_Number 1 DBA ABC.ltd SSR 1234567890 2 DBA ABC.ltd RC 0987654321 3 SysAdmin ABC.ltd NTR 6789054321 4 SysAdmin ABC.ltd RRR 1234567098 5 HR ABC.ltd MB 0984562348 Below are the tables structure Table-A is as below ID_A(PK) Job_Role Company_Name 1 DBA ABC.ltd 2 SysAdmin ABC.ltd 3 HR ABC.ltd Table - B is as below Member_ID Name Phone_Number ID_A(FK) 1 SSR 1234567890 1 2 RC 0987654321 1 3 NTR 6789054321 2 4 RRR 1234567098 2 5 MB 0984562348 3