Foundation

Hi guys, We've installed the Log Reader plugin and until recently it was able read the login-audit.csv file on all our environments. Now, the readcsvlogpagingwithheaders() function fails to return any values on our OAT environment, but works in all our others. I've noticed the path it's trying to read is different on this particular environment.  In OAT, it seems to be attempting to read the log file from: "/usr/local/appian/ae/shared-logs/login-audit.csv" Whereas in the others, it's reading from: "/usr/local/appian/ae/logs/login-audit.csv" Is there anything that could be causing it to try and read from a different directory, and is there a way to change this? It's causing significant issues at the moment and we need to resolve this as soon as possible. Really appreciate any help, Thanks.

/resized-image/__size/640x480/__key/communityserver-components-multipleuploadfilemanager/5d32e8f2_2D00_67fb_2D00_46e6_2D00_8cff_2D00_9dcc2b6c0050-89589-complete/pastedimage1712731195444v1.png I have a read-only grid that displays data retrieved using the record data function. The data appears as expected. However, I need to calculate the Total Amount based on the "Amount" column in the grid, and this total should be displayed outside the grid in another card layout. The issue is that using the record data function, I'm unable to access the data in a separate local variable to calculate the Total Amount. Although I can use the query record type function to obtain the data and calculate the total amount, this approach is not considered best practice. How can I calculate the Total Amount while using the record data function? Please Give me any Solution for this

i want to add comma to separate the numbers after clicking enter key the current output like: 98998997899 but my desired output should be : 9899,899,7899 How can i acheive this....

Hi team, I have a gridfield where a gridcolumn has a value who's character count can go upto 2500. I want to implement a functionality where i display only 200 chars and show a link "more". When I click on the link, either a popup appears where the entire 2500 char text is displayed or another site appears to display the whole value. How can I achieve this? I tried to use safelink, but I am not sure how to configure the uri to display the text. Can anyone please help me out. So far, i have achieved this,a!gridColumn( label: "Enter 2500 char text", value: a!richTextDisplayField( value:{a!richTextItem( text: left(fv!row.textValue,255) ), a!richTextItem( text:"..more", link: a!safeLink( ) ) } ) )

Hey Everyone, I am facing an issue while getting the groups for a user. We used to make use of function getgroupsformemberuser() from plugin People function version 1.10 jar We need to update the People function plugin to 1.16.0 jar but in this newest update, getgroupsformemberuser() is not supported. Replacement for getgroupsformemberuser() function looked a!groupsForUser() but result set of both is not matching. When I use getgroupsformemberuser(), I get 70 groups list which is absolutely perfect. When I match with the number of groups for loggedInUser from Users in Appian: It shows 70 users Means, getgroupsformemberuser() output matches with actual groups. But when I use a!groupsForUser() appian built in function, it return 72 groups: Conclusion: Output is not matching as it's returning 2 more groups which I don't have permission to view.  Is there any way that these 2 extra [NO PERMISSION] groups can be removed from this result set? I

Hi,  I need to get all the email addresses of the users in the application. I need this list in the dropdown field. Can someone please help here?Thanks in advance!

Do we have any possibility of writing merge custom cells using write to data store entity, Firstname, lastname, city and state are fields from DB. I want to write Name and address but name column should be a merge cell i.e. A1:B1 , same goes with address column. We have the possibility of doing this with the template i.e. keeping this template. But what if, we dont want to use a template then do we have any option.

Hi All, We are facing issue with Export to excel. while exporting we are not  getting data in to the excel sheet we have nearly 350 records only still we are facing this issue.If we give any filters then it is fetching the data otherwise it is exporting with no values in excel.Please find the screen shot How can we resolve this? please provide suggestion

I am currently utilizing pane layout to display data on an interface. Everything in Appian Designer works as expected, I can scroll my data using the pane layout feature. However, when I added this to a site to be displayed on the front end, when I navigate to that site page and try to scroll it does not work. Any ideas on why pane layout is working in designer but not from the front end?

If enough app users upload excessively large profile pictures—and those profile pictures are then used in grids, for example—their application can bog down or crash. Can you limit users to smaller profile picture uploads, downsize pictures upon upload as needed, or create a thumbnail of the original picture for apps that use them? If there's some other way to address this ourselves, lmk. David Kessler

I am creating an MVP that requires users to add specific records for sites and buildings while using the mobile app (offline and online).  My current roadblock is when I'm creating a new building record that needs to be associated with a specific site.  In the create new building interface, there is a site drop down list that a user can select before adding a building name/number. For testing I have two ways to initiate the create building record action.  The first way is through the building record list site page (using the Record List Action to initiate the process), and the second way is through a site page that initiates the create building action.  In the latter setup, when selecting a site I receive an "Invalid Rule UUID field:..." for line 13 in the picture provided. I appreciate any help or insight into this issue.  Thanks!

I am trying to do bulk update i.e. update more than one row at a time using editable grid. Please suggest how to do this

I am trying to execute a process model on click of button which one of the  component in editable grid. Unfortunately. the PM is not getting initiated. Can anyone help what could be the reason. a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Save", saveInto: a!startProcess( processModel:cons!TRA_WriteRecordsPM, processParameters: {recordTRA:fv!item}, onSuccess: a!save(local!success,fv!processInfo), /*onError: a!save(local!data)*/ ), submit: true() ) } ),

Hello everyone, I have a question for you.I am experiencing an issue where some data is not being displayed on a site that is currently under development, and I would appreciate any hints on how to resolve the issue. I recently added a new field to one of my master DBs.We also re-mapped the record types and performed record sync.We're also adding new fields to CDT and republishing the datastore. Based on the above, I performed the process of passing a CDT to the rule input of a certain interface and displaying it. The relevant description isri!○○CDT[recordType!○○.field.××××] It is displayed normally on the editing screen, but it is not displayed on the site. When transitioning to the relevant screen on the site, a process model is running behind the scenes, and process variables are passed to the form.This process variable's CDT is querying the record type.To check if the query is incorrect, I run the same query on a temporary interface, and all values a

Hi All, Is there any way to allow data sync in record type once we already created record type without data sync and related feature? Thanks in advance

Hello Folks, Followed by above screenshots: I have two fields (dropdown and text). Text field comes up when click on plus icon.  Scenario: Dropdown field contains company name. There is a possibility to add manual company name. That's why plus icon will be placed and on click of that shows up text field. I have column in a database called companyName that saves value. Issue here is: Both field saves value into same "saveInto" which conflicts. When I fills up text field it shows dropdown error because value saves into same companyName column. Please see below code. a!localVariables( local!company: false(), a!dropdownField( choiceLabels: local!CompanyLabels, choiceValues: local!CompanyLabels, label: "company name:", labelPosition: "ADJACENT", placeholder: "Select Choice", value: tostring(index(ri!company, "companyName", {})), saveInto: ri!company.companyName, disabled: if( toboolean(not(local!company)), fals

Hi All, am facing an issue, where according to the request the results will be coming to the grid. But when i export the results from the grid, it is fetching only first page i.e 10 rows to the excel . What should i modify, so that it will fetch the entire grid results to the excel export. Do i need to change anything in PM? Please find the reference code. a!buttonLayout( secondaryButtons: a!buttonWidget_23r3( label: "Export ", saveInto: { a!startProcess( processModel: cons!SM_EXPORT_BATCHES_ORDERED_PROCESS_MODEL, processParameters: { batchTransDetails: local!batchDs.data, selectedSiteFulfillStatusId:local!selectedSiteFulfillStatusId, selectedSiteSubOrderStatus:local!selectedSiteSubStatus, isPSM: toboolean( local!isSM )/*orderId:rf!orderId,*/ /*project:"POS",*/ /*fulfillSiteId:4,*/ /*selectedRep:1*/ }, onSuccess: { a!save( local!documentId, fv!processInfo.pv.documentId ) } ) } 

Good morning, In a KpiField component, when it does a sum with a!measure and does not find data, I get the default value "No data available", is there a way to change this default message Thank you so much

Hello, Can someone please guide me with link where can we view our grant4ed Appian certificates along with their expiry dates. Thanks in Advance

Hi guys, Is there a new limit to how many rows can be stored in a process variable that is marked as multiple? I made a query that returned 146 elements and the length of the ac!variable is 146 but in the pv!variable there are only 101 elements. Everything after the 101st element seems to have gotten trimmed out.

Hi,  I am following https://docs.appian.com/suite/help/24.2/recipe-expand-collapse-rows-in-a-tree-grid.html to create a Proof of concept. I have dropped collapsible functionality as my intent is I should have a header and sub items below it as shown in this recipe. I have done that successfully but when I try to add the selection check box , there is a problem ,  as this grid is written using loop within loop, when I try to select an item in first section, the item in second section also gets selected. Please let me know if there is an alternate way to resolve this.  Any help is appreciated. 

Hello Team, I have build an editable grind and now I want to save the values inside my records. I have record table and rule input in my interface the problem is how I can save this data for each request I have. The data is a sample there are around 15 rows which I want the user to be able to save some of them can be null some of them can be filled out. Basically the property is read only, once user enter value we can use a!save to save the property for the respective row, but I always get cannot index rule input records.. rows: { a!gridRowLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: {"Melting Point"} ) }

Is there any OOTB feature available in appian to programmatically update the pv variables of the inflight instances like any smart service, apart from IFM (In-flight Modification) plugin? please suggest.

Hi team, How can I add Environment name detail in  Notification/ error email subject? Thanks, Kiran

Hi All, I have a PM wherein im calling few processes- async and sync. The structure is -> Start node-> script task-> sync subprocess -> gateway-> sync subprocess -> start process->  start process-> scrip task and so on.. Every day few instances get error on the first start process(i made it bold ) with the following error Error when parsing process details or variables Also when we restart the node, the process runs without error. We have trd if the variable that we send is not in proper format . We are passing only one cdt pv to this start process. I am not understanding why the error would come, is it coz of the engines beign busy? but why alwasy on the same node? If anyone could make this all sence or give a solution, it will be time saving for us. Thanks in advance.