Foundation

https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-44228 Is Appian affected by the log4j vulnerability CVE-2021-44228?

Hi All, I have a local variable defined within load() which retrieves data from one of the table using a!queryentity() . local!data: rule!getAllData(id) Whenever there is an insert or update happens in the table , local!data pulls the new values on performing a refresh of the page from the browser . My requirement is that i dont want to query the table again even though i refresh the page from the browser . Basically i want to retrieve the data from database only once when the task is generated .  Please can you help me with this problem. Thanks in advance .

Hi,I have a requirement, where the client need to customize Appian Login Screen,if anyone who has worked on it, could you plz help me on this.Change the login page from the default Appian login Page to the standard Organization authentication page (For Example: when I log into workday, or myLearning or other... I get the screen attached to this ticket).Can the login page be specific to one application??

Hi Team, QueryEntity is not fetching data correctly, below is my code: a!queryEntity( entity: cons!TEMP_TABLE, fetchTotalCount: ri!fetchTotalCount, query: { a!query( selection: if( rule!APN_isEmpty(ri!columns), {}, a!querySelection( columns: a!forEach( ri!columns, a!queryColumn(field: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "clientId", operator: "=", value: ri!clientId ), a!queryFilter( field: "requestorName", operator: "=", value: ri!requestorName ), a!queryFilter( field: "engagementNumber", operator: "in", value: ri!engagementNumber ), }, ignoreFiltersWithEmptyValues: true() ), paginginfo: if( rule!APN_isEmpty(ri!pagingInfo), a!pagingInfo(startIndex: 1, batchSize: - 1), ri!pagingInfo ) ) }).dataIn the test output, it is returning the result as infinity symbol for a particular column which is number(integer), shown below: My table in the backend

I am facing below error on task submission: Previously, this issue was not occurring. We have checked the security for all the related objects. Everything seems to be fine.

Hi All, I am currently using Export from Datastore entity to Excel Smart service.  There are a total of 100 columns in the table and I am splitting approximately 30 columns into each sheet, making upto 3 sheets of data in same excel file. Uses 3 smart services for exporting data into 3 sheets of same excel. In first two sheets, column header is in plain format, But in third sheet column header is showing up as bold. I am unable to find out why one sheet is showing bold header. Can anyone help me how to make the column headers in all 3 sheets into same styling format (Either plain or Bold). NOTE: I am not using any predefined template to update, the new document generated by 1st Export from Datastore entity to Excel Smart service is used to update in the next smart service. The data gets updated in the another sheet, not in the sheet which already has the data. Thanks

I have taken one radiobuttonfield in my interface after clicking on update button in interface it should convert it into textfield. if anyone knows about this please help me out of this

Actually is this for me or somebody also facing this 403 error? 

Hi, Can someone help me here. Line1 code in the below attached image is giving proper expected output (Email). Where as Line2 is returning an error. Any idea what went wrong.

How can we save calculated value in rule input without user interaction in field ??

So, i have a date that cannot be > than today(), so i have a validation field. But when I enter a wrong date, the validation field triggers but it saves the save value into my rule input. It is possible to don´t save the value if the validation field triggers?

The interface for my grid field has all it's data queried before losing connection and stored in a local variable. Then for the grid field's data parameter, it's getting it from the local variable. I have this interface as a start form in a process model, so I may make it an Action on a site. When I test this out on mobile and disconnect myself it stops working. I followed the guide in Appian documentation not sure what I'm doing wrong? Is it because it's not a form, I even gave it a cancel button. 

Hi Team, I have 2 interface one is parent and another is child interface. From child interface i am submitting the form and found that value is not passing from child to parent. I am using same rule input for both parent and child. help me on this to get the solution. Thanks,

I want to write an expression rule to compare values of a rule input and value from a db table field.If the values are same ,then one of the fields(column) of my db table must be set to inactive or 0.

Hi , saveInto is not working for the below code a!paragraphField( label: "Comment", value: ri!comments, instructions: "(" & 255 - len(ri!comments) & ")", saveInto: a!save(ri!comments, save!value), refreshAfter: "KEYPRESS", validations: rule!PDR_validateTextOnSize(enteredText: ri!comments, size: 255), required: true(), readOnly: false() ) when I write anything in paragraph field the value is not save.

Hi guys,  I think I am close to the solution, but I've been stuck with this for a while and figured asking cannot hurt. I am creating an interface which is supposed to show the user data from another User Input Task and have them confirm it has been input correctly. For this I use a read-only grid which I configured according to the Appian tutorial. However, it displays the data in only one row, albeit separated in the pre-defined columns (so e.g. it will say for Underlying "Underlying1; Underlying 2" in one cell). The data is pulled from a CDT as a rule input. It contains "flat" data like single booleans, but also arrays. For this exercise, only arrays are concerned. Do I have to manipulate the data beforehand or am I missing something major? My code: a!gridField(  label: "Fixing Levels",  labelPosition: "JUSTIFIED",  data: ri!product_cdt,  columns: {    a!gridColumn(      label: &q

Hi, Is there a way to use local variables in a rule that is used in reduce function When called from UI? When Using from UI it says that I need to configure  refreahalways for the local variable ..... Thaks in advance, Gil

Good morning, We need to have a webApi that receives a document and a json input with other data in the body. I have been reviewing the document upload template of the webApi and in the body it only lets you add the document.Does anyone know if what I need to do is possible? Greetings and thank you

Hi I am working on Appian version 21.3. I have created an extraction process referring to the below link: https://docs.appian.com/suite/help/21.3/create-doc-extraction-process.html The process looks like this in my case: The CDT is: My concern is, out of all the values only 2 values are extracted and 1 value is semi extracted. The PDF file I have created manually. Want to understand why all values are not extracted despite not much values are there in the PDF. PFB the Appian Reconcile form that pops up as a task for me: Thanks in advance!!

Hello, I have a use case where we need to store the email directly on a service like S3, without parsing. I'm trying to come up with a solution for this and I was wondering if the Receive Message Event allows capturing the .msg file to store it. Our use case will imply some kind of parsing (e.g, body, from, etc.) but we also need to come up with something that allows us to store the raw data. I already explored some options in AppMarket but couldn't come up with a clear solution for this. The event only seems to allow some kind of manipulation with the data and that's OK for us, but we also need the raw information. What can we use to achieve this solution? Kind regards

i am trying loop through the each row in the excel but foreach is not working .

Hi Team, We need to show four tabs in our site's homepage and all the tabs are different interfaces which are interlinked. The first tab/page is a action whose context is a process model with a startform. How should i configure it in the 1st tab page. Below is my code for tabs UI: So here I am trying to call the process model for first page with a!startProcessLink but i is not working. Can anyone please suggest what should be done here? Thanks.

hello, I'm currently on Appian version 21.3 and i want to upgrade to 21.4 can you please help me, I don't have any experience in upgrading appian version 

Hi, I am trying to populate a filter using FitNesse for Appian. The filter seems to be inside a frame, I am able to verify that the user filter is present but when I add script to populate record type user filter, it returns error that it could not find the filter.

We recently noticed a issue in production that the excel is populated with random duplicates for any record intermittently. User is filtering out the data on SAIL and clicks on EXPORT button. We can see the filtered data in the excel but few records are duplicated in excel which does not exist in view or SAIL. We ran the query entity explicitly to determine the data and it is correctly retrieved as per the filters applied. So there is no pattern as such to figure out why this issue is occurring. And this is only observed in Production and not in lower environments. As we are not manipulating the data anywhere, I am guessing the issue must be with the view, especially with primary key. We are currently guessing that the issue might be with the way smart service is sorting out the data based on filters applied in excel report. We are using Export DSE to Excel smart service. We are using a view with SELECT ROWNUM ID and mapping this ID as Primary Key with @ID annotation on CDT. But we are