Process Automation

Hi all, I'm following the tutorial RPA Tutorial: Parse Excel Files to learn how to retrieve files from a resource. From this example, I'm using my pc as resource. In one speficic documentation steps, there is the note If you’re using your own desktop as your resource, do not use your mouse or keyboard while the test is running. So, when I launch  the robotic process, I don't touch my mouse or my keyboard. So, system gives me the expected results for file properties, but, when I move the mouse, to read it, it appears a pop up with a message error. I try however to configure the process and I receive another error with request status ENQUEUED. Which could the problem be?  Thanks in advance. Regard, Juri Monti

Hi, I have below rule which gives output for distinct values only, but I want get output for indistinct values also. For Ex: If I give rule input for groupId_int as {496,496,498} , I should get output for all 3 values though it repeats for 496 two times. But here I'm getting only for 2 items as below screen shot. Can anyone please help me how to approach  index( a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_APPIAN_GROUPS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "Id_int", operator: "in", value: ri!groupId_int, applyWhen: not( rule!APN_isBlank( ri!groupId_int ) ) ), a!queryFilter( field: "groupName_txt", operator: "in", value: ri!groupName_txt, applyWhen: not( rule!APN_isBlan

Hi, is there a way to task record unsupported element in RPA.

Hi, I need to modify time stamp given by caladddays to 12:00AM always. How do I do that. Thanks

How to get the Rule Id of the Expression I want to update, since I want this dynamically based on the rule name I am extracting elsewhere and passing as a process parameter? Here when I select the rule by typing and prompt, and save it into a pv created using (+), it is showing the value for that particular rule, I but I want it to be dynamically populated.

For the word "technology", Eg t-1 e-1 c-1 I need character count of unique elements of this string

I have three CDTs that contain some fields with the same value. I want to create an expression rule that matches them and extracts only the fields that don't overlap. What function can I use to make it?

I am attempting to display a CSV file stored in CDT in the UI using the documentViewerField. Here is the code.However, I just get a blank rectangle in the UI. Does the documentViewerField component not work for CSV files? a!documentViewerField( label: index(ri!variable, "documentName", {}), document: index(ri!variable, "document", {}), height: "TALL" ),

Hi, I have a interface from where i want to invoke process model having user input interface. I have used start process it invoked the process model but showing stuck in node having interface configured and noting is displayed in parent interface also. However same process model is configured in Record action of record type design objects , it's working fine.

Out of curiosity - has anyone implemented Search capabilities in Appian for Homophones?E. g. searching for a user in a database field for names, typing in 'Fill', Appian will search also for 'Phil'. Thanks

Hi all, The title basically describes it. I'd like to be able to apply filters on a list of maps on their key values. For example in the code snippet below, to be able to set filter("name","=",bill) or filter("name", "not null"). Similar to a!queryEntity but for a collection of map instead of a Entity   a!localVariables( local!mapCollection: { a!map(name: "bill"), a!map(name: "bob"), a!map(name: "Jim"), a!map(name: null) } ) Also be able to apply operands like and and or if there are multiple key values in the map collection

If there is any expression evaluation error on interface, how can we display that error on UI if want to show to user. Reason for error need to display on UI.

Hi everyone. I would like to know how to return from my java code to a robotic process. Refering the URL below, I write a program including getWorkflowParameters() method.docs.appian.com/.../develop-java.html ■my java code package com.novayre.jidoka.tutorial; import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.time.LocalDateTime;import java.util.Map; import com.novayre.jidoka.client.api.IJidokaServer;import com.novayre.jidoka.client.api.IRobot;import com.novayre.jidoka.client.api.annotations.Robot;import com.novayre.jidoka.client.lowcode.IRobotVariable; /** * My robot * @author jidoka * */@Robotpublic class MyRobot implements IRobot { /** * Server */ private IJidokaServer<?> server; public void getAllRecordFromAccess() throws Exception { Map<String, IRobotVariable> variables = server.getWorkflowParameters(); IRobotVariable rvAccessFileName = variables.get("strAccessFile

i was creating the question bank application in which i want the particular exam to be end in that specific time so how can i do that ? 

Hi, everyone I am trying to build Maven project with Eclipse. However, I am getting an error. Eclipse says that downloading org.apache.maven.plugins:maven-deploy-plugin:2.7 is failedbecause it is impossible to access www.novayre.es/.../1.0-SNAPSHOT According to what I found, the URL has been gone or its domain has been changed. Could you tell me how to solve it? Finally, I share log message Eclipse output.--------------------------------------------------[[1;34mINFO[m] Scanning for projects...[[1;34mINFO[m] [[1;34mINFO[m] [1m-----------< [0;36mcom.novayre.jidoka.tutorial:robot-development[0;1m >------------[m[[1;34mINFO[m] [1mBuilding robot-development-Dversion=0.0.1 Jidoka Robot 1.0-SNAPSHOT[m[[1;34mINFO[m] [1m--------------------------------[ jar ]---------------------------------[m[[1;34mINFO[m] [[1;34mINFO[m] [1m--- [0;32mmaven-clean-plugin:2.5:clean[m [1m(default-clean)[m @ [36mrobot-development[0;1m ---[m[[1;34mINFO[m] Deleting C:\AppianRPA\AppianRPARbot-CustomJavaCode\robo

I am setting up Maven.As part of that, I excute Maven commands "mvn package -Pjidoka-repo". However,I am getting an error below.-------------------------------------Non-resolvable parent POM for com.novayre.jidoka.tutorial:robot-developmentguide-first-robot:4.0.0: com.novayre.jidoka.robot:jidoka-robot-parent:pom:4.0.0 was not found in mnvk.appian.community/.../repo during a previous attempt. This failure was cached in the local repository and resolution is not reattempted until the update interval of SERVER_ID has elapsed or updates are forced and 'parent.relativePath' points at wrong local POM @ line 10, column 10 ->------------------------------------ Could you tell me how to solve it?

I have following code in my expression rule, its giving the data correctly but when i apply sorting it is working fine for all the other fields but for the fields: "Headlines" and "ArticlePostDate" it shows empty data, doesn't return any data. These two are the fields that are not part of the main table and i am referencing it from another table that could be the cause that its not showing any data when I apply sorting in them. Can anyone please help what to do in this scenario. Thanks a!localVariables( local!sortField_txt: rule!EF_PlantDashboard_NewsPagingMapping( sortField_txt: ri!pagingInfo_pi.sort.field ), local!oDataQuery_txt: concat( "/Internal/Editable/ABC?editable=true&includeDeleted=true&$expand=Article($select=ArticlePostDate,Headline)&$filter=Key+eq+", ri!Key, "&$count=true&$top=", cons!EF_PLANTDASHBOARD_NEWS_PAGESIZE, "&$skip=", ri!pagingInfo_pi.startIndex - 1, "&$orderby=", local!sortField_txt, if(

Here is the Screenshot of warning which i'm facing in the Execution Log. Earlier, it was working fine, but after the update of Google Chrome, this happened.

Can any on help me for "how to sort the text field integer values", example i have field name: data it is text field but in that field values are stored 10,000 and 80,000 and 20,000 so i want to sort those values if anyone know can you please help me with it?

Is there a way to capture screenshot as part of BOT processing and save it to Appian documents folder?

Hi All, I have numbers between 100-200 and I want to display the 5 multiples and 5 included numbers. Sample output: 105,110,115,120,125,130,135,140,145,150,151,153,154,155,156,157,158,159,160,165,170,175,180,185,190,195,200

In DB I have some records with only Date and some records with date& time Example: 2/1/2023 1:22:31 PM 10/17/2023 11/15/2023 7/07/2022 6/17/2022  2:22:32 AM 11/17/2022 9/28/2022 9/28/2022 i need to filter it out with only date but where ever time records available those records unable to filter it out a!queryFilter(field: "date",operator: "=",value: ri!date) can someone help me with this

Hi All, I have an external report where i will be pulling data into Appian. When am storing fields into Appian i could see space is replaced with "non breaking space". for ex: IN Appian DB: In External report: Can anyone suggest why this is happening ?

In IDP home page we cant find tasks metrics and configure options.