Discussion Categories

Hi All, Requirement:                     I have a use case where I have to get documents from target environment to source environment. Information:                     I have list of appian documents id in my source environment database. Approach: ->  I have developed a web api in target environment , it will return document based on appian document id. -> I have designed a process model , In which I am getting appian documents id from table and calling target webapi using integration object. It was working fine and getting documents as i expected. Inputs required : Which way is better among below two approaches. 1) Getting appian documents id's as a batches ,using MNI  and pass it to sub process having integration call logic  2) Looping approach . I don't have enough information about number of appian documents id's to process , Please share your

Hi All , Hope you doing  well.  "My scenario is that I worked on a Card layout. Within the Card layout, I have some text fields. Initially, the Card layout has a predefined color. My task is to change the color of the Card layout when any value is entered into the text field. Can anyone help me out?"

Hi All, What is the use of using a!save in save into of interface.Is there any clarification on this? Thanks

Trying to map entries that full under the same month together and return count for total entries in that month  with( local!metrics: rule!OCSC_getNumOfTierTwoRequestsSubmitted( startDate: ri!startDate, endDate: ri!endDate, ), local!asmts: a!forEach( items: local!metrics, expression: { svc_request_id: fv!item.svc_request_id, totalServicesPerformed: fv!itemCount, date: fv!item.created_datetime, month: month(fv!item.created_datetime), year: year(fv!item.created_datetime) } ), local!mergedRows: local!asmts, /* create list of maps with sum of collective asmts done by year-month */ local!dates: a!forEach( items: local!mergedRows, expression: { month: fv!item.month, year: fv!item.year } ), local!datesDist: union(local!dates, local!dates), local!prepared: a!forEach( items: local!datesDist, expression: with( local!dateIndex: fv!item, a!map( month: fv!item.month, year: fv

Hello i am trying to make validation for editable grid in appian so i am not able to enter same value into multiple rows but even when value is entered only in one row validation is triggered. Here is the code for validation: validations: if(fv!item.value = local!arrayOfStrings,"Id already exist",""), fv!item.value is always there at least once as it is automatically stored in local!arrayOfString so even if it is not in local variable once i entered the value into grid it is saved into  array so i need to check if it is there more than once thanks for any advice in advance

HI I'm getting an error while creating a form  Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!imageField [line 60]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null. Please help me

What is the recommended best practice for Search Record List Limits from a table? Are 500,000 records or less acceptable?

Hello! This question arose from working through the course "Tutorial: Automate Windows Applications (RPA)", which involves copying and pasting text between Calculator and Notepad.  Unfortunately the instructions assume an older version of Calculator, since mine doesn't have an Edit menu. My workaround is to have the robotic task right-click into the display screen in order to be able to grab the text. Since RPA is new to me, I am currently having to brute-force the coordinates of where the mouse should go to click. I downloaded Mouse Point Viewer and got the following values: Relative (Calculator) Coords: X=130, Y=132 Screen Coords: X=324, Y=179 However, in the Move Mouse function in the task, after much trial and error, it finally worked after I configured the location to (800, 800). Can anyone explain where (800, 800) comes from?

Hi there, Anyone here know how to connect to GitLab? I see there is connected system for GitHub, anyone know there is one for GitLab? Thanks, Lin

I want to the same result as this SQL query "SELECT WorkType, COUNT(DISTINCT Site) AS DistinctSites FROM your_table_name GROUP BY WorkType;" in using query on data entity. I am able to get the count of sites and Group by WorkType but count of sites is not distinct.a!queryEntity( entity: cons!SD_TEST_DATA, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "worktype", isGrouping: true ), a!queryAggregationColumn( field: "site", alias: "site_count", aggregationFunction: "COUNT" ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false )

Hi Team, I need a plugin having capability to convert DOCX to PDF format. I tried below available plugins for my requirement but I am unable to get any OPEN-SOURCE available for this.  advanced-document-templating-1.0.12.jar (It is not converting complete data. It only shows only picture format data to convert DOCX to PDF not shape format) dynamic-document-generator-2.0.4.jar (It is not converting complete data. It only shows picture format data to convert DOCX to PDF not shape format) convert-docx-to-pdf-(aspose)-2.0.10.jar (It is a paid License) Out of these plugins, convert-docx-to-pdf-(aspose)-2.0.10.jar this plugin  have the capability to convert DOCX to PDF but paid license required. So if you can suggest any other plugin which is available on Appian AppMarket to use for converting DOCX into PDF. (That should be Open Source)

Hi there, I've got a business needs where I have 2 records types (let's call them RT1 and RT2). RT1 has a one-to-many relationship with RT2 and I need to display a grid where my row would be RT1, in which the first 5 columns would be property of RT1 while the following columns would be dynamically added based on possible values of RT2, this mean the number of columns would be equal to the number of properties of RT1 + the number of possible values for RT2. This could give something like :  Name Color Brand Model Places Feat1 Feat2 Feat3 Feat4 Feat5 XYZ Blue Ford GT 2 1000 200 500 1500 600 ABC Red Mazda CX-9 7 2500 3000 What would be the best architecture to build that?

Hi All , I have a very strange scenario . I have created an Interface which shows Data in Editable Grid, I want to Export this Data into an Excel File. In order to Export the Excel File , I have created a Process Model which stores the required document into One Document Folder.Now, I want to have a link to download that particular file.I am able to do everything , While testing Interface , I am getting output of process variable ( i.e. the Exported Document) but when I am using that Interface in Site I am not getting output from Process Model.Here is the image of Process Model: a!startProcess( processModel: cons!MBUA_PM_EXPORTEXCEL, processParameters: { gridData: ri!excelData, }, onSuccess: a!save( ri!document, fv!processInfo.pv.exportedExcel ) )Here is the code which I have used for Starting this Process Model.

I want to generate a Column Chart from Expression rule which contains query aggregation on two columns , How can I generate a Column Chart for this. Below is the code of my Expression Rule index( a!queryEntity( entity: cons!MBUA_DSE_TESTSITEDATA, query: a!query( aggregation: a!queryAggregation( { a!queryAggregationColumn(field: "site", isGrouping: true()), a!queryAggregationColumn(field: "worktype", isGrouping: true()), } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ), "data", null() ) Below is the code on Interface having Column Chart: a!localVariables( local!myData: rule!MBUA_readChartView(), { a!columnChartField( label: "Column Chart", categories: { "Category 1", "Category 2" }, series: a!forEach( items: local!myData, expression: a!chartSeries(label: "Chart", data: fv!item.worktype) ), stacking: "NONE", show

Has anyone successfully used JWT (JSON Web Token) to integrate with another system? Is Appian able to decode a JWT? It is necessary to use a plugin? I found this plugin https://community.appian.com/b/appmarket/posts/jwt-web-token-tools in the app market and I think that with the decodeJWT function I can achieve this. Can someone confirm this please?

Hi, I am getting an error when I click on any dynamic link or button in my task (with no submit). I only have this error when I access the task from the mobile application, from the browser everything works correctly. The error is "An error was encountered while processing your request", and I don't know how to get more information about it, maybe in the STDOUT log? I have deleted any operation in saveInto for testing, and I still have the problem, It seems that it is simply by clicking Could someone explain to me what could be happening? Thanks and regards

Hi, I am getting following exception error while running fittnesse test: _EXCEPTION__:org.openqa.selenium.remote.http.ConnectionFailedException: Unable to establish websocket connection to localhost:57708/.../98ab4b7f-1fff-48c0-88eb-853c24056bed Build info: version: '4.1.2', revision: '9a5a329c5a' System info: host: 'DESKTOP-88E80PB', ip: '10.0.0.252', os.name: 'Windows 10', os.arch: 'amd64', os.version: '10.0', java.version: '1.8.0_251' Driver info: driver.version: ChromeDriver at org.openqa.selenium.remote.http.netty.NettyWebSocket.<init>(NettyWebSocket.java:104) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.remote.http.netty.NettyWebSocket.lambda$create$3(NettyWebSocket.java:137) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.remote.http.netty.NettyClient.openSocket(NettyClient.java:118) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.devtools.Connection.<init>(Connection.ja

Is there a way to identify the number of logins from past 6 months? I know we can access the login -audit files manually but that would take a lot of time. Is there another easier way to fetch it via rule? Please advise.

Hello, I'm trying to figure out how we can set up alerts based on the metrics in our Health Cloud Metrics reports. For example, we're able to see the CPU Utilization metrics to the servers that are hosted in Appian. How can we set up an alarm/notification to alert my team when it hits a 90% threshold?

a!recordFilterList( name: "Employee Name", options: a!forEach( items: local!data, expression: a!recordFilterListOption( id: fv!index, name: rule!CMN_PLATTS_GetUserFullName(fv!item.employeeName), filter: a!queryFilter( field: 'recordType!{c3db295c-a167-41fc-84b6-90d578db6968}Employee.fields.{employeeName}employeeName', operator: "=", value: fv!item.employeeName ) ) ), allowMultipleSelections: true() )

Hello, ALL. Can someone Just give me a step-by-step about How to insert data into a DB from a site? I Just trying during ALL the day nd dont know How to do.

I want to generate an XML file where each columns are created with different rules defined from multiple tables. How to achieve this?

Hi , I have list of arrays coming from foreach, now i want unique elements for the list of arrays. for example localvariables( local!arrays:foreach( items:{5,6,7}, expresssion:enumerate(fv!item)+1 ) local!arrays ). form this output,  i want unique elements from the list of arrays. can anyone help me in this? intersection is working only for separate arrays stored in each local variable but not for arrays executed in foreach.

Hi All, We have build an application wherein we have some DB calls happening on the main page and then there is a a!startProcessLink() action configured to modify any data. Everything is working correctly but as soon as a!startProcessLink() is completed, the main interface reloads causing every DB calls to re-execute. We know this can be handled properly via recordType but as per our requirement that is not the suitable option. Can anyone suggest how we can stop making these extra calls if possible? Thanks in advance

Hello everyone I noticed that  HTML to PDF smart service dose not  support Arabic language ? The PDF form Shown as the following page  is there any solution for that? or is there another plug-in that does support Arabic language for pdf? I also tried to use different Font types, all give the same problem! NOTE: I am using Advanced Rich Text for Tables and very large paragraph.