General

What should I persist in the db to identify a group? I may need to migrate this to another system IE: Dev to Test

how much time difference pp!timezone to IST  which timing =pp!timezone is following

What is the most common use case for an Appian application? A. A reporting tool that uses complex aggregation across different systems. B. A workflow that requires extensive database data extraction, transformation, and loading. C. A workflow for multiple groups that needs to be accelerated while reducing mistakes. D. A backend process that requires management and no user interaction.

Hi All, I have a requirement where I need to merge 2 selected rows in read-only grid and merge them into one row and the displayed name will be the first selected row. Where the whole data related to both selected records will be merged into one.

Hi All I am using getLastLoginDateTime function which is in the below plugin  [mention:f77937a217d845edaa4c53ff358f0f09:f7d226abd59f475c9d224a79e3f0ec07]  But facing weird issue.  below are the code snippet It is working fine without typecase but while typecast it is showing errorNote :- loginDateTime has date and time data type and it is not working for 2-3 users and for rest it is working fine even while typecast.

Hi Team, Currently am writing data to table from stored procedure. Can someone help that what is the best way to improve its performance, Since in Healthcheck its coming as High Risk.  Number of records added is around 4Lakh. 

how many times we can take exam for one registration.  if so how many times? how many days in gap we can take the exam. 

Hi, i'll give any date it has to subtract with today and give me number of days difference ex: inputdate -today= no of days difference, 04/07/2023- today = 7 days which functions i can use to achieve this? suggest me

how to check the user is active or deactivated

Hi, I saw that it is not possible to encrypt an email through the appian smart email service. Although I believe I know the answer to the next question, I would like to ask. is it possible for appian to encrypt an attachment in a zip file and then send it? can it send attachments?  or I need to encrypt the file on my own and then attach it to the email and send it? thanks

i am getting this error while click on related action how to resolve ? An error occurred while applying the context for the GAI Application related action [identifier=125]. Details: The record data does not exist, has been deleted, or you do not have sufficient privileges to access it.

Required is not working for dropdown field in gridrow layout how can i resolve this ? a!gridLayout( label: "", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: ""), a!gridLayoutHeaderCell(label: "") }, columnConfigs: { a!gridLayoutColumnConfig(weight: 3), a!gridLayoutColumnConfig(weight: 3) }, rows: { a!gridRowLayout( contents: { a!textField( value: "Grantee Administrator (Primary Contact)", readOnly: true(), required: true() ), a!textField( showWhen: rule!SCO_isBoolNotEmptyAndTrue(ri!hasUserClickedGeneratePdf), readOnly: true, label: rule!GAI_utilFormatUserName( ri!applnProjectInfo['recordType!{ba1b9bf5-818d-401c-b540-67788e6d7d2d}GAI Application Project Info.fields.{8852265a-0704-4a43-829a-c4828

Hi All, While doing upload of file with filename which contains ; or '     the characters ; and ' are replaced with _ automatically . Other windows allowed characters for file name works fine. Could you please suggest what can be issue or is it a limitation on Appian side or is it a configuration issue or is there a work around to keep the original name Thanks in advance Raj

I have a requirement, which is to query data within two working days. I use process calendar and a!subtractDateTime() to achieve this functionality. I first defined the holiday in the process calendar, and used a!subtractDateTime() to calculate the start time of the query. Code: a!subtractDateTime( startDateTime: now(), days: 2, useProcessCalendar: true, processCalendarName: "MasonTestCal",) & " ---- " & now() The out put is: My account is set up as follows: Questions: 1.Why are the calculated results not different by 48 hours? 2.What are the specific rules for a!subtractDateTime() when using process calendar?

It's just a question out of curiosity. Does Appian provide a way that any solution created in Appian by any partner or organisation can be installed on client's server but still be managed and hosted by solution provider. I mean in terms of exposing the solution's code and architecture, if I don't want to expose my application code, implementation and objects to client but still want to install in their environment?

Hii,  I am getting this error while executing saveinto Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!forEach [line 139]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!paragraphField [line 153]: Invalid index type: Record field uuid: 2a1bfc02-84a2-4226-8519-1a87a180881c Record type uuid: b5dd0e17-b6cf-431f-a6b1-27d0db4b17da Relationship path: [407e0837-118e-4386-9d0f-db23d7df12ba] rows: a!forEach( items: local!section1, expression: a!gridRowLayout( id: fv!index, contents: { a!textField(value: fv!item, readOnly: true()), a!radioButtonField( label: "", choiceLabels: { "Yes", "No" }, choiceValues: { 1, 0 }, /*value: fv!item['recordType!{b5dd0e17-b6cf-431f-a6b1-27d0db4b17da}GAI Ref App Review Question

$value=  ABC 12345 $res_value= 12345 I tried with |populate field with placeholder|Search Tasks                              |with|!{substring($res_value,5)}|It doesn't work

In database view has been created by combining many tables and it shows the results properly. When we use a!exportDataStoreEntityToExcel function to extract the content it fetches only 22k instead of 24k which is shown in view results. Is there any limitations on the extracting content except the column count 50 (ours only 25 columns)?

Hi I have connected Microsoft SQL server data base with connected system - connection is successfulit consists of real time data in employee table I need to bring that table data and store it in Appian DB and should sync the ms sql table and appian db table daily

Hi All, I got one change request, to show the date in "MMM-DD" format for the current calendar year, I think this can be achieved by concatenating two dropdowns (when user selects month in the first dropdown and  second drop down should show days in the months) and  I need to write some code to do that. Can anyone please guide me in achieving the same? Thanks in advance. We are using Appian 23.3 version.  Thanks

Hi Team, I created a Application and I want to add chatbot in that application. Can we do this requirement in Appian? if so what are the steps to implement chatbot.  Regards, J Vinay

I want to generate 24 months based on the given month and year. for ex: if i gave "Nov-23" as rule input i want to get next 24 months list, result something like this {Dec-23,jan-24,feb-24,mar-24,apr-24}. can someone help to achieve this

I have below code. Can someone help how to break it into batches/looping in dynamic way. Its reaching threshold so i need to convert into batches/looping. a!queryEntity( entity: cons!MA_DSE_ABC, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "Name", operator: "=", value: ri!name, applyWhen: not(isnull(ri!name)) ), a!queryFilter( field: "Id", operator: "=", value: ri!id, applyWhen: not(isnull(ri!id)) ), } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 2000) ), fetchTotalCount: true() ),

I have an requirement where i have to add watcher to JIRA from Appian .Just wanted to know how to Add the service account as a watcher 

Hi Team, I have a requirement where I need to convert MNI into batches/looping, since its reaching threshold(MNI has limitation of 1000). Can someone help how to convert . Requirement: I am trying to write data to database via Stored Proc(Data is huge). In advance I don't know how many records am getting to write in database via integration.  I cannot use Record, since its old Application(Business People are not in favor to convert to Record, since it has dependency on 100 objects.)