General

Please Check the sample of data i am getting from big query ,,.. I am creating Row id and Unique id after retrieving the data ..  how to filter data on based on npiMap unique_id "1.591111183E9_1902142920_INDIVIDUAL_RIDER_NOT_CHECKED_INITIAL"(Text) row_id 2(Number (Integer)) event_timestamp "1.591111183E9"(Text) npi "1902142920"(Text) rider_type "INDIVIDUAL_RIDER"(Text) trinary_status "NOT_CHECKED"(Text) roster_type "INITIAL"(Text) Map unique_id "1.591111225E9_1922475623_INDIVIDUAL_RIDER_NOT_CHECKED_FINAL"(Text) row_id 3(Number (Integer)) event_timestamp "1.591111225E9"(Text) npi "1922475623"(Text) rider_type "INDIVIDUAL_RIDER"(Text) trinary_status "NOT_CHECKED"(Text) roster_type "FINAL"(Text)NOTE: I dont have an access to the big query where i can filter from initial stage .. but i have this data i only want to filter this retrieved data . 

I have uploaded multiple images in the document folder in my application using 'Upload File' option in the Action and Image Id of these images is stored in the database table. Now I want to display these images in the record grid for which I am using the below method in the 'Edit List' feature of the List option of the record: a!documentImage( document: fv!row[recordType!Car.modeldetails.Image] ) Where image is the name of column storing image IDs in the modeldetails database table. But by executing this I am getting the below text as the result in place of image: [@attributes=[@anyAttribute=[_cId:7ea9cd6ac69bf45fb67452fc4de3351f], @nil=], document=[Document:405304], caption=, altText=, link=, actions=, backgroundColor=, version=] Please help me as I want images to be displayed in place of text (image details).

wherecontains(null, {"a", "", "b"})   returns 2 i need to get an index of non null values , e.g. in above case it should return {1,3}

Dears, I have a problem in the calendar interface when the appian language is in ARABIC. The date shows and saves in Persian numbers such as : ١١٠٥٢٠٢٣. how can I keep the date language for all dates in English even though the user language still Arabic? the Persian numbers are causing me massive errors when I map them.

Hello  Team, In Appian  we have a Inbuilt function for sentiment score calculation for Text . "a!sentimentScore() " - only for text. And we do have Google Cloud Natural Language connected system to perform entity and sentiment analysis to collect information from HTML or plain text. But,my question is how do we calculate sentiment score based on voice. if the person who is taking Interview , how his voice is analyzed and get Sentiment score. Could you please help me in understanding How sentiment score calculate for Voice in Appian. Regards, J Vinay.

Hi Team, I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast  to Appian datetime type Regards Bihitak

Hi, We are trying to generate a CSV file from CDT and the first heading on the file starts with @ symbol. Now when I open the file in a text editor Appian/plugin adds some extra characters to it. How do I get around this? Example --  the file generated in Appian -  "'@ENB"NE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 The output we are expecting - @ENBNE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 Also, we don't want any space in front.

Where can we find the slide decks and other content from Appian world 2023? I attended Charle's Tsui's UX session and would like to reference those slides. 

I am getting the error some time page is opening it is getting reloaded after 3-4 sec and showing this error.

HI team, iam using Zoom connected system community.appian.com/.../zoom-connected-system How we get the recordings by giving Meeting id for locally saved? i have recorded a meeting and save it into local folder.so i know that cannot fetch the local files. but to get the recordings where should i save the recordings can anyone help me to get recordings. Thanks & Regards, J Vinay

Hi all! We need to send an email with a link that allows users to directly access the download of the documents (after authenticating in the application). instead of sending them as attachments. We have found the following discussion Appian Community and we have developed like this. We have included in our HTML template:       <a href="https://your environment/suite/doc/###docid###?appian_environment=designer">Download Document</a> and it worked. The problem is when we have moved to another environment. We have just updated the name of the environment:       <a href="https://new environment/suite/doc/###docid###?appian_environment=designer">Download Document</a> And now its not working, we got the following error:  Application Error We're sorry! We could not process your last request. There are no details available for this problem. If you continue having problems, please cont

Does anyone know why this Health Check Playbook article is not accessible? Has it been moved to another page? Was it decommissioned? Is there a link out there to a newer article? 

Does anybody know any Organization who develop Products using Appian? Please let me know. Thanks, Sarat Tumu

I want to convert a date from 2/JAN/2020  this format to  01/02/2020 this format. that is if the user adds the date in dd/MM(text)/yyyy , we have to convert it to MM/dd/yyyy  How can I achieve this

How to read data from sharepoint list to appian?Could you please suggest is there any functions or plugins or smart services?

We are trying to validate the Sorting on Grid Columns For this we are fetching the data of the column from DOM using web scraping   Example:   Column1: "Apple", "Apple1", "Apple0", "Apple_"   on sorting the Grid (say in Descending Order) We get: Column1: "Apple1", "Apple0", "Apple_", "Apple"   Which tells us that the order of preference when sorting is: '1' > '0' > '_' > ''   But the ASCII values are: Character        -        ASCII Value 1                -         49 0                -         48 _     

Hello, we are experiencing some very radical spikes and increases in the session count of a report that we have in Appian. In the graph you can see how the level of logged in users automatically increased in a matter of a few minutes to illogical levels and we believe that this may be slowing down the general environment. We have not detected a process, an Appian object that jumps us that could be the cause of said increase.

Hi, I am using Docx From General Template Smart service to generate document. The template which I used throws the below error on one particular work item and rhe rest all working fine. Unable to identify why the document generation is failed on one particular Item .Could anyone guide me to find the fix for this? Regards Martina

Hello, I have a wizard interface set up where each section of the wizard calls an interface rather than having all of the code in the same object. The interface object I call has a number of text fields that run an email notification process. The text fields are all working properly and all the input values are saved in rule inputs. (When I type my name in, and then move to the next field, the value I typed persists and does not revert back to the placeholder value). However, when I call this interface in my wizard, the value does not persist and reverts back to the placeholder value. What am I missing? Thank you, Jason Bongiovanni

I am trying to setup a connected system to an API provided by another client.  They're using OAuth 2.0, but they're expecting the client_id and client_secret in a JSON format, rather than the x-www-form-urlencoded which Appian is sending.  Is there a way to change this configuration somewhere?

Hi All, We have Appian on premise in my current organization . I am thinking of building a utility which can fetch tomcat logs in a Appian UI and user can search the logs on the basis of Appian UI search filters . Please let me know if any one of  you have done the same in past or if you have suggestions to approach this particular problem .

Hi, Can we shade the rows with different colors in READ-ONLY GRID based on condition? Thanks in advance.

Can anyone please explain  why Task will not show in the Tempo after it has been assigned?  Please have a look at the attached screenshots. Thank u all in advance. 

Hi Everyone, More curiosity about to know more capabilities about Appian compared to other workflow tool. For example, low code...etc features and capabilities. Thanks In Advance

Hi All,  As per requirement, I have to send data in CSV with pipe separated, but for decimal data as highlighted in screenshot, its appending with ' before the actual value in the decimal.  I'm using a DB view to construct the required data and pass it to Export Data Store Entity to CSV smart service in PM. In the DB  data is normal but while it's generated in CSV the below highlighted issue is observed. Any leads on this issue are greatly appreciated.  Expected --> -92333.00000 Actual --> '-92333.00000 Thanks & Regards Kumudini