General

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.)  

I am having the below array configuration as output, but I only want 4 array of List Of Document with each having 50 items.

Hi, everyone Which options is better for system setting

I am trying to move a application from Dev to UAT. When I do inception, I am getting below message No missing precedents or warnings detected null of item(s) will be created/updated. null of item(s) will be skipped because no changes were detected. Skipped objects may have identical definitions but different version histories. All version histories will be synchronized on import. Any help is much appreciated... Packagae size is 2 MB

I am having date and time of submitted form in Date time format.I want to compare the date and time if it exceeds 1 hr from submission I want to show a proceed button. How I can give a condition where it is comparing submitted form have completed 1hr 

Hi Members, Am getting below Issue. Can someone help how to resolve it. Data store write operation(s) had an average response duration over 2000ms (High) and 10 data store write operation(s) had an average response duration over 1000ms (Medium) - CDT has a dependency on over 40 objects.

a!localVariables( local!userDtl: rule!GAI_GetUserDetailByUserDetailId(id: ri!userDtlId), local!userAddr: rule!GAI_getUserAddress(userDtlId: ri!userDtlId), local!address: rule!GAI_getAddress( addressId: tointeger( local!userAddr['recordType!{95223579-776a-485d-b38c-eeaedbe5930a}GAI User Address.fields.{42a88eac-f478-4bf9-a8da-e8c5e666ed11}fkAddressId'] ) ), local!userRoles: a!refreshVariable( value: rule!GAI_getUserRole( userDetailId: ri!userDtlId, isActive: true() ), refreshAfter: "RECORD_ACTION", refreshAlways: true() ), a!formLayout( contents: { rule!SCO_CommonHelpText( helpText: "User has been deactivated in the system", isError: true(), showWhen: not( rule!SCO_isUserActive( local!userDtl['recordType!{1a68a647-eb88-4f12-be8e-e3d5fc6495eb}GAI User Detail.fields.{d07378d8-ee37-479d-a6e4-06adfb5bdd15}username'] ) ) ), a!columnsLayout( col

Hi All, I need session timer on user input task like there is one interface, in that user can do three activities but if in certain time user does not click on any activity then it should show popup as do you want resume this session is it possible to do in appian? thanks in advance.

why does it mean ID NOT FOUND ?