Discussion Categories

 i want to add the three fields into like eg firstname, middlename, lastname into one field as full name

Hi everyone, I have an interface which displays a list of documents (UI_ListOfDocument), and originally user need to choose one document in the list to preview it (UI_Preview  will be displayed accordingly showing that chosen document's content), then click back to the list to choose another document for preview.  The request is to create a pagination in the existing interface, so that user just needs to click the pagination buttons to see the next/ previous document preview. I already built the interface for the pagination, but was having trouble in linking the document to it to make it work.  Currently, all related document from the data table are queried using a!queryEntity(), and are saved in a local variable, including it's content.  If anyone has done this before, please leave an advise if possible. Thanks for your helps [emoticon:6d505171faa4497c85c5ca27290c555d]

Hi, Can anyone let me know the following regarding rdbms logs? I can see multiple rdbms logs created for a day, will these files merged before they are converted to .gz at 11:59 PM when exactly does the merging happen?

Hi there! We are looking for a plugin for QR Scan, We need scan and detect a QR from appian interface. Have we any way to do that? without take or upload photos? Usually we have seen this in many apps and Appian should have a way to do that. Thanks in advance!!

In the editable grid I want to add 2 rows on click of add row link, please help me out how to add dt ?

In an interface intially we didnt use this field for file upload and it displayed like below , all the upload buttons are greyed out. Later we used Disabled : false() for the same fileUpload and the out come is as below, upload button is enabled By default as it should be false and the upload should be enabled,but it was grayed out. Can anyone explain why it was like this

I have this stored procedure output where the column names are dynamic and may vary according to date range and the column names also have to be printed in the interface in Appian So can anyone help me with the way to print the field names in a dynamic way?

while trying to generate excel through smart node - EXPORT SQL to EXCEL,   i am getting the below error in process - The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,5] that is already written to disk.  And getting the below error in interface - {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}  

Hi, I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text. When i try to verify the datastore, it is giving me the below error The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain. any help is appreciated.

Hi Everyone, I have a read only grid which is connected to Pie chart. When I open the report it should show all the rows with the selected filter but it is empty as below. When I click on any slice in pie chart, the grid is displaying the respective rows  These are filter options I have used in my grid configuration Please help me how to all the rows with selected filter (isresigned)  in the read-only grid when opening the report. 

Hi, I want to have a ri!startDate, I will use the a!isNotNull function to display some warning message if the ri!startDate is null else will retrieve the weekday(ri!startDate) but I keep encountering the error message such as Cannot sub incompatible operands of type Date and type Text. below here is my code for the interface a!localVariables( local!weeknum:if(a!isNotNullOrEmpty(ri!startDate),weeknum(ri!startDate),{}), local!day:if(a!isNotNullOrEmpty(ri!startDate),day(ri!startDate),{}), local!month:if(a!isNotNullOrEmpty(ri!startDate),month(ri!startDate),{}), local!year:if(a!isNotNullOrEmpty(ri!startDate),year(ri!startDate),{}), local!dayofWeek:if(ri!startDate=null(),"Please Select a Date ", weekday(ri!startDate)-1), local!startWeekDay:if(local!dayofWeek1,ri!startDate-local!dayofWeek+1,{}), local!endWeekDay:local!startWeekDay+4, local!monday:local!startWeekDay, local!tuesday:local!startWeekDay+1, local!wednesday:local!startWeekDay+2, local!thursday:local!

How can i get the data from the api into the interface ? like in my scenario i want the movie details once i enter my movie name , and the thing as i had created the intergration using the link and it's working .now i just want to know how can get the values in my interface once i click the movie and submit button.

We have a solution based on record centric approach, hence all the database tables are mapped to Records, which have relationships too that vary from 3-4 per record to 10-11 on some of the records. All the interfaces are using records to display the data, recently an issue has been occurring while retrieving the data from records has become dead slow, causing time-out errors, or sometimes the interface takes forever to load. I have looked into the performance logs and server logs for any related cause and made certain performance improvement changes too but the issue still persists. The issue occurs intermittently, hence it is hard to figure out the exact cause of the issue. I'm looking out for what could be causing this and the best solution for this problem. Thanks in advance, your help is highly appreciated.

We have what is effectively an API broker or proxy tool between our Appian instance and an API we consume.  The broker/proxy requires API Authentication to properly identify our system and allow access to the API's that it brokers.  It does not however leverage it's own API keys to the services it represents.  As a result, we have to pass a second API key through as a header.However, I have security concerns about the storage and security of this second key. Has anyone had experience and advice to secure this secondary key?  It appears as clear text in the request headers,  must be available in the integration or connected system (unlike the primary API key - which is masked and unreadable in the Connected System), and I cannot use the secure credential store to secure it.  Even if I store it in a constant,  I'm concerned about the potential security. Advice greatly appreciated.

Hi, I have a decimal field on my interface that I want to colour based on its value..something like if =8: then green if <>8: then blue How do I do that??  I know how to colour a text field. Please help thanks jaideep

Hi, Is there a way I can see on Appian logs as to who has made changes to the data.. for eg.. who created a certain record, who updated it, who deleted it and so on.. i tried looking for this info in tomcat-stdOut.log but cudn't get.. or do I need to create/code my own history table where I should track these user actions? thanks in advance jaideep

I have implemented service backed record with daily sync enabled. But the data at the source(service) gets added frequently(in minutes) and the customer want to see the updated data in Appian once its get added at the source. I have gone through documentation where I saw "Sync Changed Data". Could someone help in achieving "Sync Changed Data"? Additional Information: 1) Identifiers of the data being returned by the service are not sequential but random in ascending. (Identifier's are unknown if I need to use "Sync Record" smart service) 2) Full Data Sync takes around seven minutes. (for now there are around 180K records being returned by service, in prod it will be around 490k and will increase)

how can we achive pagination in layout grid without using foreach?.

Hi On my process modeller, whenever I debug the process model, the Process Start Form does not display, the process continues to the next steps without the option to populate the form. Is there a setting for enabling and disabling the Process start form or is this just in my environment? Thanks in advance

I ran into small copy and paste typo in Appian 22.3 docs. Don't know where to submit this, I know it's not really a question. Hope someone can route this to right team correct it.  https://docs.appian.com/suite/help/22.3/Oauth_connected_system.html  https://docs.appian.com/suite/help/22.3/oauth_client_credentials.htmlIn this case it think it should mention Client Credentials Grant instead of Authorization Code grant. 

Hi, can anyone teach me how to retrieve the week range based on the weeknumber and year. For example, the user selects a date. I use the weeknum(ri!startDate) already retrieve the weeknumber and the year(ri!startDate), so I already have the weeknumber and the year already, how to retrieve the date range from the week number and year ? such as 11/11/2022, week number is 47 and the year is 2022,  how to we retrieve the date range like " 7/11/2022 - 11/11/2022 ? anyone can help or assist me [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi All I am currently working on version 22.3!! I have a use case wherein one of my current process is started when an external system sends email on the process model id i.e.: processmodel<id>@companydev.appiancloud.com( here dev represents the Appian environment). The requirement is that:The system can receive external mails using company's SMTP i.e. @company.com rather than @companydev.appiancloud.com.  Would like to know is there a way I can do this? I have read the the topic "Legacy configurations" in the link below but I am not able to understand what does reply-to-address means and will it even help me in my problem: https://docs.appian.com/suite/help/22.3/Sending_an_Email_Message_to_a_Process.html#starting-a-process-using-an-email Thanks in advance!!

I have a string "a,b,c" I want to convert that to array of string.

Hi everyone, I'm having above error message after using a!todatasubset(), my code is as below:  local!pagingInfo: a!pagingInfo( 1, 1, a!sortInfo( field: local!emailsRelatedToCase.id, ascending: false ) ), local!datasubset: todatasubset(local!emailsRelatedToCase,local!pagingInfo ), within that, local!emailsRelatedToCase stores data queried from a database to get email IDs and relatedCaseId, sentFrom, sentTo, dateTime for each email. Did anyone see this error before? Thanks a lot,

hi,  I have built a bar chart with a simple measure of SUM of time but when I put the labels I see a value like 47.9499999999999996 I have checked the issue is not with data.. I do not have that kind of data. I have a solution that I round off the the time taken, store it in another variable and use it for SUM and it works.. but I cannot individually round off the time field.. the overall data deviates a lot. All I need is to round off the above data to 47.95 .. when I see the expression generated by the MEASURE function on the chart I see Is there a way i can modify this expression so that it returns a value upto 1 or 2 decimal places.. I tried using round func in this expression but that's not working thanks much  jaideep