-
Recently active
Hi All, I had created one interface for opening email using mail to. The code for interface is as follows a!columnsLayout( columns: { a!columnLayout( contents: { a!cardLayout( contents: a!richTextDisplayField( align: "LEFT", labelPosition: "COLLAPSED", value: { a!richTextIcon(icon: "envelope", size: "MEDIUM"), a!richTextItem(text: " ", style: "STRONG"), a!richTextItem( text: "CONSULT SUPPLY CHAIN", style: "STRONG" ) }, /*align: "CENTER"*/ ), link: a!safeLink( uri: "mailto:" & "pradeep@xyz.com" & "?subject=" & "High Risk Material Test Email" & "&body=" & "<html xmlns:v=urn:schemas-microsoft-com:vml xmlns:o=urn:schemas-microsoft-com:office:office xmlns:w=urn:schemas-microsoft-com:office:word xmlns:m=schemas.microsoft.com/.../omml xmlns=www.w3.org/.../REC-html40> <style type=te
Hi! I'm trying to use the "Log Reader" pluging to read the login-audit.csv logs through expression rules, but it doesnt work. According to the comments on the pluging it seems that this is a common failure, so does anybody knows how to make it work or any other way to store this information on the Appian Database?
I am trying to create a file having all groups excluding the default groups. Default groups are the groups which are added to user account whenever any user is created like APN All Users, Application Users etc. I have created a constant with default user and trying below. a!localVariables( local!groups:rule!UAGR_getAllGroups(), local!groups1:cons!UAGR_Default_Roles, expression:union( rule!UAGR_getAllGroups, cons!UAGR_Default_Roles ) )
Hi! Does anyone know how can I increase the rolling period for getting the login-audit.csv zipped using the log4j configuration? right now is a month and I need it to be three months.
I am using the Cucumber for Appian package along with Junit4. For running the tests in parallel I am using the surfire plugin parameters provided in https://cucumber.io/docs/guides/parallel-execution/?lang=java#junit-4 During execution although multiple instances of chrome browser are opening in parallel, the rest for the steps are being executed on a single browser. Looks like each browser instance is not thread safe. Anyone faced this issue or are able to successfully run tests in parallel?
it apparently has no permissions, however it works when on interface, but it doesn't on the site. All permissions were conceded. This error message in instance details only happens when using the site itself. But when using the interface it doesn't. The S3 node simply doesn't access the document through the process model Any thoughts on it? Thanks in advance
My goal is to produce an excel file from a set of Clergy Pension records. My plan to do this is: 1. Create an CDT to hold the data for the excel spreadsheet 2. Create an Expression Rule to create the data for the CDT 3. Use the Expression Rule in a Process Model to populate the CDT 4. Use the Export Data Store Entity to Excel smart service in the Process Model My problem is with the Expression Rule, In the Expression Rule, I create two local variables; data and report. The local variable holds the results of the query and the local variable report is formatted data for storage into the CDT. To create the local!data, I use a!queryRecordType() to pull the records I need. The data comes from several tables and I use the Relationships from the main table of the query, CPMA Clergy Pension. I filter and sort the data. Here is the code for local!data. local!data: a!queryRecordType( recordType: 'recordType!CPMA Clergy Pension', fields: { 'recor
I have the UI which loads the record type data in Read only grid. I used 3 filters to filter the records from record type in the Grid. In my requirement, I need to delete the filtered records from DB on "Delete" action, Anyone knows how to assign the filtered records displayed in Read only Grid to the local variable. Where i can use that record set to delete. Or any other suggestion to delete the filtered records.
We are trying to use the Export Data store entity to CSV smart service to generate a CSV which then gets SFTP'ed to an external location. We have a scenario where if there datastore entity doesnt return any rows, the CSV automatically generates a CSV with the header rows and the second row contains the text - "No data available due to empty data source, applied filter/selection criteria, or fields visibility". Is there any way we can have the CSV exported without this text in the second row? I dont find any options in the smart service setup, but if any of you have a non hacky way of working around this scenario it would be great.
Hi, we need to centralize the opening of an incident (on an external system) following an error found within the Appian platform. From the documentation it emerges that it is impossible to recover the information of a process that has failed in an unhattended node. In the various support functions the tasks with problems are counted, but the unhattended nodes are not shown. Furthermore, the process status is active. Is there some method that we have not taken into consideration? Unfortunately Appian Support was unable to resolve this issue.
In our project each person has a QR code generated and stored as an image in Appian. I have to generate a single PDF out of "N" number of selected persons QR Code images by having them side by side and a page can have max of 18 QR codes. Please see the attached image for the expected document.Any idea how to achieve this? Thanks in advance.
Hello Folks, Please anyone guide me on this? I am using below code and getting this error: "Cannot mul incompatible operands of type List of Variant and type List of Variant." Basically I am multiplying two values. Any thoughts on this? a!textField( label: "", labelPosition: "ADJACENT", value:product(index(ri!case, "amount", {}), index( ri!case, "newamount", {} ) / 100), readOnly: true(), ),
This post is regarding a feature request I want to make. The feature is about being able to click on a hyperlink and able to navigate to that section on the same screen. Like how we have on websites where clicking on something scrolls the page and takes the user to a certain section. Similarly, something like a!sectionLink that takes the section label or some identifier as input and takes the user to that section on the same page. This would be helpful when there are dense interfaces or long interfaces having a lot of scrolls. And as portals come into the picture, this can also be very well used on Appian portals as they are expected to have long scrolls.
I'm trying to use an OIDC connection to my Amplify page (Via AWS Cognito), but I'm getting an invalid nonce error. Is it mandatory to use nonce? I'm ignoring him on my page org.springframework.security.oauth2.core.OAuth2AuthenticationException: [invalid_nonce] Can someone help me?
Hi Team, Can anyone please help me with regex to replace every number in string having following with space. $ € CHF EUR USD Example 1. Test 2121k$ test data :--> Test test data 2. Test 2121k€ test data :--> Test test data 3. Test 1000k CHF test data set :--> Test test data set 4. Test 1000k EUR test data set :--> Test test data set 5. Test 1000k USD test data set :--> Test test data set Thanks Bihitak
Hi Everyone, I have a requirement where I need to sort the grid on page load based on Priority . Eg.we have Critical, high and low priority. Critical priority cases will come at the top followed by high and low. I have given priority in initial sorts. In addition to that I have to sort with latest id on page load. So I have given both id and priority column in initial sorts so that it will sort on page load. This is working for the grid when the data source is coming from record. So the latest critical cases will come at the top since we have provided both id and priority in initial sorts. I have another grid where the data source is from process report. There I could able to provide only one initial sort(either id or priority). It is not working as expected when I provided two initial sorts(i.e Id and priority). Is there a way to provide multiple initial sorts for the grid where the data source is from process report. I need to sort both the columns on page load. Please help me to ach
Hi All , I am trying to get fibonacci series with the following rule .But getting unexpected output . Let me know where am I doing it wrong . TIA
Student Student Year Subaject A score Student1 2021 100 Student 2 2021 100 Student 3 2021 100 Student1 2022 90(-10) Student 2 2022 80(-20) Student 3 2022 70(-30) Student 1 2023 95(+5) Student 2 2023 70(-10) Student 3 2023 78(+8) Hi Everyone, I need to achieve this in read only grid, each consecutive year how much marks difference is there with the previous year need to be shown in the bracket Thanks In Advance
Hello Team, What will be the simple and easiest solution to implement a comment section for each request. I was thinking to create comment record table with comment text, comment by, comment date and requestId which will be linked to my main tables with one to many relationship. Then create interface with one button which stores all that information in rule input pass it to the process model and then for each of these comments which are associated with the request id to pull them in the interface? Is that something possible not sure how to implement this or if there is any simple approach. I was thinking that I won't be able to use any notification like that, since preferred method would be to send notification to the users which was already commented the request or at least to the person who requested it, since I have requestor field in my main table which store the request information. Thanks for all suggestions!
Hello all, I have a question that I think it should be easy but I cannot figure it out, and also I cannot see any response in this forum. If I have a a!forEach within another a!forEach, is there a way of refering to the items of the outer loop, within the first loop? Example to understand with non real data: I have two lists: local!text: {"1111 - GREAT", "1000 - BAD", "5600 - MEDIUM"} local!words: {"GREAT", "MEDIUM"} as you can see, "text" is a list of text, and each string contains a code a "-" and a word. I want to create a nested loop that returns a list with the codes only when the words contained in the list "words" are in the list a.In this particular example: {"GREAT", "MEDIUM"} because "GREAT" is included in "1000 - GREAT" and "MEDIUM" is included in "5600 - MEDIUM". I woud like to iterate though every item of list &quo
I have a non-synced REST API that I am using to fetch data via an integration. This endpoint supports paging. In both the record data source and the integration, when I put a a!pagingInfo(x, y), in the pagingInfo test inputs, the data increments through pages correctly according to the values I give for x and y. But, in the data model test listing and the record list URL, the first 50 records appear (as expected) with the correct record total (more than 1,000), but when I click the next button, the next page is blank and says "No items available". I can click the previous button, and the first 50 records display again. The Paging Info drop down on the data model page is mapped to the correct rule input on the record data source. The Appian version is 23.2. Here is my code for the dataSubset in the record data source: a!dataSubset( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, totalCount: local!integrationResponse.result.bo
When I click on a button, it will generate a comment and we are saving it in a comment table. In particular scenarios, when we click on the same button, it will generate multiple comments and we need to save it in a comment table itself. So how can we handle in appian?
I want to loop through a list of 'Course' CDT and increment the local variable named progresspercent by 25 each time I encounter a Course with status "completed". E.g. a student is enrolled in 4 courses and 3 of them have "completed" status, the progresspercent variable should be 75 in this case. Following is a snippet of my code and a picture of the output I am getting.Can you please help me figure out how I can do this? a!localVariables( local!progresspercent: 0, { local!progresspercent, a!forEach( items: rule!ID_GetCourses(ri!collegeid), expression: { local!progresspercent + if( fv!item['recordType!ID course.fields.status'] = "completed", 25, 0 ) } ) } ) /resized-image/__size/640x480/__key/communityserver-discussions-components-files/16/Screenshot-2024_2D00_06_2D00_14-at-6.30.24_2F20_PM.
Hi all!Once we create a record via Web Service, we will be creating a Connected System along with Integration, now Appian creates us a new record data expression with a single rule input -> ri!batchNumber. Now, lets say I have a web API which has more than 2,000 rows of data. Now, at first iteration the batchNumber will be 1 and in next iteration the batchNumber will be 1001 i.e for each iteration our start index ---> 1 + ((batchNumber - 1) * batchSize) Now, do we have to handle this manually or Appian handles by itself ? i) Could anyone send me a sample working record data source expression code that handles the paging Info.ii) Do we need to handle this pagingInfo in the Integration also? A sample screenshot would be appreciated for both Integration and Expression
i'm fresher for appian and I have configured FitNesse as shown below version 21.1 While click on test i'm getting the below error Any one knows the steps to reslove please help me.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
