Process Automation

While trying to check an empty map, a!isNullOrEmpty and a!isNotNullOrEmpty are not working, rather giving opposite result.  The result of a!isNullOrEmpty(a!map())should be true but the function is returning false. Not sure if this is a bug but something that might need the engineering team's attention. [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05]

A,                                             1 BC,                                          2 DEF,                                        3 GHIJ,                                       4 KLMNO                                   5 ---------                                     -- A to Z                              &nbsp

Hi, I am trying to call the Appian RPA robotic process from Appian. I have created a connected system and integration object. In the integration object i have selected the operation as 'Execute Robotic process' but I don't see any robotic processes to select. The following message is displayed there "You do not have permission to retrieve the list of robotic processes.".  I could see the robotic processes when I login to RPA with same login and I have the same permissions to resource, user and robotic process. I do not know what is missing here. Please advise.

Hi, I wanted to try MS Outlook Java Module using Custom Code to process specific emails which are coming to a mailbox.  I was able to complete the below pre-requisites with the help of the documentation - https://docs.appian.com/suite/help/22.1/rpa-7.13/custom_code/configurator.html JDK Version - 1.8.0_221 Maven Version - 3.6.3 IDE - Eclipse Neon Post this, I had created a new Robotic Process using blank template. The project which got downloaded was extracted and imported as a Maven project. After importing, I got an error message as mentioned below -  "No marketplace entries found to handle jidoka-maven-plugin:8.1.0:generate-resources in Eclipse.  Please see Help for more information." The overview of my pom.xml is as mentioned in the below screenshot.  Within the pom.xml, I was able to see the error - "Plugin execution not covered by lifecycle configuration: com.novayre.jidoka:jidoka-maven-plugin:8.1.0:generate-resour

Hi everyone, I've a task that say: Convert 12/12/21 to December 12, 2021 and he gives me this hint Hint: You need to use two Appian functions: text() and datevalue() this is the task on the image below. can anyone would help me to do this task.

I want to Create time slots for specific interval and get a List of all slots (like 20 min or 30 min slot) for Interval.

I have the following which i saved as a process variable of type text { "userId": "abc123", "submissionId": "111222333", "createdDt": "2022-06-17T04:07:19.611Z"} I want to remove spacing between the commas and colons, trying to do so with substitute(pv!text, ": ", ":") and substitute(pv!text, ", ", ","). It works for the colon, but not for the comma, so the result is the following { "userId":"abc123", "submissionId":"111222333", "createdDt":"2022-06-17T04:07:19.611Z"} Also, when i use stripwith(pv!text,","), the comma can be affected and removed. Wondering why substitute cant do the same. Any ideas as to why this is happening or how else I can remove the space between the comma?

I have a requirement where the client would like to be able to scan barcodes using a handheld scanning machine and have them save in the Appian UI. I have read the following documentation: https://docs.appian.com/suite/help/20.4/Retrieve_Data_By_Scanning_A_Barcode.html From the documentation, it seems that it is only possible to scan a barcode and show it on the Appian UI using a mobile device (smartphone). Is there any way to achieve the same functionality using a handheld scanner, either Bluetooth or USB?  The brand the client has is Symbol.  For example: www.amazon.com/.../B00HYOPAJG

instead of having text for a rule input which accept user names, is it possible to have a user type? 

hello! i have a question, well, i have a dropdown with some data, for example, in a dropdown i have states, what i want is that when i select a specific state, a list of cities appears in another dropdown, with my team we have done it with if, if nested, match, but we keep getting errors, regarding the interface, and with the definition, it even tells us that the values of the cities in the other dropdown are invalid, for your attention, thanks alot!   

I need to get a list of all objects separately of a application , the application contains around 3500 objects , any suggestion how can i get this 

Hi, I am creating a BOT, need to interact with element - login and password --> credentials..should be simple and straightforward but something's wrong..any help will be appreciated. for login, am trying to use name as selector with username as value same issue with class name.. and it is unable to find this selector as you see the source code doesn't gives me too many options.. when I try to use the recorder ..it picks up the CSS selector with value as c-portal-login and the login works perfectly but the problem is for the password field as well recorder is picking CSS selector = c-portal-login which confuses the BOT later (quite obviously) and the BOT updates the value of login and password credentials both on the same login field.. any suggestion will be helpful thanks jaideep

Hi All, Assume like the user have entered the below start date and end date and also, they have selected some contracts and price groups based on the date logic. Start Date: 15th June 2022 End Date: 15th July 2022 Now I have a table like below with all the selected data, Contract number Price grp id Frequency xxx xxx-1 Monthly xxx xxx-2 Quarterly xxx xxx-3 Semi-Annually xxx xxx-4 Annually   My scenario is like I have to check the frequency from above table(cdt) and split it into multiple rows based on the date range (Start Date & End Date) and update in another table(cdt),please refer the resulting expectation, Case 1: Frequency: Monthly>>then 2 rows >>1st row: {Start Date: 1st Jun 2022 – 30th Jun 2022}>>2nd row: {Start Date: 1st Jul 2022 – 31st Jul 2022} Case 2: Frequency: Quarterly>>then 2 rows >>1st row: {Start Date: 1st Apr 2022 – 30th Jun 2022}>>2nd row: {Start Date: 1st Jul

Hi, I'm doing the activity of the course, but I got a problem with this query:  a!queryRecordType( recordType: 'recordType!{058be2d0-0acb-453f-93ac-4c9f650cf004}Vehicle', fields: a!aggregationFields( groupings: a!grouping( field: Vehicle.make, alias: "Vehiclemake" ), measures: a!measure( field: Vehicle.make , function: "COUNT", alias: "count" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 )) .data when I tried to test the rule I got this error: Expression evaluation error at function a!aggregationFields [line 3]: Could not find variable 'Vehicle' I followed every single step in the exercise So, I don't understand what's the wrong here. Can anyone tell me what's the wrong??

Has anyone faced issue with char(0015)? I was trying fetching pdf text from file by splitting with char(0015). However, everything contains 15 in a document file is removed or replaced with blank value. Here is the code I tried for the same. a!localVariables(  local!text: getpdftext(document: 32030),  local!test: a!map(id: "header", value: local!text),  local!text1: split(    /*local!test, char(0015)*/    substitute(local!test, char(13), ""), char(10)  ), )

Hello, Can anyone tell me how can I access the expression rule? I want to create new expression rule. 

I read about IDP how advance and easy to use Appian's IDP for document processing. I am wondering a scenario where Appian's IDP is not an ideal solution to use? Does it have any limitations?

Hi  i have to display highlighted text in bold    code to display the text when i try like this   and the output is coming like this what is the mistake?

I am querying data to get address but when the value is null I am getting ",,,,,". How to remove this comma if fields are not theretrim(concat( property(local!address,"fullName",null), property(local!address,"buildingNumber",null) & ", " & property(local!address,"streetName",null) & ", " & property(local!address,"district",null) &", "& property(local!address,"unitCode",null) &", " & property(local!address,"cityName",null) & ", " & property(local!address,"zipCode",null) ) )

 Expression Rule: cast('type!{urn:com:appian:types:HSM}HSM_Elements?list', a!queryEntity( entity: cons!HSM_Entity, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 5000, sort: a!sortInfo( field:"S_No", ascending: true, ) ) ) ).data ) I want to retrieve every data without Status field from database. Is it possible to retrieve using rules?

Hi  how can i write above query in ER?  can anyone help me with this? i have tried but it gives error

I use a viewer's account and try enter a new site, the account does not have permissions of the site. When I try enter the site, Appian alerting me to display  "403 Access Denied You don't have permission to view this page.", sometimes, an error is popped "An Error Has Occurred The Site xxx does not exit, has been deleted, or you do not have sufficient privileges to access its data." if I use designer's account, All are ok. I expect to display only one case - “403 Access Denied You don't have permission to view this page.”

Hi, In some ER code, I have found this kind of things : rule!APP_GreaterTo(value: _, to: 14), or :       contains(        reject(          isnull(_),          ri!names        ),        tostring(ri!name)      ),                                                  Could you explain me what does mean that "_" ? is it just to specify we do not want to pass any parameter in the function ?  (because "isnull()" is not authorized) but why "value: _"  in place of "value: null" ?