General

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?

Hi Everyone, We have one functionality as we are validating the data in excel and load the data into db. I uploaded file with 1500 rows and 129 columns each row will have, I am getting below error when i try to upload 1500.   The System Has encountered an error, An error occured while processing your request.  but when i found in server log below is the one,Can anyone of you please mention what is the below error stating? which size it is mentioning as 200,000,00? APNX-1-4532-000,"Expression evaluation error: Max compression size exceeded. Max size=200,000,000, actual size=257,715,470",,0000e69f-7bc4-8000-9844-3d4d983d4d98,,,,SITES Thanks in Advance!!

I want to have a readonly paragraph field with a scroll bar, so when text is long it can be scrolled within a box rather than displayed all in the page. How can I do?

 hello , j'ai besoin d'aide s'il vous plait .Je voudrais traiter cette partie : lorsque l'utilisateur dépose des documents, au moment de la visualisation, les documents PDF doivent être compilés dans un seul visualiseur de PDF. J'ai utilisé la fusion de PDF dans le modèle de processus avec ce code dans l'interface qui s'appel :               projet_docsInterface( fv!item) a!cardLayout( contents: a!documentViewerField( label: ri!record['recordType!**.{c36418cc-1402-4f64-801f-7a433c3ed250}type'], labelPosition: "ABOVE", document: ri!record['****0902-47a3-8490-7833fee28c37}docid'], height: "TALL" ), ) et j'ai fait l'appel de cette interface ici :  a!cardLayout( contents: { a!forEach( items: local!docs, expression: { rule!Projet_docsInterface( fv!item) } ) }, height: "AUTO", style: "#cccccc", shape: "ROUNDED", padding: "STANDARD", marginAbove: "LESS", marginBelow: "S

Hi team,  we have a  requirement to enter a multiple Account Numbers from a Editable grid. but has to validate the entry when there is a duplicate row. I have tried using contains function but not able to solve. please help

HI All, I am using documentDownloadLink to download the document, when clicked on it is routing to another tab and throwing below error

Hey developers, I need some help. I have a folder in which there are documents with an ID and a name. I need to create a condition in an interface to display only a document with a specific name. Is that possible?

I have a button named "Save Decision" on task details page, on clicking it automatically kicks out and returns to the home page(Where all tasks are displayed) and also the task assignee gets changed (to the one who was its original assignee before reassignment) In the code, upon clicking on "Save Decision" we are just saving data to few variables. Tried to debug but could not locate the reason. does anyone know what might be the reason for it ? Thanks

Hello, in a process I am using "Post Comment to Feed Entry", the value of author being passed is a user who is deactivated. This process sometime works fine and intermittently gives me generic error as below- An error occurred while trying to post a comment or hazard to the feed (entry id: [382]). Details: The supplied feed entry [382] is not accessible (APNX-1-4181-100) This is strange behavior, any idea why does it work sometime because I believe passing deactivated user as author should give an error always. TIA!