-
Recently active
Hi all, Does anyone know how or have examples of creating a line chart with the time on the x-axis and the date on the y-axis? Looking to see the number of requests that come into the queue for an application based on time of day and date. Thank you.
Hi, Initially when clicked on submit button where validate is true, this will validate and show messages like "Enter a value" for each field. Now when i again click on the another Cancel button where validate is false, then the validation is still showing " Enter a value" should be disappeared. which is not happening now.
Hi all, Has anyone created a line chart having the Time on Y-Axis and Date on X-Axis? We're looking to visualise data for the time of day that requests enter the queue for an application to identify peak periods. Below is a sample interface we're playing with, essentially we want to change the "# cases" on the Y-axis to "time of day". Any information or examples will be much appreciated! Thank you. a!localVariables( local!requests: a!dataSubset( data: { { created_on: datetime( 2019, 1, 10, 5, 7, 10, 0 ), id_count: 65, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 11, 5, 7, 10, 0 ), id_count: 66, time: time( 5, 7, 10, 0
Hi, I have a process that displays a form. The latter contains an upload component and a donwload link. The upload mecanism works fine as I can see the "document_id" saved in my rule Input. Could you tell me why when the user is in modification mode of the form (not readonly) the click on the download link throws this error please? {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An error has occured"} If I save the form, leaving the process terminating, writing the data in DB, and then re-open the form (from the same process), the download button works fine. When I am in modification of the form in the Designer, when testing the link, I can see the error is systematic, but if I launch a testing Expression rule to examine the document ID, I can verify that the document in file system Appian is fine : todocument(51755) => gives me the co
Hello, I have an interface with a grid which has a column called actual time which is an editable field and multiple entries can be added. Suppose i enter 3 rows and there are 3 values for actual time say 5, 10,15 and if i edit the first value ie 5, a text box should be displayed where a comment can be added. So if any of the row values is edited, the text box is displayed. TIA!!
Hi all, We have a Site based application with a main home page that displays information about processes. When a process flow ends, then the main home page is displayed. The process is modifying some values that should be displayed in the main home page. However, when the process ends the main home page is displayed with the old values. Only when we refresh the browser the page displays the new values. The home page is reading the values from the database. We have verified that the variables are declared inside a a!localVariables() block. We have also tried to use a!refreshVariable() with no luck. Does anyone have any idea to automatically load the new values?
Expression evaluation error [evaluation ID = DD2TAAGA] in rule ‘ibs_referencetableibsrefrfld' (called by rule ‘ibs_referencetables') at function a!dropdownField [line 312]: A dropdown component [label=“FLD_ID”] has an invalid value for “value”. All selected values must be present in the choiceValues array, but value was 56 and choiceValues was 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; 13; 14; 15; 16; 17; 18; 19; 20; 21; 22; 23; 24; 25; 26; 27; 28; 29; 30; 31; 32; 33; 34; 35; 36; 37; 38; 39; 40; 41; 42; 43; 44; 45; 46; 47; 48; 49; 50; 51; 52; 53; 54; 55; 56.
Please help me to figure oute the error - Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!columnLayout parameter 2 [line 33]: Missing right parenthesis in expression, found COMMA { a!columnLayout( columns:{ a!columnLayout( contents: { a!richTextDisplayField( value: ( a!richTextIcon( icon: ri!icon, size:choose( "LARGE", "MEDIUM_PLUS", "MEDUIM" ), color:cons!DU_CHART_COLOR_HEX_CODES ), ) ), a!richTextItem( text: " " & ri!label, size:choose( "LARGE", "MEDIUM_PLUS", "MEDUIM" ) ) } ), } a!columnLayout( contents: ( ri!extraComponent ), width: if( ri!isSectionFullPageWidth, "WIDE", "NARROW_PLUS" ), showWhen: not( isnull (ri!extraComponent )) ), a!columnLayout( width: "NARROW" , contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", align: "RIGHT", value: ( a!richTextItem( text: ri!linklabel, style: "STRON
Hi all, I Need to display static value in the text field and same value should save into one more variable , Please advise. load( local!getTexfieldValue, { a!textField( value: "abc", saveInto: { a!save(local!getTexfieldValue,save!value) },),a!textField( value: local!getTexfieldValue,)}) Regards Pallavi N
Hello Everyone, I had a requirement that I had a requirement of transactions like (to transfer amount to one account to another account) I am able to do the transactions in Interface but How can I save that Values to the particular field in another record. Can anyone help me with this? Thanks in ADVANCE a!localVariables( local!result, a!formLayout( label: "Transaction", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!floatingPointField( label: "Available Balance", labelPosition: if( ri!readOnly, "ADJACENT", "ABOVE" ), value: ri!COB_Applicant.kycid.transaction.availableBalance, saveInto: ri!COB_Applicant.kycid.transaction.availableBalance, readOnly: ri!readOnly, disabled: false ) } ), a!colu
Hi Team, Could you please help me in converting the following code into Foreach() if( isnull( local!region ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "regionId", {} ) ) ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "lobId", {} ) ) ), if( rule!APN_isEmpty( tostring( index( local!userreg.data, "regionId", {} ) ) ), {}, local!distuserregname ), null ),
Hi Team, we have modified a field (lobId) from normal to an array type (highlighted below) In an interface, I'm getting the following error: The error I'm getting at the following code. line_of_business: if( isnull( local!line_of_business ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "lobId", {} ) ) ), {}, tostring( rule!CTR_QE_getLineOfBusinessById( lineOfBusinessId: tointeger( tostring( index( local!userlist.data, "lobId", {} ) ) ) ).data.line_of_business_code ) ), local!line_of_business ), If i send the values manuall
Hi I have observed two issues with hierarchyBrowserFieldTree. Any thoughts/suggestions are helpful. 1- if we want to narrow down the data by applying some filters, Its not refreshing the nodes but the nextNode counts are getting updated. 2- in the hierarchyBrowserFieldTreeNode attributes, showwhen attribute is not doing its job when we want to set false based on some condition, Interface is throwing an error. It can be tested easily with appian given example. a!localVariables( local!path: {5,2}, a!hierarchyBrowserFieldTree( nodeConfigs: a!hierarchyBrowserFieldTreeNode( showWhen:not(tointeger(fv!nodeValue)=0), id: fv!nodeValue, label: "Node" & fv!nodeValue, description: "Description for node " & fv!nodeValue, details: "Details for node " & fv!nodeValue, image: a!documentImage(document: a!iconIndicator("PREVIEW")), nextLevelCount: fv!nodeValue ), pathValue: local!path, pathSaveInto: local!path, nextLevelValues: en
Hi Everyone, I have a Request dashboard with few filters. This dashboard includes all the active tasks part of the application.I am facing a timeout issue (> 2 secs) when I use the filter for assignees (intermittent). User can select a particular group or an user to filter. I am looking for suggestion on this filter for assignees. To fetch the active tasks we are using a process report that filters all the active tasks with the report context being all the process models within the application.We have around 70 process models and currently active tasks in the Production is around 5600. When it was below 4000 active tasks the filters were working great. Key points:1. The tasks can be assigned to multiple assignees which could be group and/or multiple users.2. On the report I have a column "Task Assignees" which I has: - Definition: =joinarray(task_assignee_owner(),";") - Formatting: Normal Text The "Task Assignees" column was made this way because of mu
Hi Team, I'm having an old grid layout. I'm having a field "Classification", Currently if the data is null its showing as emply(rounded below). Now i want to put a condition, if any of the value is null/emply i should display as "None'" otherwise as it is value existing data Classification Insurance Banking Null/Empty Expected: Classification Insurance Banking None Using the following code a!gridTextColumn( label: "Classification", field:local!gridDatasubset.columnConfigs[31].field, data: if( rule!APN_isEmpty(local!gridDatasubset.data.c61), "
In a!richTextDisplayField() , helpTooltip is used as a parameter. When I used it, the tooltip symbol(?) comes above the label. It should be appearing next to the label like it happens helpTooltip is used as a parameter for a!textField(). Can you suggest some way by which I can place the tooltip symbol(?) next to the label.
Hello, I have a table that contains the document id and some document metadata. I want to display a grid with these data and a link to the document but all documents are not accessible by the logged in user. I want to display only row that refer to a document accessible by the user. I try something like this: if (isnull(todocument(fv!row.docid)), /* do not display */, /display the row */ ) I also test if (todocument(fv!row.docid)="[NO PERMISSION]" but it doesn't work. How can I tests if the user have access to a specific document ? Thanks for your help
Short of creating a constant that contains all valid icons and richTextIcons (which is suboptimal given that icons are updated between Appian versions), is there a way to make icons "invalid icon"-safe? i.e. Checking if an icon is in the list of supported icons on a given appian version before passing it into icon or richTextIcon? Context We have a (larger, complex) application that dynamically determines which icon to use in a richTextDisplayField. One can be thorough and investigate the root cause of why invalid values are being populated but I would like to be thorough and double-check. Thanks!
Hi, Could you tell me how a filtered RecordType grid (placed inside an interface) can be refreshed please ? My RecordType data are retrieved from the a!recordData() function, and is filtered on the field "deleted" (all rows are visible if delete = "false"). I have a button that calls an Expression Rule to update the underlying table to set the "deleted" field of the selected row to "true". (I use the WriteToDataStoreEntity Smartservice). After the table is updated in database, I have click to click on the "refresh" icon of the RecordType to see that all is working fine : the lines are hidded. How would you refresh the RecordType, without a manual user action please ? (I intentionnaly do not use any process model for this example)
load( local!carriers: rule!CAS_getPayeesAndCarriers( getOnlyCarriers: true ), a!gridField_19r1( totalCount: ri!processData.totalCount, columns: { a!gridTextColumn( label: "Last Updated", field: "c12", data: a!forEach( items: index(ri!processData.data, "c12", {}), expression: todate(fv!item) ) ), a!gridTextColumn( label: "Assignee", field: "c13", data: a!forEach( items: index(ri!processData.data, "c13", {}), expression: if( isusernametaken(tostring(index(fv!item, 2, null))), rule!CAS_formatUserName(userName: index(fv!item, 2, null)), null ) ) ), a!gridTextColumn( label: "Carrier Policy ID", field: "c6", data: index(ri!processData.data, "c6", {}), links: a!forEach( items: index(ri!processData.data, "c5", {}), expression: a!processTaskLink( task: fv!item ) ) )
Hi, I've created a simple RecordType based on a MySQL table, and when editing the grid list (tab List), I have added a new column that does not exist is the underlying table (ex : "total" that is the sum of fields "nb1" and "nb2"). When using this colum in a Grid of an interface, why does the "Recordtype!Vehicles.Fields.total" is not available ? Does the Fields object contain only the fields that exist in the underlying table ?
Hi Team, I have a grid Layout which is having couple of fields. But one search field "Classification" is not working as expected. Please find my below code. Code: a!gridLayout( label: "Legal Entity Overview", totalCount: local!entitySize, headercells: { a!gridLayoutHeaderCell( label: "Name" ), a!gridLayoutHeaderCell( label: "Tax Identifier" ), a!gridLayoutHeaderCell( label: "LOB" ), a!gridLayoutHeaderCell( label: "Classification" ), a!gridLayoutHeaderCell( label: "Region" ), a!gridLayoutHeaderCell( label: "Country" ), a!gridLayoutHeaderCell( label: "Reporting Type" ), a!gridLayoutHeaderCell( label: "Client Institution ID" ), a!gridLayoutHeaderCell( label: "Milestone" ), a!gridLayoutHeaderCell( label: "Deadline" ), a!gridLayoutHeaderCell( label: "Completion Date" ), a!gridLayoutHeaderCell( label: "Reportable Status" ) }, columnconfigs: { a!gridLayo
Hi, I would like to remove an item from a list, depending on a field (here, the condition is : when the "checked" field is false, I need to remove the item) : /* Set to null the unchecked Vehicles items */ a!forEach( items: ri!vehicles, expression: if (rule!SHARED_IsFalse(fv!item.checked), a!save(fv!item, null), a!save(fv!item, fv!item) ) ), /* Remove the null items */ a!save(ri!vehicles, reject(fn!isnull, ri!vehicles)), 1/ How would you code it in a single instruction please ? (with a foreach and a remove ?)2/ From a SaveInto of an interface the code above works fine, but now I'm trying to execute it from an Expression Rule. So, how would you code this instruction "a!save(fv!item, null)", as a!save cannot be used in ER ? I've tried to use the function updateDictionary(), but I do not see how to set an item to null (I can just set some fields to a null value). I'm sure the answer of the first question can make the
We are using out of the box task notification emails and one of the influential users doesn't like the GMT origin time zone on the notification email. I've looked in regional settings per user, looked at the emailheader.html and emailfooter.html system objects, and in admin console, but cannot find a way to localize time per user on these notifications. I'm concerned the only alternative is to eat the system task message and pass along a custom email to the group. Is this true, or is there something I have overlooked? Thanks for any insight!
I have a customer requirement to allow the users of the application to individually control which columns of information they see on the screen for a given interface. The application will have a default column sequence and that's what every user gets initially. Then each user will have the ability to: Reorder the columns Hide columns from the display Add columns back into the grid that were previously hidden Reset the grid back to the default columns in sequence Anyone have some example code to try and deal with this situation? I'm open to any approaches.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.