-
Recently active
Hello Team, I have filter the date based on the function eomonth(today(),-1) i.e last day of previous month but the fitler has type of date & time where as this function will return only in date format.I have tried to add the time to the function but couldnt able to achieve the requirement as it throwing error of miss comparison types.please help.Thanks in Advance.Error : Expression evaluation error at function a!queryRecordType [line 3]: Cannot apply operator [LESS_EQUALS_THAN] to field [createdDate] when comparing to value [TypedValue[it=3,v=11/30/20236:08 AM]]. a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "createdDate" /* this is type of Date & Time */ operator: "
Hi everyone, I'm getting an error while querying data. Scenario here is logged in user will have multiple countries associated. so when user logs in we are fetching loggedin user counties and passing the list of country id's to the view to get data. when user having upto 70 countries it is working fine but when exceeds it is throwing error. Can anyone please help me how to resolve the issue. PFA image
How to Query a database values which exceeds the memory limit without any filters. Is there a way we can just type the first 3 characters and the respective values should be fetched?
Hello, I need to pass the yesterday's date and a specific time to a variable of dateTime type. Basically today I want to get all the data which is saved in database yesterday. How to achieve this? Thank you.
In an Appian paging grid, when clicking the "Preview" text in one of the columns, the goal is to display the data from the PDF document in another tab and provide an option for downloading. How can this be implemented in Appian?
Hi I have data type which have data with site id, site name, workingstartDate, workingendDate. I want to create line chart which is for each day of month, nu of sites worked? how can i do that?
How can I show warning message in the top of the form I have two field one is region that is multiselected and another is geography that is single selection if I selected region like 3 value APAC,EMEA,NAM and after that I selected from geography NAM if both value are matched then warning message will be not shown if value are not match in both field then warning msg will be shown on the top of form
Hi All, I have a query that returns documents with a specific name, sometimes by mistake we will have 2 or 3 files/documents with the same name, I want to make sure that my query selects the latest one added instead of the first one that it finds, how can I accomplish this? Right now if I have 3 files with the same name it picks the first one added since its the first one the query finds. thanks in advance
We're developing an app that will be used on both Android and iOS via the browser. We have everything working for both mobile OS, but the Video Content Field is giving us some problems on iOS. We store some videos on Sharepoint and then play them on the app using the link of the Sharepoint file. This works on both PC and Android. But on iOS, no matter the video format (MP4 or MOV), it just gives us the video player in black with no option to play the video. The same video, on PC and Android, works fine. Be it an MP4 or MOV video Has anyone encountered this issue on iOS and has a way to fix it? PS. Tried using the Advanced Video Player plugin, and it gives us the same results. Also on Safari, Chrome and Firefox
I wanna practice on making process models. I want u people to give me Real Scenarios so that i can practice on it.
Is there a way to customize the transient message, Action completed, after a form button (Cancel, Save, etc) is clicked? For example, can we change the message to "Action canceled" after the Cancel button is clicked? Thanks.
Dear Team, Getting error as mentioned on running health check report in our environment. Not able to find any relative discussion in appian community. Can anyone suggest.
Hi, I have a column layout that has flexible number of items.However, when the number of items is too many, the items will be squeezed and distorted.In front-end project usually resolved by having a horizontal scroll bar, what's the Appian's way of suggestion to resolve this situation? Thank you.
Hi All, I have 2 site pages A and B. There is a link on page A and on click of the link the contents in site page B should be displayed. Can anyone please help me how to achieve this?
Hi All How can we see user last login details? Right now I am using this function getlastlogindatetime but it onlys shows only for those users who logged in with in 30 days. Can anyone tell me how can we see those users login in date and time which are logged in with in 90-120 days? Many thanks in advance
Hello! I have a multiple series bar chart with stacking and I needed to show in data labels both the percentage and the number of cases (absolute value). In the image I'm showing only %, but I also need the number of cases: I can show one or the other managing the stacking configuration field, but not both. Is there a way I can do it? Thank you!
I establish a One-to-One parent-child relationship in Appian by including a reference field for the child Custom Data Type (CDT) within the parent CDT during creation. Although the parent CDT is successfully published in the database, initially, the child lacks a primary key. Appian generates the primary key in the child after publication, associating it as a foreign key in the parent table. However, an issue arises during parent table updates; instead of updating the child table, it consistently creates new records. Recognizing this is likely due to the absence of a primary key in the child CDT, I added the necessary primary key during the update of child table and the child table continues to create new records rather than updating existing ones. Seeking a solution for this behavior.
Hi, I got the certification on July 29, 2022, to maintain the certification I saw that there are release courses. I would like to ask, which releases are mandatory in my case? Only the 22.4 and 23.1 or also the earlier ones? Erzen
I have an interface where there is a grid to display tasks, one of the columns is based on status (complete in progress and new) and I want to be able to filter the grid by having only In Progress and New being shown. So in other words, if the status is Completed, I would like the entire row to be removed from the grid. I thought I would have to add a new a!queryfilter but I'm not sure if that is correct or if I'm structuring it wrong. Here is the basics of what I wanted to do. Is this the correct method? Or how should I change it so it can actually accomplish what I want
Hello everyone Iam struggling in finding the SAIL Design system inside Figma , is there a way to do so?
It's working fine in browser
Hi!, We have a web service based record type that needs to be synced overnight in batches as we need to sync more than a thousand records. Batch 1 returns information that needs to be used while calling subsequent batches. We have not been able to find a way to store this information as the record data source expression rule is not allowing to call write record smart service or do a post call to a web API. Any help is greatly appreciated. Thank you!
Let me share with you the results of this code snippet a!map( length: length(local!taller.resultado.contractSetting.annuitySettings.paymentMethods), pm: local!taller.resultado.contractSetting.annuitySettings.paymentMethods, isnull: a!isNullOrEmpty(local!taller.resultado.contractSetting.annuitySettings.paymentMethods) ) I'm wondering why length of a null array is equal to 1.I appreciate any explanation to this. Regards
I am trying to call an external URL from the record actions so that it will open up in a new tab
Hello All, I am passing data to gridField using local variable local!taskData. This local variable local!taskData is updating from the startProcess which is configured on button.Now first time I select the few records and reassign button then the data is updating into local!taskData and able to see the updated data on grid now immediately selecting another records and clicking on reassign then the values where not updating untill unless I refresh the data manually. Is the onsuccess is considering only once ? Is there any way to consider and run the a!save() everytime on clicking on the button. a!startProcess( processModel: cons!PM, processParameters: { reassignData: local!UpdatedData }, onSuccess: { a!save( local!success, fv!processInfo.pv.success ),
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.