General

HI Team, i was created the application like naukri, in that mentioned mobile number and data type is int/text also tried size is 20, when i enter the values 10 digits its getting error "The value provided is too large" i was rechecked and changed all the details and while testing after modifications i  below, and its pointed to data source can anyone please help me on that find the below code { a!sectionLayout( label: "Record", labelSize: "MEDIUM", labelHeadingTag: "H2", labelColor: "STANDARD", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "First Name", labelPosition: "JUSTIFIED", value: a!defaultValue( ri!record['recordType!{4f1af93e-2c0f-45a9-989b-904063aa4d46}ND Record.fields.{a4ccef83-8dc6-4fe5-875d-92719c90cf6e}firstName'], "–" ), readOnly: true ), a!textField( label: "Last Name", labelPosition: "JUSTIFIED", value: a!defaultValu

Dear heros of the appian community:currently trying to extend knowledge about "egde cases" of appian Is there any way, that i can call an interface dynamically by a DB value in the sense that:i am storing a UUID or name of an interface component and by calling the value of rule!EXA_recordtype.interfaceNamethe interface is shown. example code snipped I know ,this exact way, it is not working like that due to the exclamation marks etc. just thinking through and to show the route i am coming from.there are ways of choose() etc. I know. but its about not having it "hardcoded". kind of totally based on DB values..Is something in that sense/manner possible?Love to read your inputs

Hi All, We have small requirement like need to replace/substitute the places holders in string with values. a!localVariables( local!template: "Hello, {name}! Welcome to {place}.", local!placeholders: { "name": "John", "place": "Appian" }, a!forEach( items: a!keys(local!placeholders), expression: a!localVariables( local!placeholder: fv!item, local!value: local!placeholders[local!placeholder], local!template: substitute( local!template, "{" & local!placeholder & "}", local!value ), local!template ) ) ) which returns the following out put like  List of Text String - 2 items "Hello, John! Welcome to {place}."(Text) "Hello, {name}! Welcome to Appian."(Text) Need to replaced all of them in single string with some sequential manner. Your expertise is helpful to solve. Thanks in advance.

I need to redirect the user from an existing application(in React) to the appian application using OPEN ID Connect SSO, I have already made the settings by integrating Appian via Open ID Connect(AWS Cognito), and appian provided a callback url https://{my-url-here}.appiancloud.com/suite/oidc/callback I would like to authenticate the user in another application using the same OpenID Connect client and redirect the user to Appian without having to log in again for example: https://{my-url-here}.appiancloud.com/suite/oidc/callback?token={token-generated in another application} is this possible?  

Hi there,    I have created a table in the DB with a default value of current timestamp for a dateTime column. However when i try to write to it using a CDT the default column is null. Table structure.  CDT definition. Any help would be appreciated [emoticon:c4563cd7d5574777a71c318021cbbcc8]

How to pass a pv! as value for content in Create PDF (smart service) plugin? in Process model   I can pass a few words as value using this code which I got from community, ={ 'type!{urn:appian:ps:pdftools}PdfContent'( page: 1, xPercent: 10, yPercent: 10, angle: 0, sections: { 'type!{urn:appian:ps:pdftools}PdfSection'( style: null, components: { 'type!{urn:appian:ps:pdftools}PdfText'( value: "Some" ), 'type!{urn:appian:ps:pdftools}PdfText'( value: "text" ) } ) } )} but I try to pass a pv! as value into the contents I got this error  is there any possible to pass a pv as a value in this code 

Hello,  I am running into an issue when using the Convert binary request body to Appian document feature of Web APIs. The file is being placed into the document folder I have specified correctly as well as maintaining the correct name and extension.  The content of the file is not being decoded from Base64. When I download the file from the document folder, the contents are the Base64 string that I passed into the Web API. Any help would be greatly appreciated! Nick

Hi, I have been struggling hard with this error and am not able to advance any further due to this -  SLF4J: See www.slf4j.org/codes.html for further details.2022-06-08 00:15:04,429 [main] DEBUG com.appiancorp.ps.automatedtest.fixture.BaseFixture - browser=Chrome2022-06-08 00:15:04,588 [main] DEBUG com.appiancorp.ps.automatedtest.common.FixtureMetrics - userid=6b3309e9a657297a1b45fd39925f3bd966261ac9488a1325a97873142d450e93, pipelineDimension=Standalone, testingFramework=FitNesse Step failedjava.lang.NullPointerException: Cannot invoke "org.openqa.selenium.WebDriver.get(String)" because the return value of "com.appiancorp.ps.automatedtest.common.Settings.getDriver()" is null at com.appiancorp.ps.automatedtest.tempo.TempoLogin.navigateToLoginPage(TempoLogin.java:225) at com.appiancorp.ps.automatedtest.fixture.BaseFixture.loginIntoWithUsernameAndPassword(BaseFixture.java:435) at com.appiancorp.ps.automatedtest.fixture.BaseFixture.loginIntoWithUsername(BaseFixtur

Is there a way to get group type Id by group name?

can someone suggest how to implement like this table in the interface. displaying headers only not getting.

Hi Everyone, We have Reassign, Reject , Accept buttons provided by default in Appian. It is inside a User input task. Since it is a default button we couldn't able to run any rules or write any code to store the value for the buttons. Eg: If we click on "Accept" button tp!owner is changed but we can't store the value in a table. Similarly if we click on "Reassign" and "Reject" the values are captured in task level but we can't store the value in a separate table. Is there a way to capture the actions in the backend or generate any report for admins or others to know the actions performed by the user? Thanks

Hi Experts,We have a requirement to get files from SFTP server and put in Appian Doc repository.The input we have received from client is that these files size can vary from 1MB to 1GB as there are multimedia files as well.What will be the recommended approach for meeting this requirement. Is it going to cause any impact on the performance of the server or not.What if total size of the files being moved to Appian doc repository exceeds 100 GB.In my assumption we will have to consider our existing cloud storage and request for extra if required. Is there any other server level configuration needs to be done and how can we manage memory in this case? Thanks.

I have a list of integers from 1 to 100 and i want 30 random numbers from that list how can we do this?

Hey developers, I would like to send an email to a client if their balance reaches a limit. How can I do that? Is it possible to set a condition on the balance in the interface definition and then trigger a process model that sends the email?a!localVariables( local!emailSent, local!button :false(), a!sectionLayout( label: "", labelColor: "#000", contents: { if( ri!account['recordType!{b37748b2-8103-41ea-8028-2b358e4f229c}PBY account.fields.{4a9de4b2-f127-44f1-86d2-21c2a6b2ee2d}Solde'] > 20000000, {}, { a!buttonLayout( a!buttonWidget( label: "Voir détails", value: true, saveInto: { local!button, a!startProcess( processModel: cons!PBY_sendEmail, processParameters: { account: ri!account, }, onSuccess: a!save(local!emailSent, true),

I have a bar chart driven by a recordType which displays the value of each bar.  What happens is that these values are being placed on top of the bar for the longest bars. I'm surprised that Appian does not automatically adjust the color when it overlaps the text onto the bar.  How do we get the text readable both overlapped and not overlapped? One easy answer is to use a lighter bar color.... However, I am required to meet WCAG AA color contrast between the white background and the bars.  This means the bars have to be a dark color. I have found that I can adjust the Y-axis maximum value to force the bars to be shorter which keeps the labels to the right of the bar. The challenge with this solution is that the range of possible values is theoretically infinite (practically within about 10-ish years).  The only way to know what the current max value would be to query the recordType ahead of time, add some buffer value to it, set the Y max to that value.&nbsp

I'm evaluating BPM/Decision Engine solutions to integrate with our in-house built platform and I like much of what I see in Appian: its SAAS, so I don't have to host it, it has a lot of documentation and a broad user base with very active support forums. But, I can't tell if they want our business. They don't list any pricing that I can see, and won't respond to my "Contact Us" requests. Is this really just for large enterprises?

Curious if any other practitioners are running into issues with Oracle 12.2 and it's use of editionable views? Currently running Appian 23.3, we are upgrading a business Oracle database we connect to from version 12.1.3 to 12.2. With this version of Oracle, the best practice is promoted no longer reference base tables. Instead, editionable views are automatically created to utilize and this is what is mandated by our Oracle teams, via a synonym pointing to the editionable view on the table. Appian (at least in my current version 23.3), does not seem to support the use of synonyms in this new fashion, as in the past we have always used synonyms within Oracle to satisfy data store validation and operation, for objects residing in different schemas, etc. With Oracle 12.2, these editionable views are created automatically from the first 29 characters of a table name such as below: Table: ORACLE_TABLE_NAMEView:  ORACLE_TABLE_NAME# This practice forces changes to the original synony

Can you disable dates in a datefield based on a date? That is, disable calendar dates starting from a specific date

Hi team, We have a requirement to fetch the data from FTP server where the file exceeds 100Mb size or more and we have to store all those files(100GB) into Appian Folders. We are storing the files to display in grid and then download the file whenever required. Is it recommended to store all those files into Appian, If not what is the best way to do so? Thanks.

Hello Everyone, I have recently completed all of my Appian Release showcase trainings and got a revised validity date on my Associate Developer Certificate. Can anyone please suggest how I can download my Associate Developer Certificate with the latest validity date on it. (Also I'm not able to find my old Appian associate developer certificate) Please guide. Thanks & regard

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?

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