Discussion Categories

a!columnChartField( label: "2012 Tempo Usage Trends", categories: {"2012", "Qt 2", "Qt 3", "Qt 4"}, series: { a!chartSeries(label: "IT", data: {9, 4, 3, 2}), a!chartSeries(label: "Human Services", data: {8, 3, 2, 1}), a!chartSeries(label: "Sales", data: {12, 6, 4, 2}), a!chartSeries(label: "Marketing", data: {15, 7, 3, 5}) }, colorScheme: "SUNSET", xAxisTitle: "Quarter", yAxisTitle: "% Active", showLegend: true) Can we get this column graph with record centric feature

So I was practicing new skill of document Extraction , but I am stuck at one place while I am trying to run a script task for code below  so I am targeting value to isValidate variable as my all values is true then too isValidate Variable is showing false and I checked my XOR decision too but I guess something is wrong with Script Task can anyone pls suggest me best Practice For this [emoticon:c4563cd7d5574777a71c318021cbbcc8] and I am using Cdt    

Hello - I am trying to test creating a FHIR compliant JSON payload to send to hapi.fhir.org/Patient.  Here is what I done so far. created an expression to create the JSON payload: concat( "{","""resourceType""",":","""Patient""",",","""name""",":[{","""use""",":","""official""",",","""text""",":","""Brian Doe""",",","""family""",":","""Doe""",",","""given""",":","[","""",tostring(ri!firstName),"""","]","}","]",",","""gender""",":","""male""",",",""&qu

At first, Dropdown values already submitted. In second time, We may need to change the option So Can we load a dropdown with a pre selected text value that was submitted earlier and again select a new value from dropdown

I have some nested CDTs, like a nested in b, b nested in c, I want to cast it to recordtype with relationship, like C has one-to-many relationship to B, B has one-to-many relationship to A. All fields are mapped, how can I cast?

We have a requirement to see the cases on dashboard based on some criteria.  This criteria is defined in a table called user access details. Details of all the cases are present in one record. How can we apply these user access details values as filters inside another record to get the values?? Note: For a single user, there can be multiple user access details, so there will be multiple rows. Each row need to be applied as filter to the record. Screenshots have been added for reference. First image refers to user access details, second one refers to data table When User A logs into Appian, they should see only caseid 1001, when user B logs in they should see only case 1003. How can we achieve this using Records?? We already tried using record level security, but here we can define only static values. But, in our scenario we need to define dynamic values which will be varied on logged in user.

Hi there, I wanted to understand what the differences between these 2 are. Data fabric seems to be relying on record object for what it does (from self-service analytics to AI Copilot, please add if I missed on any other offering), and hence would share the same limitations too? As for unifying data across different systems, that's something record has been doing for some time. So, what exactly does DF offers besides SSA and Co-pilot that wasn't already offered/done through Record object?  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b8ea18cfbb2e4f6d841cf3c1d4d7420b:e9ed411860ed4f2ba0265705b8793d05] [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05] [mention:dea33493db6342c9a73dc108d45120c0:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

I am migrating Appian instance from 20.1 to 21.2. Post migration, I am receiving error is starting the Data Server. Log file  name : Wachdog.log Per Log: The data server historical store (hs) folder and snapshot(ss) are not empty which is the case ( as it is migrated) but some how lastTxOffset  value is found to be -1 which indicates log should be empty. Error stack {"level":"DEBUG","time":"2021-06-24T02:43:39.333Z","logger":"watchdog","caller":"KafkaConsumer.java:2181","thread":"main","msg":"[Consumer clientId=consumer-1, groupId=dataserver-consumers] Kafka consumer has been closed"}{"level":"ERROR","time":"2021-06-24T02:43:39.333Z","logger":"watchdog","caller":"Watchdog.java:1194","thread":"main","msg":"Shutting down with exit code 1..."}

I am getting this error "Cannot sort by field [teamMemberId] because it is from a one-to-many record relationship." when trying to apply sort field gridcoloumn a!gridColumn( label: "Members", sortField:recordType!WFM RID.relationships.wfmRIDmember.fields.MemberId value: count( fv!row['recordType!WFM RID.relationships.wfmRIDmember.fields.MemberId'] )

hi all,,, i have an editable grid interface in which when i choose a dropdown value for "subsidiary" field, the other 2 fields(businessunit and objectamount) will get autopopulated values..i need to add  multiple rows  also,,but when clicking on add row button,,iam getting error message like this: Expression evaluation error [evaluation ID = a5ba0:92723] in rule 'i2cemea_editablegridbookingfssc' (called by rule 'i2cemea_genericwriteoffform') : An error occurred while executing a save: Expression evaluation error at function 'append' [line 123]: Insert is not supported for I2CEMEA FSSC Booking Info types CODE: a!localVariables( local!Subsidiary: if( a!isNullOrEmpty(ri!companyCode), 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'(), rule!I2CEMEA_QR_getMWGLAccount(companyCode: ri!companyCode,processType: ri!processType).data ), local!bussinessUnitorObjectAccount: if( a!isNullOrEmpty( ri!bookingFSSC['recordType!{0

HI team, i want to find the type of extension and Size of list of documents and i have used document function and build an expression rule it is working fine in expression rule as expected when i call that expression in an interfcae  it is shoowing error as document function is deleted.  a!localVariables( local!size: a!forEach(ri!documents, document(fv!item, "size")), local!extension: a!forEach( ri!documents, document(fv!item, "extension") ), toboolean( and(and(reject( fn!isnull, { a!forEach( local!extension, if(fv!item "pdf", false, null) ) } )), and(reject( fn!isnull, { a!forEach( local!size, if(fv!item > 5000000, false, null) ) } ) ))) ) when i use in interface getting error as shown below

Objective is to display the firstName of all active users. a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{firstName}firstName', filters: a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{active}active', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)).data ref {user() Function - Appian 23.2} throwing below error  Expression evaluation error at function a!queryRecordType: The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried because it is a service-backed record type.

Hi All, I am using a date time component inside the interface. But it also accepting the special characters if we enter manually. After submitting, it is displaying the system date. Eg: I gave 12/06/2024* 5:00 PM. After submitting it is displaying system date and time. Is there any way to restrict the user entering the special characters inside a date time component or show any validation message based on some condition.  It would be very helpful if I could able to achieve Thanks

Hi all,  I have seen that the decodeJWT function of JWT Tools plug-in returns the decoded token but only if the signature is valid, otherwise it returns null. This function needs jwks url to retrieve the proper public key and validate the given token.  Does anyone know if there is a way to decode a JWT without validating the signature? It is possible to decode a JWT with a private key stored in scs? Is there any other plug-in to create and validate JWTs? Thanks in advance. 

Hi, I'm calling MsGraph API from Appian in a two steps methop, I have to send the content-length from the previous integration as a header information in another call. How can I capture or insert into a variable an http request from an integration? Or are some way to calculate the content-lenght? Regards

Hi folks, can we configure another URL masking for a particular site in an environment?current URL: www.abc.appiancloud.com/suite/sites/mysite another URL: www.abc.com/mysite.

Hello, Can anyone help me in this: How to hide these categories text(Qt1, Qt2, Qt3, Qt4) from column chart? Also, numbers/range(0-100) from y axis column? Note: For this column chart configuration, I am using records. Thanks

Hi All, I recently came across this issue while using the write records smart service to update a single specific column(eg: textCol} for an existing record. I'm using the recordType constructor to specify the primary key value and using a pv value for the other column. So my input to the write records looks something like this:  {recIdPk = 1, textCol: "newvalue"} Instead of updating the column (textCol) with the given value for the existing row I get the below error (screen-shot attached). So from my understanding this error should not be coming becoming as this not null column already has a value both in the db table and the record object and I'm not looking to update that field hence not specfying it in my above recordType constructor. I have a total of 15 columns in my table of which two columns have a not null constraint and are already populated from a separate location (using write records itself). I'm only looking to update one specifi

We have a requirement to call web API which uses Bearer Token authentication type and it requires client id and secret in the Header. Before calling this API we need to get the access token using oAuth endpoint, this endpoint has authentication type as Basic Auth and it requires same client id and secret in the Header. 1. For OAuth endpoint, we have created a connected system (A) with the Basic Authentication using username and password. - Works fine. 2. For the primary API, we have created another connected system (B) with the following information. a. Base URL: <Base URL>. b. Authentication: None 3. Created an Integration object which uses connected system B and has following parameters in the Headers. a. Authorization: <Token received in step #1, passed as rule input> b. X-IBM-Client-Id: <client id, passed as constant > c. X-IBM-Client-Secret: <client secret, passed as constant> The above setup works fine however as per our secur

Pls answer the below question 1.What is the difference between Entity Backed records and Process Backed records?

The page I am testing has a line chart with a download icon on it with the tooltip Download PNG Image, but I am unsure how to have my FitNesse script perform the download. I see support for downloading charts was added to FitNesse for Appian November 2023 - Release 23.4, but I don't see in the Cheat Sheet or documentation how to download charts.

Hi everyone After reading this sentence, I wanted to know more, so I would like to ask a question.  [mention:a776b956d9da49b1bbfb78dfc99430ac:46448885d0e64133bbfbf0cd7b0fd6f7]  How can i map a view with record type. As a result of investigation, I was unable to map View to RecordType. Thanks

Hello devs, I need your help. I have two records: 'account' and 'transaction', and the 'balance' field of 'account' varies based on the value of the 'Amount' field of 'Transaction'. I've added conditions to update the 'Balance' (in the saveInto function) when the user clicks 'Create transaction' and it works well in the interface the field in my ruleInput record has been updated, but the update isn't happening at the database level. How can I dynamically change the balance on my site based on the value of the 'Amount' field of the transaction record?

Configure node as mentioned in HERE  for Execute Stored Procedure Smart Service but getting following error. I have created SP in SQL server and tested successfuly but couldn't call from processmodel. Error: No procedure found with name  procUpdateDWAZipCodeParameter. TIA !

Scenario: The user started the process and before process completes  user  left the bank .The sub process got errored because  assignment of  nodes is 'run as whoever started the process'. In this scenario , do we need to change assignment of that node to 'run as designer of  the process'. in the production and restart the instance , or any other Approach?