General

Hi, I am trying to get a day's worth of rdbms-audit logs.However, I have tried the following expression, but could not get the logs that have been evacuated.Any help would be appreciated. Thanks in advance. Appian version:24.1 Log format: rdbms-audit.log.yyyy-mm-dd.* readlogpaging( logPath: "audit\rdbms\rdbms-audit.log." & tostring(year(today())) & "-" & substitute( padleft(tostring(month(today())), 2), " ", "0" ) & "-" & substitute( padleft(tostring(day(today())), 2) & "." & tostring(pv!LogCounter), " ", "0" ), startIndex: 1, batchSize: - 1).rows

Hello Appian Community, I'm currently working on a Task where I need to clean up multiple versions of Appian objects, particularly interfaces and rules. Manually deleting each version is proving to be very time-consuming. Is there an efficient way to delete these versions in bulk? Any scripts, plugins, or built-in functionalities within Appian that could help streamline this process would be greatly appreciated.

Hi All, We have Appian Site URL like  careers.appian.com/.../ We need to get data from the Query string i.e search=software and location=McLean, Virginia The business case is we need to share this URL to 3rd Party APP , in which they have something called button action where they will configure this URL and send data from their APP to this URL using Query string and we as Appian has to get the data into our system  Is it possible or Not ? Thanks Bihitak

Weird thing happened, I have a if() function if(    my condition,     value when true,    remove(local!myList, wherecontains(cons!code, local!myList.code)) ) when I take the remove() out of if(), it's result is a list of 4 items, but in if(), it's result is a list of 1 item And I tried with wherecontains(), when it's a standalone out of if(), the result is List of Number (Integer) - 0 items, but in if() the result became  But why would this remove 3 items from myList?

Hi All, We are facing one issue while fetching data having few filters. For e.g., the filters like to_date, fund etc are working fine but the moment we select from Date, it throws error. And surprisingly when I am selecting from_date after selecting any other filter, it is working fine.

Is there any way or function  to display or get the total list or the count of application in the environment. I need it for the report page in UGMA. Also the recent activity of loggedInuser over time or something like that.

Hi, I have a requirement where I am querying a process report to check if an active process exist. If there is an active process which means a task was created and based on that the UI is made read-only. I have to query the process report continuously to check if the task is created until the process is triggered. The UI is editable but as soon as the task is created the UI becomes read-only(by querying process report for active instance). Once its in read-only the query should not happen to check the process report. EX: local!editReportdata: a!refreshVariable( value: index( rule!getActiveInstances( pagingInfo: a!pagingInfo(1, 1), workflow: ri!workflow ), "data", {} ), refreshAlways: true() ), local!isInstanceActive:a!isNotNullOrEmpty(local!editReportdata) Here, once local!isInstanceActive is true it should remain true even though local!editReportData becomes null. if local!isInstanceActive is false it should keep on checking until it gets true(). Or the variable local!

How to call word file(docx) into an image component? I tried to call it but for some reason it's not displaying it properly, Please help!!

My requirement is that i have an editable grid which has lets suppose 1000 rows and i have to only sent the updated one to Database. i.e. if user change 3 out of 1000 rows then only 3 should be sent to process model or a!writerecords for updating this to DB rather than sending the whole 1000 rows. So what i did i created two variables for fetching record data from DB. 1 containing the original data and second containing the changed data, Now my requirement is to compare both these variables so that i can find the changed data which can then be sent for update.

For a while now we are getting JAXB errors in several different process models with the following error or similar to this error. Difficulty is that even if it will return the same error; where the error happens might be in different parts of the same process model (see below), but mostly it will break on the start process nodes from what I can see. We tried removing special characters or smileys from any fields that are passed to the process with clean(), since we feel like this might be causing the errors, but so far no luck yet. Any help would be appreciated!*Please note that I have redacted a large piece of the errortext for privacy purposes. Including parts that might contain the possibly disallowed characters/smileys etc. In this specific example I think it might have been the character ü, but we have found that it is also possible that the character that will break the process is only visible in our main database (not in the MariaDB) as a blank space which makes findin

Let me explain my situation: I have a workflow where certain actions are performed. When a user, let's say XYZ, initiates the process, they are initially assigned as the assignee. However, I need to be able to change this assignee. To handle this, I've created a separate workflow where I only capture the latest active tasks. From this list, I select the task for which I want to change the assignee. Once I reassign the task to a new user, let's call them ABC, I need all subsequent tasks initiated by input to go to this new assignee. To clarify, after initiating the process, I continue working with the same input task when I am the assignee. However, after reassigning the task through a different process, I need to capture the latest assignee for that process, even new assignee's information is already saved in the database. Please let me know if you need more information or if you have any suggestions.

I am creating a dynamic intake form in case management studio where the visibility of few fields depends on values of previous fields. Without using local variables, I am facing cache issue when the values/selections are changed in the previous fields . In the interface I don't see any submit or save button to pass no the values from local variable to rule inputs. Please suggest how to handle this situation.

Hi Community, I have an issue when I want to deploy a constant to another application. The constant value is: 5jb899cdn1ag1gm28jvcyacrp The error that happened in Deployment Log is: content _a-0000e8aa-454b-8000-9c1a-011c48011c48_3537223 "TFO_KEY_CONST": An error occurred while creating content [uuid=_a-0000e8aa-454b-8000-9c1a-011c48011c48_3537223]: The constant [id= uuid=_a-0000e8aa-454b-8000-9c1a-011c48011c48_3537223] was not created because a value for the constant must be provided in an import customization file when it is environment specific (APNX-1-4071-054) (APNX-1-4071-007)

Hello I'm trying to build interface where 2 tables are connected.Now for the first table I have interface where user can click on record action and create the record, but for the next table i want user to go under the summary of the first interface and then create record for second table which have relationship many to one with the first table. Is there a way to create record action with just pulling the ID from the summary to be associated with the second interface.So on press it will auto populate the ID where it has one-to-many relationship and user will enter rest of the information and click create.

Hi  I am using the group function to get the attributes related to the group  group(<groupId>, <property>) I am using this in an interface used on my site.  But what I have come to notice is when logging into my site as a basic user, there seems to be an issue where in the user has insufficient privileges for group() function  Can anyone please help me in this ?  Error Screenshot  

Hello I'm trying to get the task id from my read only grid with selection function of grids. I'm trying to store the task id in rule input, but what this is doing now is when I select one row it's storing all task id's in the rule input not only the single which I have selected and it's not updating the selection in the UI it's refreshing and the selection is gone. And when I load the interface by default it's showing 1 selected.I want to be able to select one row pick the task id store it in rule input and show in the UI that the row is selected, then the same if I select another one save the task id and update UI if something is unselected remove that value from the rule input and update the UI.pageSize: 20, selectable: true, selectionValue: local!report.data[1]["c19"], selectionSaveInto: a!save( saveInto: ri!test, value: local!report.data["c19"] ), showSelectionCount: "ON", rowHeader: 1

Hi, I have a word template in which Signature is a field.  I am capturing all the fields of this template in an Appian form.  I am capturing signature using signature field, I am using the XML functionality to populate the fields in the word template.  I am able to populate all the fields, but how can I populate the signature which is stored as a document in Appian.  Can you please help me? Thanks

for the text field need to give validation, when user enters the value along with text,number,special character then need to show the validation like  only alpha/letters but how can i show this, text field will allow alpha numeric and special character as well

What is the best way to study for the Appian development process models section ot the exam.  I have score very low in this section of the exam,  Thank you for your help.

I want to update a specific row in my recordtype with data in one of the columns as follows:  Here I am using my id (the primary key of the table) to specify which row I wish to update, in this case i want to update case number 80 and update the casestatus column with "accepted", however upon doing so I get the following error:  I am guessing that my syntax is incorrect, but I can't seem to figure out what I am doing wrong exactly.

Hello I've used the open task reports to get all the tasks assigned to a user, but the problem is if the user is assigned to multiple application they can see all the tasks in that report.Is there a way to show only tasks specific to application or specific to all the process models from that application and if you can provide some example would be much appreciated.Thanks in advance.

I came accross a behaviour where an appian object(integration) accessed by two different users having parameters data type in two different format Eg: user1 gets the data type format as "mm/dd/yyyy" and user2 gets the data type as "dd/mm/yyyy". Though their internationalisation settings are same and both users are accessing same object . What else could be the scenario for such behaviour? Above are images from two different users using the same objects.

When starting a process model from the web api, the process variable is []. Below I have attached the result for your reference.

can we create 2 scheduler's in one PM ?

Is there any built in functions or smart service to retrieve the list of table names, number of tables, number of columns in all table and the list of all columns in a table from Appian Cloud Database?