General

All Respected Members, From the last few days, I have been facing issues while replying to threads or posting new thread. My genuine reply or threads are getting marked as Spam or Abuse. Are you also facing a similar issue?  Please share your experience. I hope this will resolve quickly and members able participate actively in the community. Note: I am posting this from my other account. I am not able to create/reply thread from the original account due to this issue.

Hi everyone, After importing the data from excel the values of date fields present in the excel are storing as null values in the datastore and in database too. Any help here. Thank you.

Hi, Can we have startProcessLink when writing expressions for record title in header 

I have been working on improving the performance of my interface, and I came across some performance results that I don't understand. I have a local variable (local!initialData) that calls an expression rule. I have a second local variable (local!dataCapture) that is just a copy of local!initialData. Looking in the performance tab of the interface, both of these local variables take the exact same amount of time to evaluate (+/- 1ms). However, I would expect local!initialData to take longer than local!dataCapture since local!dataCapture is just copying the data from local!initialData, not running the expression rule. Can anyone explain this to me? Is this to be expected, or am I doing something wrong to cause this to happen? I have attached an image of the performance numbers for these two local variables and have included the definitions of both below. Thanks in advance! local!initialData: a!forEach( local!orderLineData, rule!SSTH_initialData( orderLineData: local!or

Getting expression error - " User does not have sufficient privileges to perform requested action" I have one group when we add a user to that group getting the above error.and the same user when we add in another group not getting the error. and this error only occurs in higher environments, the same functionality works fine in lower environments. Checked group security, and properties and it's the same as the lower environment.

We have recently implemented Syslog streaming on our Appian platform.  The log file is reporting a TLS handshake failure. We've been able to successfully use Curl (sample command below) to connect to the syslog server.   We've done an end-to-end packet capture while doing this curl and can't see any evidence of a TLS handshake error.  The certificate we use is a wildcard certificate (i.e. *.oir.qld.gov.au), but Appian support have confirmed this is acceptable.  Examining the packet capture, we can see both a client and server hello, and both are successful.  Because of this, I suspect the error lies within the rsyslog setup on my syslog server.  Sample Curl Command that reports a successful connection   curl -ilv OIRPSENTINEL01.oir.qld.gov.au:6514 Setup of rsyslog.conf on our Syslog server --------------------------------------------------------------------------------------------------------------------------------------- # rsys

Hi, I have a record title in header, the record title is using a record field called 'projectName', if user want to have an edit option beside the projectName in header so the projectName can be updated directly in header. How can I implement this?

Hi All, Suddenly, the environment became very slow and then completely inaccessible. Upon checking the Tomcat logs on the server, we discovered an OutOfMemory error. We later found out that performance testing had been conducted in this environment, which is not intended for load testing. need some help to recover the environment Thanks in Advance , Udhaya

hi,  I am looking to get the start date and end date for all weeks given a month and year. I am learning Appian, I could see some functions in documentation that needs a date. The other way i could think around is write a procedure in the backed and call it , which will add overhead. Any ideas or suggestion will help. 

I am using Locust with Appian to do performance testing. When I am trying to find a link using the options provided in Locust documentation, I am getting the message as "No components with label field_name not found" or "No components with type "record link" found on page. visit_record_type(record_type="Add Start Date")click_button(label="Add Start Date") click_grid_plaintext_record_link(column_name = "Add Start Date") visit_and_get_form("WAR Audit")click_button(label="Add Start Date")click_record_link(label="Add Start Date")click_record_list_action(label ="Add Start Date")click_link(label="Add Start Date") click_record_link(label="Add Start Date") click_record_view_link(label="Add Start Date") click_record_link_by_index(index=1,locust_request_label="Add Start Date")click_grid_rich_text_link(column_name="Add Start Date",row_index=0, grid_labe

When a new task email is generated for a group, it is sending 2 different emails for the users in different time zones. For example people in PST are not copied in the email sent out for EST and vice-versa. Is this an expected behavior? 

We have an application that on a flow assign a series of task to a series of users or group. In this case we have a user that shared to another user  (for internal policy the second one dont have to see, and dont see, the specific set of data related to the task, but this isn't the problem)  The problem is that even the specific task was assigned to a group where there isn't the second user (that have received the task link) if that user use the link, it can see the task. Why? Are there some restriction that i can apply? Obviously we talk about task in report and not in tempo.

can someone answer this question. what are the data management techniques in appian As I am new to appian and this is the question that i have faced in an interview

I am not able to publish portals in appian comunity environment and also not able to create service accounts , can this things be enabled in future.

Hello everyone, In our Appian setup, we are utilizing SAML within Azure to embed Appian interfaces into an Azure application. We've encountered some issues when attempting to call the Microsoft Graph API, so we decided to create a Bridge API in our Azure application and make calls to it directly using the existing browser token connection. When I log into the application using SAML and then open a new browser window to call our Bridge API, I receive the expected data. However, when using a!httpWrite for a POST request to retrieve the API information, the response only returns an HTTP 200 confirmation code without any actual data. I assumed that no additional authentication methods would be necessary since I'm already connected to the application. Has anyone faced a similar issue or can you suggest anything I might have overlooked? Thanks for your help!

I was wondering if obtaining Appian certifications (Analyst and Developer) is a prerequisite for establishing a partnership with Appian. My company has a vast history in developing systems and applications for a wide variety of clients and organizations. Additionally, we possess substantial experience in low-code environments such as Oracle APEX. Is the certification a compulsory requirement for the partnership. can anyone please clarify the specific requirements and certifications needed to pursue an Appian partnership?

Hi there, I am trying to create an expression rule that returns true if a document is not null, and has an ID attached to it. The expression rule is used to determine an XOR node to go to the document deletion node to delete the document if it exists, or to move to the end node if it has already been deleted. Right now, I am using a plugin isObjectExists() and it does work correctly but my supervisor wants me to improve the code to not use that plugin, any ideas for what to do?Here is the expression rule I created, it currently works how I want it to but I want to avoid using the plugin, any help is appreciated!

Hi All, I have grid displaying certain records for a specific user, lets say I want to calculate how many days did it take the user to create the next record so for example in the image attached the user created a few on the same day, so if I wanted to add another column next to this one to display number of days, how can I achieve this? the calculation part? because I need to grab the first date of the previous record with the date of the next created record and so on . Is this even possible, or what are your suggestions on finding this kind of information? Thanks in advance

Hello everyone, I'm new to Appian and I want to know if the user record type exists by default in any Appian application. I need to configure a 'create user' node in my process model, so do I need to create a user record manually?

Its mentioned that a site can contain upto 5 pages which doesnt seems to be a valid statement. Can someone guide

DELIMITER $$ CREATE OR REPLACE DEFINER=`dbadmin`@`%` PROCEDURE `FAR_STAGE_BP_IMPACT`() BEGIN UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_IBOR_BP_IMPACT_DATA tna ON (cod.FUND_SYMBOL = tna.ACCT_CD_FMRID) SET cod.IBOR_TOTAL_NET_ASSETS_USD = tna.MKT_VAL_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.IBOR_TOTAL_NET_ASSETS_USD,0) = 0 THEN 0 WHEN cod.DEBIT_CREDIT = 'Debit' THEN CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * -10000), 0) AS DOUBLE(10, 4)) ELSE CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * 10000), 0) AS DOUBLE(10, 4)) END WHERE tna.ACCT_CD_FMRID IS NOT NULL and cod.REC_TYPE = 'IBOR'; UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_ABOR_BP_IMPACT_DATA tna ON (cod.FUND_NUMBER = tna.ACCOUNT_NUMBER_IO) SET cod.ABOR_TOTAL_NET_ASSETS_USD = tna.TOTAL_NET_ASSETS_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.ABOR_TOTAL_NET_ASSETS_USD,0) = 0 THEN 0

Hello I have created a stored procedureDELIMITER $$ CREATE OR REPLACE DEFINER=`dbadmin`@`%` PROCEDURE `FAR_STAGE_BP_IMPACT`() BEGIN UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_IBOR_BP_IMPACT_DATA tna ON (cod.FUND_SYMBOL = tna.ACCT_CD_FMRID) SET cod.IBOR_TOTAL_NET_ASSETS_USD = tna.MKT_VAL_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.IBOR_TOTAL_NET_ASSETS_USD,0) = 0 THEN 0 WHEN cod.DEBIT_CREDIT = 'Debit' THEN CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * -10000), 0) AS DOUBLE(10, 4)) ELSE CAST(IFNULL(((cod.USD_EQ_Amount / cod.IBOR_TOTAL_NET_ASSETS_USD) * 10000), 0) AS DOUBLE(10, 4)) END WHERE tna.ACCT_CD_FMRID IS NOT NULL and cod.REC_TYPE = 'IBOR'; UPDATE FAR_BREAKS_STAGE cod INNER JOIN FAR_ABOR_BP_IMPACT_DATA tna ON (cod.FUND_NUMBER = tna.ACCOUNT_NUMBER_IO) SET cod.ABOR_TOTAL_NET_ASSETS_USD = tna.TOTAL_NET_ASSETS_USD, cod.BREAK_BP_IMPACT = CASE WHEN IFNULL(cod.ABOR_TOTAL

Hi everyone, I'm encountering an issue when performing searches on a RecordType through an interface. The searches work perfectly for all columns except for one that is of type date. I’ve tried changing the format to match the database format (yyyy-MM-dd), but even then, the search returns no results when I query by that date column. Does anyone know why this might be happening or how I can resolve this issue? Thanks in advance! a!gridColumn( label: "Fecha", sortField: 'recordType!{...}.....fields.{....}fecha', value: text(fv!row['recordType!{....}....fields.{....}fecha'], "yyyy-dd-MM"), align: "START", width: "AUTO" ),

Getting below error when opening "Summary Page" in Studio site of Case Management Studio. We have not changed any object in Case Management Studio applications manually. Can anyone help with this? Expression evaluation error [evaluation ID = 265c9:30306] in rule 'cmgt_cb_studio_displaybuilder' (called by rules 'cmgt_cb_sitepage_casetypes_caseview' > 'cmgt_wfl_sitepage_casetypes') : Invalid index: Cannot index property 'targetRecordTypeUuid' of type Text into type List of Variant

Is there an option in Appian that may allow me to mass delete rule inputs placed in my interface in Appian? There seems to be no option but having to resort to deleting each rule input one by one which is a little time consuming.