Foundation

HI All , I have ModifiedDt stored in MSSQL Server with DateTime format , when i query the same Date in Appian it shows a slight difference in millisecond . I am guessing Appian round's off this value ? Is this correct ? Does anybody else observed this issue ? Examples below - Database Appian

We have several Appian applications with records backed read-only grids which our business users can quickly search, filter, page through to access record instance data. One of the main gripes (over the years) with Appian is that while paging and taking an action on a record, the user has to page back through a series of data sets to arrive where the user initially started the action from. Honestly, it's a bit surprised a paging cache feature hasn't made into a default platform offering in Y2024 but would the Appian community be able to provide examples of how we can implement a "cached paging paradigm" to improve user experience. It's definitely a slight annoyance platform-wise but I'd prefer to hear your opinions and implementation thoughts on how best to improve a one-less-click experience.

Currently we have a site that has several pages at the top in the Header bar. However, one user is unable to see these pages unless they are in incognito mode indicating this is not a permissions issue on Appian's end but a chrome setting that must be hiding these tabs.  We tried opening the site in both chrome and edge and both fail to load the site pages. The whole Navigation bar shows up for that user including the Logo, we are just unable to see the site pages at the top. I am Creating a post to see if anyone knows of this issue and a potential fix?  Thank-you so much for your time. 

When we execute the API Endpoint to load the data in DB, we get Generic Error Message " 500 There was an error writing to the data store"  Is there a way to capture the Actual Error message and Return it as a message instead of the above? Example:  Details: javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value Following is the code :onError: a!httpResponse(statusCode: 500,headers: {a!httpHeader(name: "Content-Type", value: "application/json")},body: a!toJson({error: "There was an error writing to the data store"}))

How to convert Unicode characters to emojis. Our process saves the emojis to Cloud DB as "utf8mb4_general_ci". I want to show them as emojis on the richTextFieldWithTables

I tried to complete a user's task via Chrome browser by adding a signature using the a!signatureField. But the signature gets disappeared after it's drawn. Does anyone know the root cause and a solution for it?

Currently getting expression evaluation errors in a rule and without resolving the problem currently (no time to at this moment and no issue to client), I am wanting to reduce the number of alerts I receive a day. Like if it errors 10 times in a day, I don't want 10 emails, but one email with all the errors that occurred that day maybe? 

I have a Record Type that has 2 Record List Actions.  Web Browser shows both entries and on a Mobile device only the first one displays.  I confirmed this on an iPhone. I also noticed that if you have more than one Record List Action it moves the actions below the filters. Are these expected behaviors? On a Web Browser: On an iPhone:

Hi, I have an interface where I have few buttons. These buttons I have created using a a!buttonArrayLaoyout, a!buttonWidget. Now, when the user clicks on one of the button, I need to calls a "recrodActionItem". Can someone advise how I can do this. Thanks

Hi, using local variable, i am calling expression rule, which gives category codes as output, now i neeed to convert this local!updatecategorycodes into array form to use contains() function. can anyone please help me local!updateCategoryCodes:index( rule!CNAM_qeGetUpdateCategoryCodes(), "CATEGORY_CODE", "" ),

I have a requirement to filter negative values from readonly  grid and It needs to get configured from expression rule but Im not able to filter the negative values. I tried using "<" as operator for that particular field but still not filtering out. please help me achieve this

I tried upload the template(Doc) many times after editing those not working fields plenty of times  but still the fields seems like above

Hi All, Why do we get this type of error in Process Model while writing to the data base? How Do I Check this issue in more detail, When  i don't have system logs to check the logs? Can SomeOne Please suggest ,It would be more helpful if anyone replies and Provide me the solution. Thanks In Advance.

All nodes and sub-processes are completed but this process instance somehow got cancelled, can anyone advise what could be the cause?

Geeting this error when used SP that returns datasubset for populating grid. Can someone provide more info on why this issue is coming up. UI Code a!localVariables( local!variableName, local!selectedSource, local!selectedCategory, local!pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 10 ), local!categories:index(rule!OMS_getPreSelectCategories( ),"data",{}), local!sources:index(rule!OMS_getPreSelectSourceTypes( ),"data",{}), local!mdmVariableList: a!refreshVariable( value: rule!OMS_SP_getPreSelectVarsByFilters( variableName: local!variableName, source: local!selectedSource, category: local!selectedCategory, pagingInfo: local!pagingInfo ), refreshOnVarChange: { local!variableName, local!selectedSource, local!selectedCategory } ), a!cardLayout( style: "TRANSPARENT", contents: { a!columnsLayout( columns: { a!columnLayout( contents: a!richTextD

Hi All, I have a record type process variable  - MAC User (list), This record type contains the list of users and their information like name, email, last name etc.  I'm trying to create the users within appian with the Create User Smart Service, but since its a list is not allowing and its throwing an error, do I have to do a loop for this? I was thinking the smart service could create more than one user at the time. If looping is the only option - can someone recommend what would the best way? thanks in advance

Hello Folks, I am getting this error while write to Data store entity.:"An error occurred while trying to write to the data store. No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value :" Can anyone help me on this? Actually I want one column in a table is non nullable that is also behave as a foreign key. Thanks

Hi team ,recently I have created a new account to learn Appian again, its a free version, in this I  am not  able CDT, DSE objects and also not able  to create them. Also not able to access the MySQL Database.

a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Next", size: "LARGE", style: "SOLID", saveInto: { if( len(ri!checklists) > 1, { a!save(ri!steps, append(ri!steps, "name")), a!save(ri!nextStep, 3) }, { a!save( local!showAddChecklistErrorMessage, true() ) } ) } )

Hello, I am developing a small application in which employees of a company can book their desks/seats in the office. I have started designing our office seating arrangement using an interface where I used rich text icon to display the desktop and chair. As it's normal in any office that the seating can be facing towards any direction. To visualize it, I have to rotate the icon I'm using now. I googled it out but it's of vain. Appreciate your suggestions. Regards Nehemiah /resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/_B930AF30EA30FC30F330B730E730C330C830_-2024_2D00_10_2D00_23-153805.jpg

lets say im passing the id as 1 to 1000 range for example , as there is no document with that id it will show error right 

Hi everyone, I was tasked with creating a process model to rename users using the rename users smart service. I only have the Start Node, the Rename Users node and End Node. I have multiple questions that I need answered that can hopefully help me get started as I am unable to find the guidance I need in documentation and other threads. Here are my questions: What other nodes do I need/should I have? When configuring the Rename Users Node what do I put for "Value" and "Save Into" for Inputs? For the Rename Users Node how should I configure the Outputs? I would also appreciate any other reference material you all might think is helpful. This is all I've found so far, and it wasn't enough to help me get started: Rename Users Smart Service - Appian 24.3 

Requiremnt: When user clicks on "Add Grid" then an editable grid should be added and when the user clicks on "Add Row" then a row should be added to the respective grida!localVariables( local!count:1, local!data:a!forEach(items: enumerate(local!count)+1, expression: {{a!map(text1:"",text2:"")}}), a!sectionLayout( contents: { a!forEach( items: enumerate(local!count)+1, expression: a!gridLayout( label: "Grid"&fv!index, headerCells: { a!gridLayoutHeaderCell( label: "H1" ), a!gridLayoutHeaderCell( label: "h2" ) }, columnConfigs: { a!gridLayoutColumnConfig( ), a!gridLayoutColumnConfig() }, rows: a!forEach( items: local!data[fv!index], expression: a!gridRowLayout( contents: { a!textField( label: fv!i

Hi , I am trying to implement: On Click of Dynamic Link displaying one Grid, But AS per the requirement This needs to be displayed as side By side, As of Now On click of Link the grid is displaying but How would I make side By side grid, Since grid has box Layout and Grid Field ,Ui is throwing error . How would I make change in this code -On click of link grid has to be displayed. a!localVariables( local!priority: false(), { a!linkField( /*label: "Link Field",*/ links: { a!dynamicLink( label: "Audit History", value: local!priority, saveInto: a!save(local!priority, true()) ) } ), a!sectionLayout( contents: { rule!CR_APP_SC_auditDetails( cif_int: ri!cif_int, sectionName_txt: cons!CR_APP_TXT_AUDIT_SECTION_NAMES[1] ) }, showWhen: local!priority ) } ) 

I have inactive some value from table because of that this error is showing i want only active data in choicevalue i don't want inactive value. inactive value is showing because some inactive data is already save in somewhere so how we can handle this error i have already query data with isActive true.because i want only isActive data not inactive