Process Automation

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

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

Hi, Is it just me or everyone..I am not able to access Appian RPA on community edition as I write this .. https://euhz.appian.community/suite/rpalogin thanks jaideep

Hi All I have a requirement to query a value in nested CDT which is in 1:M relationship Is it possible ?

a!gridColumn( label: "Assignees", sortField: "c4", value:group(fv!row.c4, "groupName") ), Using this code in a gridfield. Getting the data from queryprocessanalytics to populate a grid. Field c4 contains the group number. i am trying to get the corresponding group name. Pls help.

I have a REST service that returns JSON which is converted to Dictionary by the integration.  I have CDTs I have imported from the service WSDL (so the property names exactly match the JSON names).  The problem is that array properties are left null instead of being populated. I'm trying to convert it this way.... with a single call to cast of the top-level node. /*local!rawData: rule!SH_GetLibraryIntegration(libraryName: ri!libraryName) */ local!rawData: a!fromJson( "{""GetLibraryResult"":{""Name"":""Uptown Public Library"",""HeadLibrarian"":""Kathlyn Walton"",""Books"":[{""Author"":""Fyodor Dostoevsky"",""Title"":""Crime and Punishment"",""IsCheckedOut"":false,""DueDate"":null},{""Author"":""Charles Dickens"",""Title"":""A Tale of Two Cities"",""IsCheckedOut"":true,""DueDate"":""01-10-2021""}]}}" ), fn!cast( 'type!{http://schemas.datacontract.org/2004/07/TestService}Library', local!rawData.GetLibraryResult ) However, The "books" (in my

Hi All, I am getting error in below expression  a!localVariables(           local!userName: "xyzUser",           if(                isusernametaken(local!userName),                a!isUserMemberOfGroup(local!userName, cons!PP_GROUP_CONSTANT),                0              )) Error as Expression evaluation error at function a!isUserMemberOfGroup [line 5]: [InvalidUserException] I observed this issue with deactivated user in only one environment where in lower environment its working fine with deactivate users as well. Thanks in Advance!

Hi all, I'm currently having an issue where a!exportDataStoreEntityToExcel is only working for people in the admin group for the application. Is there a way to configure a!exportDataStoreEntityToExcel to work for "All Users" within the application?

Hi,I have 2 doubts: 1 - Is it possible to modify the task to get the look of the old workflow?2 - Within the task of the new workflow aspect, where can I find the "Import Section from Selenium file" button? Thank you for your attention, Iulia

How can I write below SQL query through query entity in Appian Select * from A where A.colmn1 = max(A.colmn1)

HI  here i have used <br> tag for new line now the issue is whether the values is present in limitamout or not it's going to new line/ breaking the line  this is how the output looks like  but whenever the data is empty then it shouldn't break the line  how it can be done 

hi All ,  How to update a document type constant.  I am trying to update using a Update Constant smart service , but its not worth it .Please tell me so that I can achieve this easily.  Thanks in Advance 

Hi Community, I need to display the list of folders and files inside specific SharePoint folder. I have the access to see the folders and files in SharePoint, but the Appian Integration shows no result although the integration tests successfully. Note that, the connected system test connection success too. This is the folder path: This is the integration result:

What is the best approach to trigger workflow when ever an image is uploaded.? Can the image upload be done using an web API exposed by Appian? Can anyone kindly share any documentation or example for implementation help

What is the best approach to trigger workflow when ever an image is uploaded, Can the image upload be done using an web API exposed by Appian. 

I have doubt on POST API, Firstly I am creating an API  can I know where the document would come within Appian from external system using POST API.

Hi, I have a setup on a windows machine with maven 3, Java JDK and Intellij. I have a settings.xml on .m2 folder on my user profile with a maven key on <server> tag I generated from RPA Console. I have create a blank template robotic process and when I tried to open the pom.xml from the downloaded project on intellij I got an 401 error pointing to my repo URL. is there any file other than settings.xml that we have to configure the maven key? When I go to the Maven settings on intellij under repositories I see an error saying that a authorization exception happened trying to nexus-maven-repository-index.properties. Am I missing some configuration? I tried these steps docs.appian.com/.../maven-setup.html thanks, Eduardo

Hi All, How Can I fetch the status of RPA Bot weather it is online or offline or something else because I want to create an Interface where I have show the Show the status of RPA Bot and based on the status I have to perform some further actions .  Thanks in Advanced

i have created a web API to upload a image. the image is storing in the destination location but cannot able to store mapping in DB