Discussion Categories

Was the issue with Appian being unable to select the scheme in SQL server for recorded types/data stores resolved in 23.3?   Is there an ETA when this issue will be resolved.   This really slows down development on my team and makes appian much harder to use if you are pointing it to a database that has multiple schemes on it.  

Hello, I need to improve the accessibility of an interface that includes grids. In HTML, the "caption" tag can be used to provide additional description or context to an element, such as a table. However, I can't find a direct way to achieve something similar in a grid in Appian. My question is is there any way or recommended approach to add additional description or context to a grid in Appian?

Hi All, We have a scenario to extract data from PDF. In interface we have a screen to upload file and on submit starting a process using a!start process to extract data from that file. It is working fine from developer mode. when we add that screen to site document is not passing to that process, we are getting error like invalid content ID. Thank you. Priyanka

Hi everyone, i wanted to learn rpa so working on some poc, i have taken a simple example where i am logging into some website doing search and try to fetch the search result into process variable. i got the following error. what is the solution for this error?

Hi All, Scenario is we are connected to a PostgreSQL that has a custom data type, from which we we're able to create a CDT on Appian end and manage to verify it on our Data Store. for the custom data type on Postgre, we transform it to a text and it went well. However when doing a specific query to that specific field, thats where the issue persist. Can you advice on this? Data on Postgre Error when doing a query on the specific field

Hi! I have an interface in which the user can add new Rows. When the user clicks the "Completar creacion pedido" button, the values stored in my local variable are correctly passed to my rule input "recordLineasPedido".  I leave here my structured code: a!localVariables( local!LineasPedido, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutHeaderCell(label: "Importe Total"),

DB view associated with CDT but don't have primary Key. We used DB View in a!ExportDataStoreEntityToExcel to extract data(20k Records) into Excel File and getting an timeout Error. Is there any way to apply Composite Key for few columns on CDT to extract data to Excel without errors ? In Appian Best Practices mentioned that there is a way to apply composite key but no example. If anyone knows the solution please replay here. Thank you.

Hi, all -- I am working on a mock-up with an editable table that is not hooked up to any database. I want to make one row unselectable while keeping the other rows able to be selected. Is there anything I can put in the expression to achieve this effect for UI purposes only? Thanks. 

Hello All, I have successfully configured a single sign-in solution that is working perfectly for our clients. However, we have a new requirement from our clients. They want to implement a process where a user added to a specific group on the Azure AD side should also be automatically added to a corresponding group on the Appian side. These groups will have the same name and purpose in both environments. To elaborate: - Azure Group: [ABC Accounts] - Appian Group: [ABC Accounts] The aim is to ensure that any user added to the specified group in Azure AD is seamlessly added to the corresponding group in Appian without manual intervention.  Please provide guidance on the steps required to set up this automated user synchronization and any best practices to ensure smooth ongoing operation. Thank you for your attention to this matter. Please let me know if you require any further information from my end. Best regards,Prasad

Hello, As shown in the screenshot below, I am able to get a ASP.NET_SessionId in HTTP Response instead of getting it in Result. In such a case how do I save it in a global variable and use it as a header input for another integration to fetch data from the other system API.

Hi Team, We have a requirement to upload/download the documents into the shared folder from appian. Could you please suggest. Thanks

Hello everyone,  I am getting a base64 value as a request. But I am unable to convert the base64 value into an image document. As a result record is not getting stored into the database table. Is there any way to convert the base64 string into document?

We are hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

Actively hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

Hello Community,Can someone help what is going wrong here, I am trying this in Appian community edition ? Receiving this error Expression evaluation error at function 'groupprofilerecordtypesource': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB failure trying to convert typed value TypedValue[it=1474,v={TypedValue[it=1478,v={{{id,id,1}}}],TypedValue[it=1358,v={AND,{}}],{1,1,<null>}}] to java class com.appiancorp.common.query.Query.groupprofilerecordtypesource( query:a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: {}, ignoreFiltersWithEmptyValues: true() ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: a!sortInfo(field: "name",ascending: true) ) ) )

I have two process variable that is CDT type. I need to if any of the process variable is null then related to that process variable entity data not executed. Like this:  = {    if(    a!isnotnullorempty(pv!dependencies),             null,    a!entityData(             entity: cons!DSE_COMMUNITIES,          data: pv!communityAllocation  ) ),     if(    a!isnotnullorempty(pv!dependencies),             null,           a!entityData(               entity: cons!DSE_DEPENDENCIES,               data: pv!dependencies    )  )} But it gives error: An error occurred while trying to write to the data store [Tables]. No values have been written. Details: org.hibernate.PropertyVal

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column.I want the date & time .here is my table on UI: here s the column in db: here is the CDT column: and here is the csv column:

Process Model is using Plugin, but throwing error "This Application uses MSGraph Plugin components and its throwing error by saying "User Does Not Have Rights to Perform this Operation" The user is not administrator of application? Is it required to be admin to run process model with plugin? User is part of "Process Model Creator " group.

Should able to Select only one radio button from the grid as shown in the below attachment. a!radioButtonField( label: "Sort On", labelPosition: "COLLAPSED", choiceLabels: { "Yes" }, choiceValues: {true()}, value: fv!item.sortOn, saveInto: {local!sort, a!save(local!sortIndex,fv!index), a!save(index(ri!input,"sortOn",local!sortIndex,{}),true())}, choiceLayout: "STACKED", validations: {} ) How to achieve this please suggest.

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( and(local!input1[fv!index] =1, local!input2[fv!index]=1), 1, 0 ) ) ) )

Hi All, We trying to connect to an external connection from another system. Though we are already connected, the tables we are looking for is not there. Upon checking, there are more than 2 schema available on their database, the schema that the tables we want is not the one showing on the recordType "choose database table" instead the other one. Additional Info, when creating a CDT and verifying it on Data Store, other schema and its table cant be map ( "no match table found"), however its verified for all tables under the schema that is appearing on recordType "choose database table" Can you advice if this support is on Appian Admin, or is it on the external side system to make the correct schema adjustment to be selected as default. Thanks

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( or(local!input1[fv!index]=1, local!input2[fv!index]=1), 1, 0 ) ) ) )

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( local!input1[fv!index] =local!input2[fv!index], 0, 1 ) ) ) )

Hi, Can someone help here... We have a database with a user credentials in a table. Will Appian allow us to access the site just by checking whether user credentials is there in the database table or not

How to get two search fields in the OSM map component to search the route from a start location to an end location?