Process Automation

Hello, I'm reading a record that contains a text field I'd like to have listed in an array. However, the array should only have unique values, so if that text is already in there, I don't need to add it again. I've written this.  a!localVariables( local!arrayOfMakes, a!forEach( items: a!queryRecordType( recordtype: recordType!KD VM Vehicle, fields: recordType!KD VM Vehicle.fields.make, pagingInfo: a!pagingInfo( startindex: 1, batchSize: 50) ).data[recordType!KD VM Vehicle.fields.make], expression: if( contains(local!arrayOfMakes, fv!item), null, append(local!arrayOfMakes, fv!item) ) ) ) It returns what I think I need, but it's not unique. Here's part of the output. Further down you would see that it has several entries for the same make.  All ideas are appreciated!

Hi All, In my  application, I have to use caladddays() function which calculates only the net work days and for daylight boundaries. So for 72 hours, I will use caladddays(ri!date,3) ,  it works fine.(where ri!date = 1st November 2021,10:00 AM) But the user wants to pass the 2nd parameter by constant and he wants to test for 1 hour by changing the constant value. If I use caladdhours,the outputs are different  from caladddays, PFA the below screenshots, If there is anyway to pass hours in caladddays function, can you please help me? Thanks in advance. Regards, Jansi J

Created below table in appian DB Create a CDT and a DataSet. Now I got struck while creating expression rule. Can someone help here. I want to bring id, Name from language table and show the data in a dropdownlist. choiceLabel with "Name" column data choiceValues with "id" column data.

Hello all, I was able to successfully generate, clean, and package the maven project following the steps here "https://docs.appian.com/suite/help/20.3/rpa-7.2/setup/maven-setup.html#create-the-maven-project" However, when I try to import the maven project into IDE I get the following errors Plugin execution not covered by lifecycle configuration: com.novayre.jidoka:jidoka-maven-plugin:7.11.0:generate-resources (execution: generate-resources, phase: generate-resources)  Plugin execution not covered by lifecycle configuration: com.novayre.jidoka:jidoka-maven-plugin:7.11.0:process-classes (execution: process-classes, phase: process-classes)  what could be the problem? 

Hi all I currently am playing around with a community site to test out RPA capabilities, see if it works and provide proof of concept. I downloaded the configurator and I am trying to play with the robot source code to see if we can achieve certain functionalities.  I completed all the steps in the configurator except the last part where they ask for a Console Repository and maven api key.  I can get the api key, but I can't get an url for the repository.  How can I get the url for the console repository for a community site?  Thank you, Saeed

a!localVariables( local!locationsList:rule!AT_getAddresses(addressId: null), -- getting an error at this line.{ a!sectionLayout( label: "Address", contents: { a!radioButtonField( label: "Radio Buttons", labelPosition: "COLLAPSED", choiceLabels: local!locationsList, choiceValues: local!locationsList, saveInto: {}, choiceLayout: "STACKED", validations: {} ) } )})

Hello,  I would need the result of this Expression Rule in cod_provincia show me only the code of the provincia to which the municipio belongs. However, it is returning all the codes from my provincias table.  What am I doing wrong? Thanks in advance. 

Greetings, Could some please explain to me how to configure the flows in a conditional action in RPA? It is not like a " Conditional Gates " in " Process Models " but I just wanna know to how to configure a conditional gate in Appian Rpa 

Hello! I am making a call to an integration to retrieve data that I am saving in a local variable. then I have another local variable with a parent cdt. And now I want to save my integration data in my son cdt. How can I cast my data to follow the format of my database and have in my child CDT a column of my parent CDT? I need to use whereContains? I am learner. Thanks !

Hello I am doing the Windows Automation Tutorial Calculator RPA tutorial. In the Get Product step, where we retrieve the value in the Result element in calculator, and store it in the Product process variable.  My bot freezes. It cannot find the Result element in the Calculator window. What can I do to fix this?  Thank you,

We are trying to extract text from an image and used the example provided in suggested answer on this question: https://community.appian.com/discussions/f/rpa/19189/how-to-use-ocr-s-in-appian-rpa-using-falcon/75140#75140 The image is being recognized correctly on screen using Falcon module but the bot is unable to extract the text from it. Could anyone please help with the type of image that we can use (Paragraph of text as image, single line text as image) and the different configuration that can be added which would help in successfully extracting text. Code that we are using: private String drawRectangle(IFalconImage imageFound) throws AWTException, InterruptedException { try { Path screenshot = Paths.get(server.getCurrentDir(), "screenshot.png"); ImageIO.write(server.getScreen(), "png", screenshot.toFile()); BufferedImage img = ImageIO.read(screenshot.toFile()); Point p = imageFound.getPointsWhereFound().get(0); Rectangle rectanguloCif = new

Greetings, Can anyone please tell me how to get the exact coordinates of the mouse on a particular location? I am actually trying the drag method and I am giving the start and end coordinates but i am unable to get the exact dimensions to mention to the cursor.  so I am kindly requesting anyone to let me know how to get the coordinates. Thanks and Regards

Hi team, i have an expression rule to get the doctors with count of patients assigned to them with the disease but i want to get the  total patience count for that particular doctor with array of disease like eg: swift:3:{cance,Gallstones,Emotional Disorder}, Please help me to achieve this format substitute(substitute(substitute(substitute( substitute( substitute( a!queryEntity( entity: cons!PO_MEDICALINFO, query: a!query( logicalexpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "reasonForVisit", operator: "in", value:ri!reasonForVisit ), a!queryFilter( field:"appointmentDate", operator: "between", value: { todatetime(ri!createddatefrom), todatetime(ri!createddateto) }, applywhen: and( not(rule

Hi. I added some new document types in Standard Channel and I wanted my model to auto classify the document. I tried many times but did not get any email from Appian regarding Classification of the documents. I just wanna ask, is the feature to train documents for auto-classification even available for Appian community edition users?

Hi,I'm studing the Appian RPA console and I'm using the free license.I downloaded the robot code and I tried to build it with maven, but obtain this error[INFO] Downloading from jidoka: nqiz.appian.community/.../jidoka-robot-parent-7.11.0.pom[ERROR] [ERROR] Some problems were encountered while processing the POMs:[FATAL] Non-resolvable parent POM for com.novayre.jidoka.robot.test:POC_HelloWorld:0.0.1: Could not transfer artifact com.novayre.jidoka.robot:jidoka-robot-parent:pom:7.11.0 from/to jidoka (nqiz.appian.community/.../): Authentication failed for nqiz.appian.community/.../jidoka-robot-parent-7.11.0.pom 401 Unauthorized and 'parent.relativePath' points at wrong local POM @ line 5, column 11I don't understand where I find the username/password or the mode to create it.pom.xml<?xml version="1.0"?><project xsi:schemaLocation="maven.apache.org/.../4.0.0 ">maven.apache.org/.../maven-4.0.0.xsd" xmlns="">mav

Hello. I am interested in pursuing an RPA solution in an On-prem Appian instance.  Is it possible? and if so, can anyone kindly provide documentation on how to proceed with this?  Thank you.

We have got an email box ( for example : Customercare@xyzcompnay.com). There are thousands of emails here related to customer issues like  Email 1 : "internet is very slow" Email 2 : "have a query regarding refund" .etc. Email X: "Would like to change my personal details". I would like to create a process which reads the above emails and creates tasks based on keywords.  This process has to create as task for Finance team with Email2 as it is related to Refund. And it has to create another task for IT team with Email1 data as it is related to Internet and so on another task to HR Team with Email X. I assume it is more of a AI ( Machine learning ) work.  Is there any way to do this in Appian ? Thanks

Hello, I am receiving the following error executing a robotic process: Exception thrown on agent...com.novayre.jidoka.client.api.exceptions.JidokaBrowserInitFailureException: The driver executable does not exist: C:\Users\Vladimir\Downloads\target\test-classes\.\chromeWebDriver\chromedriver.exe I have included the driver inside the supported files but getting this. Any Idea what is causing it ?

Hello,  I have a Execute Robotic Process inside a process per documentation it says for this node:  ------------------- Data tab Node inputs When an integration is selected, the integration's inputs will automatically appear as node inputs. If you change the selected integration or the inputs of the selected integration are updated outside the process modeler, the node inputs will be refreshed the next time you view the Data tab. ------------------- Problem which I am facing is that in the Robot I have 3 variables, they appears inside the Integration view but does not appears inside the pcoess Node in the Input Data Tab. Any idea why ?

Is there a way to authorize the carriage return when using the cleanwith() function? I tried to include char(10) or char(13) at the end of the "with" parameter, but the result is not what I expected. Examples: ri!myText: "My texte with carriage return" cleanwith(ri!myText,"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ "&char(10)) Result > "My texte with carriage return" cleanwith(ri!myText,"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ "&char(13)) Result > "My texte with carriagereturn"

Hi all, We are trying to run a process in unattended mode, however when we disconnect from the resource it appears as blocked from the Appian RPA Console. We've followed the instructions from: https://docs.appian.com/suite/help/20.2/rpa-7.1/get_started/faqs.html, in particular we: Log into the resource computer using Windows Remote Desktop Connection, starting a session. Execute the Appian RPA agent with administrator privileges. When the resource is connected to the RPA server, verify in the console's resource detail page that it was initiated with the administrator privileges. Close the Remote Desktop Connection. At this point, we have a session initiated by Remote Desktop Protocol (RDP) and locked. The Appian RPA resource, while executing with administrator privileges, can unlock the session and run a robotic process. After it finishes, it will lock the session again. From the resource we can see that the option "Agent with elevated privileges" is checked ho

Hello, We are setting up Appian RPA and have created a robot virtual server and we are able to run our Appian RPA process from the server when we have it open. We are currently connecting to the server using a service account and Remote Desktop Protocol. When we connect to the server using a service account but then close down the connection(RDP) the account is still logged in which is what we want. However, when we try to run an Appian RPA process on the server the screen is locked. The same thing happens when we connect to the server using RDP and then minimize the window. It says the screen is locked or the robot can't see the desktop. The thing we noticed about this is that the status is Blocked when this happens. How can we set up the server to have an account logged in and then accept messages from Appian RPA and run a process without the screen being locked or minimized? Thanks, Anthony

Hi All, We wrote a query to fetch  date from one particular entity from Database, but the output(date) differs based on the user time zone. For example , In Database it shows as 10th June 2021,12:06 AM, For GMT time zone user it shows as 10th June 2021,12:00 AM as output in expression rule, For EST time zone user it shows as 9th June ,8:00 PM as output in expression rule. Can you please help us to sort this, Thanks in Advance. Regards, Jansi J

When i add process model to navigation bar it works fine but then i collap the navigation bar it show blank on icon click  how to add process model to section layout? a!sectionLayout( contents: { rule!TCT_Template_Dashboard() } ), a!sectionLayout( contents: { } ),

Hi All,  I have a column  name created date in db as datetime . When I am creating filter in expression rule as createddatefrom and createddateto . I am not able to filter it .  Expression Rule: a!queryFilter( field: "createddate", operator: "between", value: { todate(ri!createddatefrom), todate(ri!createddatefrom)+ day() }, applywhen: not(rule!APN_isEmpty(ri!createddatefrom)) ), a!queryFilter( field: "createddate", operator: "between", value: { todate(ri!createddateto), todate(ri!createddateto) + day() }, applywhen: not(rule!APN_isEmpty(ri!createddateto)) ), Please help and thanks in Advance