Foundation

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?

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

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

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. 親愛なる皆様へ。インターフェースの一部について質問させてください。 読み取り専用グリッドコンポーネントを使用します。画面サイズに応じてスクロールバーが表示されます。水平のスクロールバーを動かすとき、ヘッダー行を固定した状態で、ヘッダー以外の場所のみ移動するように実装したいです。 設定を見つけられておらず、もし方法が、あるいは実現の可否についてご存じであれば、お力をお借りしたいのです。よろしくお願いいたします。

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

Please help me. Zar file inside log4j.properties are missing as per command.  i m very new in Appian.if you have any link from where i can learn testing . Please share. Thank you very much in Advance.Fitnesse tools i downloaded from below link https://community.appian.com/b/appmarket/posts/fitnesse-for-appian.  where log4j files are missing as per error.

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" ),

Hi,This might be a very basic question but still can anybody guide me how to achieve the context menu by clicking on the 3 dots as shown in the picture below: Thanks

Is it possible to validate that an input is of type email, so that if the user enters something that is not an email, a warning can be showed?

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

Hello all, the subject may not be a good summary of what I'm looking for, so here's a bit more context for this posting. I need to create a set of user interfaces, each of which serves a specific purpose in an application. But a lot of these UIs share similar functionalities (e.g., Approve/Reject decision, Doc upload, Confirmation, etc.) that I'd like to turn into reusable "parts" that will become part of a parent "wrapper" interface object. So, the idea is to always use the parent UI object--this holds common elements such as a page title--and pass in an ID as a rule input, which will be used to determine which of the reusable parts will be displayed within the parent UI. During my online search on this topic, I found this Community posting and this blog entry by [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] to be somewhat relevant to my needs. But it seems that Appian at some point s

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. 

We have a handful of process instances not archiving: 1. Process model's data management is set to archiving 3 days after completion or cancellation, and there are no previous versions of the process model object 2. Instance shows up in monitoring with a green checkmark and all nodes in Process Node under Process Details are completed 3. Nothing shows up under Current Tasks, Quick Tasks, or Sub-Process 4. It looks like the process was manually restarted (start node in the middle of process history) - this restart did successfully run until End Node. End Node also finished at the same time as another node.  Was just curious if this was expected behavior or something that needs more investigation.

Currently, after submitting a form, a new form appears with the previous values for some of the fields , how to fix this issue

Hi Team, I have a group Picker field and there is a condition that if mkv = 'mk-3475' by default it should select a group called Keytruda writers. The users who is working on this interface cannot remove this group but they can add more groups along with this.  Can some one help how I can achieve this. a!pickerFieldGroups( required: true, label: "Assignee(s)", helpTooltip: if( and( or( ri!lrrf['recordType!{a8fd253d-0e45-428b-af5f-cdd4c2b27a87}RGRACSLBL LRRF.fields.{57e16ccd-ed38-46b5-9fb7-8f5cfca177c9}reviewType'] = cons!RGRACSLBL_LRRF_REVIEW_TYPES[1], ri!lrrf['recordType!{a8fd253d-0e45-428b-af5f-cdd4c2b27a87}RGRACSLBL LRRF.fields.{57e16ccd-ed38-46b5-9fb7-8f5cfca177c9}reviewType'] = cons!RGRACSLBL_LRRF_REVIEW_TYPES[2] ), ri!lrrf['recordType!{a8fd253d-0e45-428b-af5f-cdd4c2b27a87}RGRACSLBL LRRF.fields.{2ebc42d8-fe25-490b-879a-dcf755894066}country'] = cons!RGRACSLBL_EUROPEAN_UNION ), cons!RGRACSLBL_CONS_LRRF_GLL_HELPER,

Hi, I have a process model with an Export DSE to Excel smart service and it exports to an Excel file stored in a  folder dedicated for this functionality in my application. During QA testing, 2 different basic users who are in the same parent group and the group has Viewer access for the folder security. One user can successfully download the exported Excel file, while the other user's process instance gets the folder security error "The specified Save in Folder doesnt exist or you do not have enough privileges to access it ". I resolved it by setting the Export DSE to Excel smart service's assignment to "whoever designed the process model" but still would like to understand why 2 basic users will see different behaviour in the process when that node is set to "whoever started the process" as the assignment. TIA

Hello, I have the following validations on a file upload. When I upload a wrong extension for testing, it is giving me a completely different validation message than what I have in my code and I'm not sure where it's getting it from. Also, it looks like each time I upload a new file, the earlier validation message does not get replaced with the new one and I have no point of reference to see where this is happening, if anyone knows how to fix these two issues I'd really appreciate it. Here is the code. For reference, the constant being used (cons!GF_FILE_EXTENSIONS_UTILITY_PACKAGE_ARTIFACTS) has an array of all valid extensions (pdf, jpg, png, etc.)

Hello Appian enthusiasts, I am trying to improve an internal deployment process, and one thing that pop up is the need to update "Group Attributes" in every environment, because we are using SAML Sync. I know Stefan already published an awesome article proposing a solution (SAML Group Sync – Appian Rocks). However, it is for applications starting from scratch. In my case the pieces are already setup. Then, I couldn't find in the documentation a way to use the Customization File for that (Managing Import Customization Files - Appian 24.2). Is there a way to update the group attribute during the deploy or am I asking too much from the Customization File capabilities? Thanks in advance for all!

Hi Everyone , I am getting an error in write to record node in the process model. we had relationship between two records, the table name of the parent  record was modified and it was throwing an error in Process model. telling: table does not exist  "The table name(old table name) " ,later the parent record was removed from application ,and the relationship is also removed. Even now I am getting the same error. when I am not even referring that record ,I am getting an error saying the older table name does not exist ,the table name is modified and record is removed ,why am I facing the error still? Pls let me know the solution

This is my recordtype: This is the interface's creation rule input. EPT_Order_Status_RT is a Recordtype and it is showing up.