Discussion Categories

I have a data type for a SQL view TOS_CMS_VW_ClergyTitleStatusTypeDSE.  It contains fields describing various clergy members.  I want Clergy Id and Clergy Full Name in a lookup on an interface.  ClergyID is an integer and ClergyFullName is a text field. I created a constant for the data type and I am not trying to create a expression to pull the two fields I want for the dropdown, ClergyID and ClergyFullName. a!queryEntity(  entity: cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE,  query: a!query(    selection: {      a!querySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyId)),      a!qyerySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyfullname))    },    pagingInfo: a!pagingInfo(      startIndex: 1,      batchSize: 500,      sort: a!sortInfo(        field: cons!TOS_CMS_VW_Cle

i have date column in database  it holds the values like  01/02/2024 06:29 GMT+00:00 17/03/2023 17:59 GMT+00:00 but i have to fetch only date which is equal to today date how can i achieve that

When we use Builders in interface , It will create Interface with rule inputs of given CDT or RecordType , I'm really curious to know how they creating variables dynamically(My guess is that they are running some java code in background) . As far as i know we can't create rule inputs dynamically ,If not correct me. Is there a way to create rule inputs of desired type dynamically??. I created a replica of Builders using functions like keys and runtimetypeof(), But i used local variables in value and saveinto parameters. I want to replace it with proper rule inputs.

Hi Good AfternoonIs there a way we can use a card as button to navigate to a page like we do on the desktop with a!safeLink().The link it self will probably open a browser in the mobile, but I want to redirect inside the mobile app.

Hello everyone, I need a bit of help for an accessibility task in Appian. I require a parameter that identifies an element as a <nav> tag and an Aria-label type parameter when viewing the code of the 'Site' in the HTML console. I've tried with parameters like 'accessibilitytext' and 'helptooltip' but it translates to <div> and without that essential parameter, 'Aria-label.' How can I achieve this?

Hi! I was trying to pass a local variable values (editable grid in which you can add several rows) to a process model, so that I can use the Write Records Smart Service At first, I did it this way: But I would like to know how to transfer this and save into my record (probably best way via process model) The entire code is: a!localVariables( local!grid, { a!sectionLayout( label: "LÃ%ADneas Factura", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de factura correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutH

Hi, I have a requirement to create a dynamic table in pdf , now i am using plugins DOCX from Dynamic table  for this how to create rule can anyone suggest, thanks

Hi all, Is there a way or a plug-in that allow us to expose some appian functions? Let me explain the scenario: We have an application that is highly configurable, at some point we need to give a group of more experienced users the ability to be able to assign certain values to certain fields, besides being able to assign static values "1", "2", "3", "TEST", "EXAMPLE","OK" ,etc (for say something), we want to give them the ability to use functions to calculate differently the values using functios like Sum(), AVG(), etc. or for calculations with dates AddDays(X), today(), etc. Is there any way to expose those functions that we use in SAIL in some way to the end user? Thanks in advance for your help

A cancel button has to save one rule input and one local variable value. If we click on the button once only the rule input changes but the local saving happens only after 2 nd click. If we remove the rule input then it is working. But we need both ri and lccal variable to save its respective values at the first click of button. PFA for the code snippet. Help me on the solution a!buttonWidget( label: cons!PHSREC_BTN_LBL_CANCEL, style: "NORMAL", value: 3, saveInto: { local!currentPage, a!save(ri!buttonAction,cons!PHSREC_BUTTON_ACTION[6]) }, validate: false, showWhen: local!currentPage = 1 ),

I have a card layout as below. Can anyone help If there a way for the button to not have that extra space before and after the rich text no matter what magnification or resizing of the screen is shown. a!columnLayout( contents: { a!cardLayout( tooltip: "Only Assigned Status Tasks will be processed", contents: a!richTextDisplayField( align: "CENTER", value: { a!richTextItem( text: "ACCEPT TASKS", color: "ACCENT", style: "STRONG",

Dear Community, Good Afternoon.. I have built a case management app based on a tutorial named "IT Ticket Journey". But, due to some issues, i was unable to create a record. Attached screenshot of the error for your reference Request you to kindly look into this and guide us to a solution and also where i went wrong during this  process ?

 i want activity name in different rows if i have 5 activity name then come in five rows , like above activity i am using doc to pdf plugins is there any way to archive this thanks 

We initially developed our Application on cloud and now we setup the complete database at on-premise and I was not able to connect from cloud Environment. Need help ?

Hi all, I'm trying to use a single dropdown list to add multiple users to my grid, right now when I Select one it saves it, but if I select the dropdown again it will overwrite my first selection, how can I over come this? Basically I want to select -> save , select again -> save and so on.

Appian 23.2 We have MariaDB as a default Database. We have our SQL Server Database hosted in AWS. Can someone please provide me with the steps to create a new Data Source? Can I directly go to Admin Console -> Data Sources ->New Data Source -> Add SQL Server Details? or any additional steps that we have to perform? Thanks

Hi Team, users: "username1; {username1; username2}" =>type text how to get the output as 2 items username1 {username1; username2}

Hi All, Is Spell check is possible in Appian? Regards,Sandeep

Hi All, I'm getting an error when I'm trying to write multiple rows to the database at the same time. When I only give one item to the process variable it works just fine, but when is multiple it throws this error. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table . I have everything correctly set up to accept multiple already, such as the process variable and the write to database smart service. any ideas of what could it be?

a!gridColumn( label: "Conformance", sortField: "adherence", value: a!richTextDisplayField( label: "Adherence", value: { a!richTextItem( text: if( rule!INO_isBlank(fv!row.adherence), "-", fixed(fv!row.adherence, 2) & "%"/*text(fv!row.adherence /100, "##.##%")*/ ), link: a!dynamicLink( value: fv!row.employee, saveInto: { ri!selectedEmployee, a!save(ri!selectedEmployeeRow, fv!identifier) }, showWhen: and( and( not(isnull(ri!showDynamicLinks)), ri!showDynamicLinks ), fv!row.adherence 0, not(or(fv!row.employee.isTeamLead)) ) ),

Hi All  I have successfully configured a single sign-in solution that is working perfectly for our clients. I am also configured Attribute Mapping like Create New Users Upon Sign-In and Update User Attributes Upon Sign-In it works fine, but when it comes to Group Membership Synchronization I add one group(AD Test) in Azure Ad in which one user will be added and the same group added(AD Test) in appian under the group type (A Brand) when i try to access the appian With that user credential, I am successfully get the acess the appian  but no user will be added to the appian group(AD Test). Could you help with what I did wrong here? 

Hi Everyone, Is there any alternative to the executive stored procedure smart service which is depricated?

I am working on a project where I want to use or() function. While using the or() function I found one bug when you write any word starting with the letter "T" in the or() function you will get a true return and for any other word then "T" returns false. I am adding some images for more clear discussion. in this, I used random words starting with the letter "T" using words other than the "T"

"I've been providing the correct file path to the 'Open Excel File' action in Appian for a robotic task, yet I keep receiving an error indicating an incorrect filepath. Has anyone else run into this problem? I'd be grateful for any advice on how to troubleshoot and resolve this error."

I am trying to remove user (System Admin) from all the groups he is part of by using "Remove Group Members" and "Remove Group Admins" in a process and running it as MNI one for each group but still the user was not removed from any group at all.I made the PM lane as Run as whoever designed this process model and I am also a sys Admin but still the Smart service is not working.Am I missing anything here?

I am looking to hire an appian developer to build a BPM app on my website, to model, publish, and view simple process maps. if anyone here is interested and can provide sample work please let me know how to contact you. i can discuss it further on a zoom call.