Discussion Categories

I need to show only top 5 most visited places for a month but i am stucked at this point. below mentioned is the code that i used to work out till now: { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType

Hello All,  I am seeing below error when I am querying data from database. in the database nonInvoicePayments is defined as Tinyint(4) and in the rule input for this variable is defined as Boolean.   Please suggest me the solution. Error message: expression evaluation error at function a!queryEntity [line 3]: Cannot apply operator [EQUALS] to field [nonInvoicePayments] when comparing to value [TypedValue[it=26,v=1]]. Thanks in advance.

Hello, I have forgot my username for deveoper portal and unable to login. Could you please help in resetting my username and password? My email is: swathik0312@gmail.com

hii all, i have a requirement to store a request in draft , usually if i filled a form and given submit then only one request id will generate , before submit the form i want to save the form in draft mode , how would i achieve this please help me im new to appian. thanks in advance  b ramesh

How do I go about saving a file?I have the followingWhat do I need in the process model?I would have thought that this would automatically come when I press the submit button just like any other input.Is there any documentation on how to save this?I found this https://docs.appian.com/suite/help/22.4/File_Upload_Component.html, but it does not explain what you need in your process model or how to set up your database table(s)/field(s).

Hi, I have a rule input with multiple rows of data and I also have a local variable with few rows of data. Now I want to find the difference rows of data into a another local variable. Is it possible in appian.  Any inputs please.

Can we have regexmatch code for this scenario : I have   4 digits in text format but last  2 digits should be fixed EX:"XX30" here "30" is fixed "XX" can be any numbers in text format

Hi, Any idea how to find the third largest value using a!queryentity?

Team, We have a start process which gets data from third party and process is scheduled to execute in every 5 minutes. If Appian is down during that period , we observed that when Appian comes online it start n numbers of same process for the time it was down. So let say Appian was down for 25 minutes , once appian comes online we see 5 process instances are getting triggered for the same process and leads to data duplication. We want to make sure that at any time only one process executing and not multiple. We thought of using timer to wait next to start process and assign random seconds to each instance but that fails if instances are more 25. Any other solution?

I have completed Appian Developer Course, how can I improve my skills as an Appian Developer. Which course or other thing I can do now to achieve my goal ?

Hi All, i want to replicate the below section in another interface manually.  Which SAIL component can i use? 

I have a question regarding the visibility of UIT in tasks. I have tried assigning the task using process variable, individual users and also through groups. All the users and groups are part of the application and have viewer permissions. Also, I made sure to run multiple instances(one for each assignee). All the assignees are receiving the tasks but when they open it, they get a blank interface. But the same task, when opened by me is working fine.   I tried the troubleshooting mentioned in the documentation: https://docs.appian.com/suite/help/22.4/Testing_and_Debugging_Problems_with_Process_Models.html and nothing worked. The user input task in not been configured as quick task and the assigned users are part of the application and has basic user permissions(viewer). (I am new to Appian. I hope I was doing it correctly. Any help is appreciated.) Thank You. 

So I have a read-only grid displayed on a site through an interface. The summary is also displayed through an interface, and the summary of a record is pictured below. What I want to do is add a button, going to the next or previous record so that the user doesn't have to click the home button in the top-left. I found this thread but wasn't sure how to apply it to my situation (not completely sure how to apply a!query): community.appian.com/.../access-to-previous-and-next-records

I want to do this get value from multiple select as newRefs;insert into table1 ('name') values ('pete');SELECT LAST_INSERT_ID() as newUserId;for each (currentRef in newRef) {     insert into lookupTable1 (userId,ref) values (newUserId,currentRef);} Actually there is a quicker way to do this with MySQL/MariaDB as noted here https://dev.mysql.com/doc/refman/8.0/en/insert.html What do I need to do this?Do I use Data Store Entities, Record Types, etc.?I can't be the first one that want to do something like this.

Hi  Expression i used is: if(todate(ri!vehicle.vehicleNextMaintenanceDate) <todate(ri!vehicle.vehicleLastMaintenanceDate), “The nextmaintenance date must be after the last maintenance date.”,null) Below message is the error i got while working on interface. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'if' [line 59]: Invalid number of parameters, function 'if' a minimum of 3 parameters (condition,true,false), passed 1.

Hi All, I scheduled my L1 certification on a wrong time zone (Indiana) by mistake where as I live in India which follows IST. I was blocked from taking the exam since the Indian Standard Time(IST) is 10 hours and 30 minutes ahead of Indiana. Is there anything I could do to retake the same exam or Is there any other alternative for the same? Thanks in Advance!

I am facing an issue with my RPA code. I have automated a process for data entry into an internal database, but it seems that the bots are not able to handle exceptions or errors that may occur during the process. This is causing the automation to fail and manual intervention is required, defeating the purpose of using RPA in the first place. I read this article to get more understanding and tried debugging the code, but I am not able to identify the root cause of the issue. Here's a sample of the code that's causing the problem: bot.click("submit_button") result = bot.get_text("status_message") if result == "Success": bot.click("continue_button") else: # What should I do here to handle exceptions or errors? ```"

Good morning everyone I am trying to filter the day from a recordtype that has the whole date time in the db. When I put this expression in it shows 3/19/2014 800pm edt. I just need it to show the day. How do I accomplish that? contents: { a!richTextDisplayField( value: a!richTextItem( text: fv!item [rcordtype], color: local!textcolor, size: "MEDIUM_PLUS" ) ) },

I have a requirement to access the database in Appian Community Edition from the Appian Cloud Edition. Can you list out the steps that I need to follow for this?

Hi, I have an interface where I am loading the data in a read only grid using a recordType and also I have a "ADD" button to provide a new item to add. Now, when the user is trying to save a text fields data, I would like to compare text fields data with a recordType fields/columns.. Can someone advise on how to compare user enter data in a text field with a recordType or Read only grid column. If user is trying to enter same data, I would like to return a validation message. Thanks.

how can i sort an Array?

Hi Team, I am trying to convert html code in my email template to dynamic so i can loop some values using expression rule but i facing some issue in syntax , Looking for the help below is the html code <!DOCTYPE html><html><body><head> <link rel="stylesheet" href="styles.css"></head> <h2>###bodytext###</h2> <br><br><h2>Please click on any below link to submit you response</h2> <a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Complete</a><br></br><a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Cancel</a> <br><br&g

Hi All, When trying to import the Appian IDP package into our environment we are having issues, where numerous process models are said to not be valid. The environment is on 22.2 and we are installing v1.8 of IDP. The errors in the import log are below: Any suggestions as to what could be wrong would be great. Thanks!

Hello All,  how to print this pattern * * * * * * * * * * * * * * *

Hi team,  I am learning IDP (https://academy.appian.com/#/online-courses/7efa16db-521d-4d4d-9eda-f7114869b548) and at the document : IDP Add New Document Channel Exercise. I am trying to build it on my Appian Community account. I am able to Add the channel (page 6) - "Finance" but when I move to page 8 trying to see the Groups created - they aren't. Looks like this is not happening   I got 4 emails with the following error I tried seeing a bit more into the process model that is failing This was created back in Jul-2021 by community-admin. I am not sure where's the issue or don't want to play around. Can someone from Appian team fix this please. thanks jaideep