-
Recently active
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.
The main question is about how Appian cache the data when you relate a record type to database tables. Also does this cache mechanism provided when you relate a record type to database views.
I have a table in particular sheet of excel file and the cell are all bordered for them till next 50 cells but when i try to read cell after 50 in that column it breaks just because of the below cells are not bordered. Can you please help me with the same excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate( 100 ) + 89 } ) Error: Expression evaluation error at function 'excelreadcellsbynumber' [line 36]: above expression breaks and the below one works excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate(50 ) + 89 } ) only difference i can spot is the cells after 50 from cell line are all bordered. and when i border all those extra cells it starts working. Please suggest, if this is expected behavior or am i doing something wrong
Hi Guys Is it possible to run mulitple instances of Write Records smart service as a single transaction, i.e. if one of the instances fails, all updates made by previous instances are rolled back? According to docs, Records can only be updated for one record type at a time (https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html) So say I have a record type representing a bank account. And I have a process model to transfer money from one account to another. The high-level steps are: 1) Update balance of account 1 (deduct the amount) 2) Update balance of account 2 (add the amount) If step 2 fails, account 1 will be charged, but nothing will be added to account 2. If there is no option to run the 2 actions as a transaction, what is the best practice for handling such cases?
When a user adds a text value to a floating point field, Appian displays a validation message by default. However, when the user clicks the refresh button in the same UI, all validations should be cleared and the fields should be reset. Unfortunately, Appian's default validations are not refreshing properly in this scenario. Is there a solution to refresh the validations after clicking the button in the same UI, without using record actions?
is there any guidance for Associate developer interview i have passed certification of associate developer
Hi, When I try to export the entire application code, we are encountering the below error. Not sure what might have caused the issue. Any advises, please. group 99 _e-0000c90c-c915-8000-4e54-011a94011e94_199: The data for group [id=99 _e-0000c90c-c915-8000-4e54-011a94011e94_199] could not be retrieved for export. Cause: Insufficient permission (APNX-1-4071-002)
Hello, I am new to Appian. I have a user input form and a pre-populated database. What I want to achieve here is, after the user submits the form, in the process model, both sides of the data will be checked, and if the data matches, the process model will generate a specific document including those data Thank you in advance
Hi, all! I just prepared my site to get data nd put It inside a ri! to send to a table at DB, i tested at model process and just worked good, but when I try to do on the site give the follow problem. Can someone help? I really need make it works.
Hi Champs, I have a portal having milestone section. I have a landing page and once user click the "Start Application button" in landing page, the milestone starts. In each of the page, I have a option to proceed next, back and cancel button. There are some mandatory fields in each of the pages without which the page won't proceed ahead and gives the validation message. It's working fine; but there is one issue. When I am cancelling the form, it's coming back to landing page and then when I am clicking next, automatically it's showing the mandatory field validation without even user clicking the next button. How can I reset it, so that it will only show the message when user click the next button only. Regards, Ghanashyam
Can we extract data from sail code to java code:Example : Sailcode present in xml file under definition tag <definition>a!localVariables( #"SYSTEM_SYSRULES_sectionLayout_v1"( contents:{ #"SYSTEM_SYSRULES_richTextDisplayField"( value: { #"SYSTEM_SYSRULES_richTextItem_v1"( text: "Click here to display Case(s) Information", link: #"SYSTEM_SYSRULES_safeLink"( label: "Company web site", uri: "">http://www.appian.com" ) ) } ) } ) )</definition>into java object to get data of text : "Click here to display case)s) information", link label :"Company web" , link uri :"http"//wwww.appian.com"
local!excelFormatFromFile: readexcelsheetpaging( excelDocument: ri!excelFile, sheetNumber: 0, paginginfo: a!pagingInfo(1,1), numberOfColumns: 11 ).data.values[1] Hi, How can i achieve same result using index function instead of using ".data.values[1]"
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.