Process Automation

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.

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18}Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

I need to setup an intergration between UiPath and Appian, and have learned that by using the "Appian Activities" utility and "UiPath Connector" plug-in, the connection between the two could be done. Meanwhile, I also notice that when searching related information through Appian Document, UiPath seem to be associated with RWM to some extent. I would like to confirm that whether I need a RWM in order to finish the setup. Does anyone have any idea about how RWM function within the process indicated as the picture above.

I'm currently trying to implement RPA to get the title, URL, etc. of each news from the news list on the news site.My RPA was able to get the information I wanted and store it in an array.However, the information cannot be saved in Appian's DB in table format. I would like to store the contents of the array that holds the acquired information in the pre-created CTD. Since the Appian document states that it is not possible to directly store data from RPA to the DB, I will implement RPA which creates a list of data saved by CDT etc. and returned this list to the process model. If you have better idea, could you tell me about it?

Given a dictionary D , and a list of nodes N, I need to replace all existing nodes in the dictionary which are single value to list of values containing the single one. For example:   D= {foo:"bar",bar:"baz"}, N={"foo"} => {foo:{"bar"} /*converted*/,bar:"baz"/*no change*/}    D={bar:"baz",foo:{"multi","items"},nested:{foo:"bar"}}, N={"foo","bar"} => {bar:{"baz"} /*converted*/,foo:{"multi","items"}/*no change*/ ,nested:{foo:{"bar"} /*converted*/} The use case is to support conversion from XML where certain nodes should be arrays, however when converting from XML to JSON and there is  a single item under those nodes, we need it to be array and not a single object. 

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.

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?

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? ```"

how can i sort an Array?