Discussion Categories

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?

Hi, I'm currently working on an interface where I display data queried from a record type and store it in a local variable. I'm then looping through this local variable to display the content Now I would like to modify my expression so that it only shows 5 records at a time, with next and back navigation buttons to show next set of records, similar to the functionality in a read-only grid. Can anyone please guide me how to achieve this?

Good afternoon, I'm looking for a way to create something similar to this picture. Do you know if there is any component for this? thanks

I am looking for different options in Appian to connect with Mongo DB. Please share your suggestions / experience.

Hi All, When starting the process model again and agian facing below issue can you. Please help to find the best possible solutions? Error when parsing process details or variables Regards Nishtha Bhatnagar

Hi I"m little bit confuse.Which pattern is good design? I created a child interface and call from parent inerface. How to pass button of parameter from parent interface to child interface. when i clicked a button call another process model .how to pass parameter from parent interface to child interface. Thanks

I have a requirement where the processes are scheduled within a range of 12 hours, let's say 3 PM to 3 AM, with a time gap of 1 hour. So my batch process should start at 3 PM but after first instance it should be triggered after every 1 hour till 3 AM. Is there any way we can achieve this using Timer event? Also, I am recording the scheduled date and time in the database. Is it possible to directly get that time and start the process with it? Any ideas how we can achieve this?

Hi all, I'm a beginner of Appian. I usually see a "export excel" button in a record type at the upper right corner, but I could not see it on a record type. In the record type, the following error is shown. "Expression evaluation error at function a!gridField_23r3 [line 51]: The field [b4975317-48bc-4a6d-9ade-949dece38b46] does not exist." In record type, I cannot see expression code, but the error show the code line... How do I see the code in a record type? What i want to do is to export a data into excel... any suggestion please... Best regards,

Currently using a!forEach and a!isNullOrEmpty to replace all null values in an array of integers with 0, but would love to learn the most efficient way to do so. Is apply() the way to go here? A different function? Many thanks for any and all help!

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

Hi everyone, I am trying to fetch archived process instance details based on process model and date. I have tried below approach: - 1.Using find archive smart service which is part of Process Management Utilities plug-in, but the smart service isn't returning any output regardless of the details I have provided. 2.Through log file but the file which is generated in system logs are dynamic (based on timestamp) due to which I am not able to use this approach. Please help me to find a way through which I can fetch archived process instance details.

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 Experts, Need your help to resolve my issue. I want to convert my Text data returned by the Execute Generative AI skill smart service into map/ CDT which afterwards I want to map into a CDT. Here is the text which I am trying to convert into map/dictionary, please help me how to achieve that:  {"IPAddress": "2001:111.111.11101","StartDate": "2024/05/14","StartTime": "06:52:24","StartTimezone": "UTC","EndDate": "2024/05/14","EndTime": "06:54:03","EndTimezone": "UTC"}&{"IPAddress": "2001:222.202.2222","StartDate": "2024/05/12","StartTime": "16:30:55","StartTimezone": "UTC","EndDate": "2024/05/12","EndTime": "16:30:55","EndTimezone": "UTC"}&{"IPAddress": "2001:22ab.111e4b.333",&

I am updating a custom plugin that utilizes the Knowledge Document Type and uses the getInternalFilename() to get the absolute path of the document. That function has been deprecated, what is the preferred replacement, as I still need the absolute path of the document. Would getExternalFilename() return a similar value. 

Hello I'm new to Appian. Very considering to offer solution with Appian.  But I would like to learn more about pricing and terms of Appian Not sure where to find this information? Kind Regards Dan

What is the maximum size limit of process variable in Appian?

How to create a code for Fibonacci series in Appian

Hi Team, I recently configured SAML in Appian, and when some existing users attempted to access Appian via SSO, they encountered a 401 error. I had already added these users to the authentication group, and ensured that the Identity Provider (IdP) username was in lowercase, with both the username and email matching. However, the 401 error still occurred. As a temporary workaround, I changed the username, and when the old user tried to access Appian through SSO, Appian treated the user as new. As a result, the user was recreated because we have the "Create new users upon sign-in" option enabled in the SAML settings. Since we cannot change the username for all users, I am looking for a solution to resolve this issue without modifying usernames. Any help with addressing this problem would be appreciated.  

Our tenant is currently on Appian cloud version 24.2 and experiencing a real-time aggregation error on a custom record field. When editing the custom record field in the record type view, clicking the 'TEST' button displays the following error: ava.lang.RuntimeException: tvJavaBridge is null We have tried removing the relationship and re-adding to no avail. Also, testing the rule in an expression also yields the same result (see screenshots below). Any ideas of what we could try to alleviate the issue?

Hello, I have a doubt and I am unsure how to proceed.   I have an interface where the individual record rows are displayed in a read only grid where I am using the FK of another table to filter and display only those audits for a specific record. The requirement is to display a different background color in the read only grid of the values in the row based on previous entries. For example   FKID Name Temp Approved 1 Tim 20 No 1 Timmy 22 Pending 1 Timmy 22 Yes 1 Timmy 23 Retired Timmy, 22 and pending are highlighted in the second row because they differ from the first entry. Yes is highlighted in the third entry due to being different than pending. 23 and retired are highlighted because they differ from previous also. I have a record query as below and I feel I need to compare the fv!row[currentValue] against the indexed local data somehow but I am not sure how to proceed. a!localVariables( local!data: a!queryRecordType( recordType: 'ADtable',

Dear all, I have a question about a part of my interface. I use a read-only grid component. Scrollbars appear depending on the screen size. I want to implement it so that when moving the horizontal scrollbar, the header rows stay fixed and only the non-header areas move. I haven't found a setting and would appreciate your help if you know how or if it's possible. Thanks in advance. 親愛なる皆様へ。インターフェースの一部について質問させてください。 読み取り専用グリッドコンポーネントを使用します。画面サイズに応じてスクロールバーが表示されます。水平のスクロールバーを動かすとき、ヘッダー行を固定した状態で、ヘッダー以外の場所のみ移動するように実装したいです。 設定を見つけられておらず、もし方法が、あるいは実現の可否についてご存じであれば、お力をお借りしたいのです。よろしくお願いいたします。

Using plugin DOCX From Template to generate word doc and using image bookmark to display image, how can we display image conditionally, it should display image if i pass any image data from PM.

I want to delay the Timer Event for Exactly for 1 second and followed the appian recommneded process  accordingly still there has been no effect  The Duration of that node is always less than 1 second some times  like 0.58,0.060.8,0.36 these were the values seen.I want to see Exactly 1 second. Is there a way to configure to delay the node for exactly one second Thanks In Advance

Hi Everyone, I have an interface having 15 rule inputs. If I need to test interface then Do I need to enter all rule inputs. Is there any better way to test it.