-
Recently active
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 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),
Hii, I am trying to concat multiple strings a!localVariables( local!data:{ a!map(id:1,visitorId:11,name:"John",comment:"hii john"), a!map(id:2,visitorId:12,name:"Jacob",comment:"hii jacob"), a!map(id:3,visitorId:13,name:"David",comment:"hii david"), a!map(id:2,visitorId:14,name:"Bobby",comment:"hii bobby"), a!map(id:3,visitorId:15,name:"Mark",comment:"hii mark"), }, local!distinctIds:{1,2,3}, a!forEach( local!distinctIds, { Id:fv!item, comment:concat(index(local!data,where(index(local!data,"id",null)=fv!item),"name",null)," - ",index(local!data,where(index(local!data,"id",null)=fv!item),"comment",null)) } )) Above code gives me the output as: Id: 1 comment: "John - hii john" Id: 2 comment: "JacobBobby - hii jacobhii bobby" Id: 3 comment: "DavidMark - hii davidhii mark" But I
Hi. I was setting up some save functionality for the one spot in my code that saves to a particular variable. I had a rule that outputs null under certain conditions, but kept watching it show up as {null} instead. I have tried to simplify the issue and have found saving into the localvariable something like {"Apple", "Banana"} results in straight null instead. What is happening in my interface? If i save the same value to a random debug variable it works fine.
Hi All I have a requirement where I have to query the data from database for a particular column of type varchar(max) which has data more than 1 MB . While fetching the data from query entity, I am getting memory threshold error. Please recommend me some way of how can we fetch more than 1 mb data. Many thanks in Advance!
Hi All, I'm not having the desired result when using proper() with words including special characters. We receive the error when the user's name has special characters. EXP) O'Neal is being saved as O'neal, Aube-Kubel as Aube-kubel, etc. I need to implement a rule for capitalizing letters after special characters, but not sure how to proceed. Any assistance is appreciated, thanks!
Hi Experts, Need your help in the following issue: I have created one view that is getting data from a table in a DB. Then I created the CDT for the same from that DB and then the DS is also verified and published with no error. But on retrieving the data from a DB rom a query entity I am getting the following error: Using the Record Type also I am getting the following error while viewing the Record list, We have only 194 records in that view: Please help me to identify the cause of the error.
Hi Folks! I have a scenario here which seems impossible to solve. We have an excel template where column A has formula that increments row number if we add data in column B. This excel is used as template in Appian where we are querying a view and dumping the data in this excel. When we tried doing this, the formula is overridden by the values from the view. So the formula doesn't work anymore if we add more rows in the excel. If we keep column A blank while generating template from Appian, we need to update something explicitly in column B for the values in column A to auto-populate. We don't want to use VBA code as well since macros are disabled by default. Is there any way that the formula could work even if we dump data in column A from Appian, any plugin or configurations we could do in Appian or anything on excel side? We want to avoid the situation where we are keeping column A blank just for the formula to work or manually enter values in column A on every row
I have one requiremnt where i need to just convert the raw data into respective CDT. Is it possible to convert into the CDT without expression data. I have used cast but it is not worthy to be work. If same case is used for this using expression then it is working [RecordID=4, CatalogID=, ScopeID=6, VendorID=, InHouseTechnicianID=, WORemediationID=, BidID=, Category=, Description=, GLCode=, GLSeg=, IsExterior=false, LineItemApproval=, MatCost=, Pass=, Price=0, Quantity=1, UnitOfMeasure=, ResidentResponsible=1, Room=, SubCategory=, Summary=, TechCost=, TechTime=, OriginalPrice=, VendorPrice=, Modified=, Deleted=false, CreateUser=henryfok, CreateDate=2/15/2018 12:00 AM UTC, UpdateUser=henryfok, UpdateDate=2/15/2018 12:00 AM UTC]
Hi Team, Is there any way to open Modal pop up window in Appian , our requirement is to open chat bot like popup on the right hand side of the page when user clicks on button. The Record Relation way I have already tried and its opening on the entire page as popup, and also have tried the show hide way of showing interface. besides these two ways is there any other way of showing popup window in Appian for chat bot. Thanks Bihitak
Hi Team,[Deprecated] Export SQL to Excel smart service is failing in our DEV environment Appian version 23.2. Geeting below mentioned error:"The following error was raised by the Export to Excel function: null"Same smart service is working in another DEV environment of same version.Please do the needful on this issue. Regards,Sandeep
Do you any of you guys know how to add a button in an interface with the function of converting a query or a record type to an excel and downloading the converted excel in a push of that button without needing a grid and its built in export function?
How to get all records using a!queryRecordType() since batch size -1 is not applicable here therefor any hard coding the batch size might fail in some scenarios. Help will be appreciated..
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.