Foundation

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?

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 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. 

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 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 want to Complete the empty space to save space, what are the best practices?

I have a read-only grid which should show all the rows with filter (isResigned) when I open the report. Along with that I have pie-chart in the same report based on last working date. So, now when I click on pie chart the read-only grid should be updated based on my selection.  I am able to get the full report with filter isResigned but when I select the column the read only grid is not getting updated.

Hi, I have setup a timer to run "Daily" and "Every weekday" at 4 PM. This should trigger a email notification. But, I am receiving an email notification on every day at 5:30 AM EST.

a!localVariables( local!data:rule!VG_CRK_RT_get_all_srvc_nm(), local!exportDocId, local!errorMessage, local!flag:false(), a!formLayout( label: "", contents: { a!sectionLayout( label: "", contents: { a!radioButtonField( label: "Select Any Option", labelPosition: "ABOVE", instructions: "", helpTooltip: "Before Uploading, Download a file for service, to view latest data", choiceLabels: {"Download", "Upload"}, choiceValues: {false(),true()}, value: ri!isUpload, saveInto: {ri!isUpload}, required: true, choiceLayout: "STACKED", validations: {} ) } ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { "Before Uploading, Download a file for service, to view latest data" } ), a!dropdownField( label: "Service Name",

how to validate a text field which can be  A,B,C,D, Null, or groups of A,B,C,D (ex. ‘A,B,C’ with commas no space).

I have table by name abc which have columns id(pk),refId(FK),uniqueId,languageId,locationhere language Id is : id for languages ex: english =1 , french=2, hindi=3 etc unique id is: if say for refId(fk) there are 5 location then unique id is 1,2,3,4,5 for language id 1, unique id is 1,2,3,4,5 for language id 2, unique id is 1,2,3,4,5 for language id 3 etc so here my requirement is based on selection of ref Id I want to add location using grid but here challenge is user can allow to add location in all available languages and need to maintain uniqueid's same.one thing need to consider is unique Id should be the next number to existing unique id for that particular refId.Please do help, am struggling to implement it.                                                                        &

In a gridField() fed by record data, when you try to use the disableRowSelectionWhen param, record references fail to be evaluated. As an example, we were trying to disable row selection based on a date time in the record data. Originally we had it wrapped in a todate() so we could compare it to a date, but the logic was failing to disable the desired rows. Just for fun we removed the todate() around the record field reference, only to be smacked with an error about not being able to compare Null to a date. That's right, the record reference evaluated to Null. For more fun, we tried using fields that were not dates, and the same thing happened on integer fields, i.e. the record reference evaluated to Null. Has anyone else run into this? 

HI All,  I have SAIL form with summary details and  a grid.  i have a add card layout button above the grid which will open different process to add data. when Calling Process model using a!StartPRocessLink service under add button(card layout) from Parent Sail form which mostly read-only info. when i click on Add button , i receiving a message saying you would like to leave from this page., looks like its browser message.  navigate to chained forms/process model and once added data its expected to come back to same form. Please suggest how can i avoid such message, Thanks in advance.

how to redirect to site record page by using record link. a!linkField( links: a!recordLink( label: fv!row['recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type.fields.{986b4d5b-200e-4665-a365-33808cab1533}name'], recordType: 'recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type', identifier: fv!identifier, dashboard: "summary", openLinkIn: "NEW_TAB" ) )

only document id shown  is there any changes in Interface ?

How do i start a process from Email by assigning Receive message event by sending a mail to my process model UUID the process should start!

Hi Guys, Please lemme know .., what are the roles & limitations of activity chaining ? in which kind of scenarios we use activity chaining? in which kind of scenarios chaining may break generally?

An e-mail could not be sent because the run as user for this activity could not access one or more of the groups listed in the e-mail address.

in a process i have two  user input tasks let first is x and second is y now i have scenario 1) where the user 1 completed X then he only need to complete Y or where the user 2 completed X then he only need to complete Y 2)when the user 1 complete X then we have to restrict to complete Y by  the user 1 or  when the user 2 complete X then we have to restrict to complete Y by  the user 2