General

How can we achieve this

Hi, I have a concern about the text() function after Appian Upgrade 23.4.  The code: text( gmt(todatetime("01/09/2023"), timezone()) + intervalds(12,00,00), "dd-mmm-yy hh:mm:ss") & " AM'" The output: "01-Sept-23 12:00:00 AM'" /resized-image/__size/640x480/__key/communityserver-discussions-components-files/11/Screenshot-2024_2D00_01_2D00_02-at-6.08.20_2F20_PM.png The output keeps returning "Sept" instead of "Sep" and this is only happening for the month of September. The other months are returning the first 3 letters.  Does anyone know how to resolve this? 

I want to build functionality where when user lands to my Appian site , Show Dialog Box upon login with following details: 1. Message in the Dialog Box - “Please set your local time zone in Settings. Ignore if already done.” 2. There needs to be checkbox after the above saying "Please dont show this again"  3. Ok Button - If the user clicks on the checkbox in Step2 before clicking on the Ok button then the dialog box should appear again when the user logs in next time.

if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[1], rule!CR_APP_CA_PDF_genericRuleForNtb( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[11], rule!CR_APP_CA_PDF_genericRuleForContractExtension( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[12], rule!CR_APP_CA_PDF_genericRuleForRemedialAndSAMHandoverManagement( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[2], rule!CR_APP_CA_PDF_genericRuleForCashCollateral( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if(

Hello All, We are migrating our db from Mysql to Postgre.  Postgre uses some different datatypes as compared to mysql (eg. boolean) Has anyone worked on the migration of the whole db to postgre, if yes can you please provide few steps on best way to do it?  Esp the cdt(xsd) part. Database we have migrated, but we are finding hard time in updating the cdts. Thanks in advance!!! 

I run a small cleaning business in australia, so I need to collect reviews/feedback from customers, but I want to avoid negative reviews, so I am trying to create a page on my website that has buttons for redirection based on what customer choose. But the problem with a page with buttons is, users can anytime come back to the page and click again on other button to leave negative review, so it will backfire. So, I seriously need a fullproof method to use redirection method so I can collect positive reviews on GMB and negative feedback on a form so I cam improve on those points. Is there anyway I can use any platform different from Wordpress for my feedback page? Or can create a completely different feedback page with html? (also I don’t want Google to index my feedback page so my competitors won’t see my method). Any help on this is appreciated. Solution needed ASAP. Customer Feedback Sample Page I need help with: https://superiorcleaningandpest.com.au/customer-feedbac

How to navigate from one interface to another interface ??. Can any one suggest how to do it??

a!gridColumn( label: "Status", sortField: "status", value: if ( fv!row.isTesting, a!iconIndicator( icon: "STATUS_NOTDONE", ), a!iconIndicator( icon: "STATUS_OK", ), )

Hi Team,  I need to populate the data in custom picker. But the data count is huge like 100000 rows available in the database. I have no other filter criteria to reduce the  count. My question is is it possible to populate the values after entering the first three characters of the data or is there is any alternative method available . 

Hi , everyone Site logo always appear right upper conner . I want to show left upper conner how to implement it. here is my site  My desire site image is like that Thanks

Can we test Appain application using LoadRunner  for Performance testing? If so, could someone guide me to the right documentation? 

We have Modified on Date filed , which is Date Time. Requirement is every hour scheduler runs and pick the data from now to past hour. If the current date time is 26/12/2023 11:30 AM IST then Start Date Time =  26/12/2023 11:30 AM End Date Time  26/12/2023 10:30 AM. Start Date Time I am calculating like =a!subtractDateTime(  startDateTime: now()) End Date Time: a!subtractDateTime(startDateTime: ac!startDateTime, hours: 1) above 2 are giving me proper startDateTime and End Date Time. but when I pass to query Filter, I am using the <=Strat DateTime & >=End DateTime. I have one record with Modified on is 26/12/2023 10:50 AM which is in between Start Date & End Date mentioned above. but still I am getting 0 Records from database. How to construct Start  Time & End Date Time get hourly data. 

Hi, The script gets run successful separately. While run suite(Multiple script together), the particular script gives error. Could you please let me know what may cause for this. Did i miss some step or something else. Thank you for your time.

Hi, I have a cancel button where i had kept submit as true and validate as false but still it is showing to fill mandatory fields. I am trying this in live task instance not in interface editor. Can someone pls help on this?

Hello All, Is there a feature like PEGA's Email Listener that accesses external email services and notifies them via Appian? What I would like to do is to have Appian notify or initiate a process when a value defined in Appian matches the sender of an email received by an external email service. Any clues you can give me on this would be appreciated.

Hi, I have a requirement to display the header and footer on every generated page of the PDF report through HTML I tried using header and footer tags, but that is not working

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?

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

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

Hello everyone Iam struggling in finding the SAIL Design system inside Figma , is there a way to do so?