Discussion Categories

How to get the memory occupied by the knowledge center documents in Appian server? Tried with Admin console -> Monitoring, and it is providing size for the list of documents uploaded/downloaded? My requirements is get the actual space occupied by the knowledge center documents in Appian cloud environment.

We are getting the expression evaluation error that start index must not be greater than total count. We got the scenario from the user when this issue is occuring. For example, there are 25 tasks in a grid. In 1st page, we will show 1 to 10 tasks, 2nd page with 11 to 20 and last page will have 5 tasks. This count is same for 2 users. Both users open the same page and 1st user completes lets say 5 tasks. So for the 1st user, the task count gets reduced but for the other user, the count will not get reduced since he hasnt performed any action in the page. Now when he clicks on the last page icon in the grid, the following error pops up. Any suggestion to solve this issue?? The tasks are being queried from task report.

hi,  I have implemented pagination for an editable grid, but when i select a first row and move to next page the selection remain same , though the row data is different Page1 , i choose the first row Page 2 - first row is automatically selected how do I control the selection in pagination , local!listPagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20), local!pagedList: rule!getData(Id: local!search,pagingInfo: local!listPagingInfo) a!gridLayout( labelPosition: "ABOVE", totalCount: null, headerCells: {}, columnConfigs: {}, rows: {}, selectionValue: local!selectedIndex, selectionSaveInto: { a!save( local!selectedIndex, a!flatten(save!value) ), a!save( ri!selecteditems, if( a!isNullOrEmpty(local!selectedIndex), {}, index( local!pagedList, local!selectedIndex ) ) ) }, /*selectionRequired: true,*/ selectable: true, selectionStyle: "CHECKBOX", validations: {}, shadeAlternateRows: true, borderStyle: "STANDARD", rowHeader: 1 ),

Is there any way to search all our constants for constants with a particular value contained in their list of values? Our options are By name/description, UUID or UI, or by expression. None search the values of our constants. 

Usually once the document is stored in the correct folder, but is some cases it is getting stored in temporary folder and Geeting the error while trying to access the site, so can we know why in some cases document is getting stored in the Temporary folder, is there is any condition to store the document in temporary folder. 

Hello All, I am trying to create a document search feature where the user is expected to search for documents only with document name as input. I have already tested "Content Tools - findDocumentByName()" function and realized that it only works when the full name of the file is provided as input. I want to have the partial name string search capability where the system can output list of documents with names containing the search string. Assuming the document metadata(e.g. doc id) is not stored in DB, is there any way to solve this?

Hii I have requirement to trigger PM on 15th business day of each month so, ( workday( date(year(ri!date), month(ri!date), 1), 13, { null() } )) By this expression i'm getting 15th working day of month bt as we have timer event and in that monthly time recurrence will ask for On Days  So How we can do that ?

Currently in the functions we have to pass the sheet number to extract the information from excel. Is there is any other excel plugin or function to get the data using the sheet name.

Hi All I have one scenario to be handled that -> If the user provides the amount as 0, load – (Minus) value in the payload. I have written this logic but its not working that means values are not loading.a!localVariables( local!crfxRateActivation_cdt: if( rule!APN_isBlank(ri!crfxRateActivation_cdt), rule!CR_APP_QE_getFxRateActivationData( requestId_int: ri!requestId_int, cif_int: ri!cif_int ), ri!crfxRateActivation_cdt ), rule!CR_APP_INT_setFxRatesRequestBody( preferredRate_txt: index( local!crfxRateActivation_cdt, 1, "preferredRate_txt", {} ), fxCodes_txt: index( local!crfxRateActivation_cdt, "tariffCode_txt", {} ), fxRates_int: a!forEach( items: index( local!crfxRateActivation_cdt, "tariffAmountProposed_dec", {} ), expression: if(fv!item = 0, "-", fv!item) ) ) ) The value which I am trying to send is at last logic,Please correct me I

I have to get all the sheet names from the excel document .

Hello,  We have a client that is interested in embedding Appian within an IFrame on their site. They would like to set the IFrame height to fit the Appian embedded Interface to avoid having to scroll within the IFrame. Does anyone know a method within Appian to retrieve the specific dimensions per unique interface? We would like to use those dimensions to size each specific IFrame.  Thank you in advance. 

Hi Community, I am facing a weird issue in one of my environments. I have used richTextEditorField on my interface and have got the following output I don't know why I am getting an extra message (Saving Image in Appian) below my field. Please let me know if anybody has faced this issue, or have any solutionsFYI: The plugin is updated to its latest version The same code is working fine on my different environments.

i want to export grid data to excel part, with graph,i want to export above data with graph to excel

Hello Appian Community, In the project I'm working on we are designing a flow to automate deployments using Jenkins. I have tested Appian APIs to download packages automatically. But when I use the API (https://docs.appian.com/suite/help/latest/Application_Package_Details_API.html)  to obtain package information from an Application, it only returns the packages created in that environment. But I want to download a package that I have deployed using "Compare And Deploy" and therefore I have not created in this environment.  Could you tell me how to download the package that has been deployed? Thanks in advance!

Hi fellow devs, There is a scenario where I have email address available to me like: "testuser@gmail.com" and this email address has some username at the backend like this: "Test_user". Now what I want to do is on the basis of email I want to fetch username. Previously I was using this function to fetch username out of email address: index(getusersby(pv!ccperson,3,1),1, null) (this function gives output in expression rule but in process model don't know why its not working and gives error) but now it seems like this function is no longer working. I am unable to find any other function through which I can perform this functionality, any help in this regard would be helpful.

Requirement - Appian application has to fetch data from the external system and it has to be real time (If there is a change in the external system it should reflect immediately in Appian). How to handle this scenario? Do I need to schedule process model every 5 seconds or is there a way to monitor the changes in external system?

Dear Team, I am new comer to Appian have background of IBM BPM, Can you please guide where to find  inner exception details (log for this error) of a smart service ( Move to Collab). It is giving error  com.appiancorp.suiteapi.process.exceptions.SmartServiceException: java.lang.Exception: Invalid File Path: /webattachments/path/foldername//info@alwaha-qatar.com/qid20220327080031286QID_&_PP.pdf we are using to move files from file server to appian mount path but it is completed sometimes & gives above error some times.

I have three tables, SpeakerEvent, ParishEvent and a junction table that joins SpeakerEvent to ParishEvent, JNC_Speaker_Event_Parish_Event I need an Appian query that can tell me which SpeakerEvents have not been assigned to a Parish as well as another query that will tell me a Parish has not be assigned to a SpeakerEvent. If I were creating a view in SQL, this would be done easily with a left join and checking to see if the ParishEventId is null. SELECT SE.* FROM `PMSO_SPEAKER_EVENT` AS SE LEFT JOIN `PMSO_JNC_SPEAKER_EVENT_PARISH_EVENT` AS JSP ON SE.SPEAKER_EVENT_ID = JSP.SPEAKER_EVENT_ID WHERE JSP.PARISH_EVENT_ID IS NULL In Appian, I am trying to create an Expression Rule to do the same thing.  I tried several version of using a a!queryFilters as well as a!queryLogicalExpression.  I'm guessing that it has to do with the fact that there are no records on the other end of the relationship (JNC_Speaker_Event_Parish_Event). if( a!isnotNullOrEmpty(ri!speakerId), a!queryR

How am I supposed to on a addRowLink, add an empty document file to my list of documents files? The thing is: on a interface, the fileUploadField is working, but it doesn't work on the site addRowlink: a!dynamicLink( label: "Inserir novo documento", /*value: { id: null, doc: "", tipo: "", descricao: "" },*/ value: 'recordType!{1f7c4a8e-ee45-44c7-8872-dc5542133555}GC Documento Proposta'( 'recordType!{1f7c4a8e-ee45-44c7-8872-dc5542133555}GC Documento Proposta.fields.{9edd3c74-2a43-4d35-a34a-f15156e24008}nome': null ), saveInto: { a!save(ri!documents, append(ri!documents, "")), a!save(ri!record, append(ri!record, save!value)), } ), rowHeader: 1, )

Is there an easy way to switch tabs from process to monitoring, or split the tabs? It's so struggling to be clicking all the time

Hi guys, I am trying to delete old active process instances by using a send/receive message event. This is the parent process which fetches old instance ids and sends the message to those active instances Here i have defined a process uuid property which captures the uuid of the process model In the receive message event, I have applied the condition if the uuid matches the specific value The issue i have is the messages are sent successfully, however it's not being received because of the condition. It worked fine when I used the processModelId property. Since it changes in every environment, i want to use uuid. What am I doing wrong in this configuration?

I'm trying to get the list of the custom data types that uses date and time field in it, from the whole application. Kindly post your suggestions, Thank you.

How can we get 1st index elements of each array in different new array. Like{2,13,65}{7,15,45}{14,3,56}So output of 1st elements should be {2,7,14}And for 2nd and 3rd {13,15,3}{65,45,56}

Hi All, We have installed Appian on Kubernetes, but the current file upload size limit is 1MB. Could you please advise on how to increase this default upload file size? Thanks in advance.

I have a record type called "Case", and it has a field called "assignee". I also have an interface, in the interface, I have a grid field that show all cases, with multi-selection enabled a dropdown field allow user choose an assignee a button, called "Assign Selected Cases in Batch", after user multi-select cases and select assignee from dropdown, allow user to click this button to assign multiple cases to 1 assignee in 1 click To do so, I created: a batch assignment process model (works perfectly) In the interface, I declared: a refresh counter called local!caseDataRefreshCounter, initialize with 0 local!cases, as a refresh variable, with refreshOnVarChange set to local!caseDataRefreshCounter, and it is corresponding to the "data" field under my a!gridField the button widget implementation of "Assign Selected Cases in Batch" is a!buttonWidget( label: "Assign Selected Cases in Batch", saveInto