Discussion Categories

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

Hi I am trying to find inactive users using getuserlastlogin function. It returns date for some user and for some user it returns null. Am I missing anything?

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" ) )

Hi, I have a requirement where I have to schedule a task i.e to activate RPA agent from the server on each day when server comes online, I have used task scheduler to trigger the agent but its not being stable as it is activating and deactivating the next minute, which is leading all the RPA processes to be in queued. Please update with any solution. 

only document id shown  is there any changes in Interface ?

redirect an link of tempo record to site 

Trying out record centric design for the first time and I have a multiple dropdown field on the interface. Using the recordType (no data yet, just structure) as a rule input does not allow for me to specify a field as an array (like can be done with a CDT). Is there a way around this or is it as simple as 'if a multiDropdown is involved a CDT must be ctreated?

How to following text into constant write it in a constant.. should i make separate constant for each double quote text>>  "sites/" & "workday-dashboard-config" &  "/record/"

Hi, I am currently using Appian 22.1.875 on Linux servers. Presently, my applications are using Oracle12, but now my DBA team is planning to migrate to 19c. Will there be any issues after the upgradation of DB to 19c? Has anyone tried this? Was there any impact on the existing applications in Production environment because of this migration? Please help. Regards, Chetana

We are trying to connect to a hive DB via a Rest API hosted in Openshift cluster, the .pem for the hosted environment have been imported to Appian environment via Client certificate and trusted certificate Still we are unable to establish the connectivity to the Hive DB due to SSL connectivity error. We have created certs for the Rest API hosted environment and imported the same to Appian , but still Appian is unable to establish the connectivity via Rest API call. Appian version used : 21.4 When trying to connect to the given host ip via openssl s_client -showcerts -connect <ipaddress> following was observed CONNECTED(00000003)write:errno=104---no peer certificate available---No client certificate CA names sent---SSL handshake has read 0 bytes and written 0 bytes--- Can we know why Appian is unable to connect to Rest api and what certs are needed for Appian to trust the cluster in which this Rest API is hosted?

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.

Hi Everyone, Created a webservice record without sync option, thinking getting records on demand would be best way to deal. created query rule , used as "Record Data Source" which has integration required inputs. when i tested record output  integration inputs showing it as user filters in records. i would like to show the record output in SAIL grid form and  should only get next set of records from integration when clicked  on next page button , how do i pass start index, batachsize parameters to Record Data Source query rule. any help would be appreciated , Thanks in advance.

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

Hello, is it possible to listen to an email address? Maybe something like, whenever there is an email with a certain subject then do something.

Can we hide a table along with its header dynamically in a word document if no rows are available for that table??

a!localVariables(local!x:{{name:"rajini",marks:25},{name:"vamshi",marks:30},{name:"rajini",marks:40},{name:"venkatesh",marks:88}},/*using index,wherecontains() need to fetch only rajini details*/)

Hi Folks, Have some queries regarding the Associate Developer Certification Exam(L-1). Have recently completed the Appian Developer course on the Appian academy and the next step for me is to get certified. Can I get to know some resources I will need to refer to before taking the test. What all tips do you have for the preparation and how does one tackle the preparation phase. What all things to do one has to keep in mind before giving the test. What is the recommended time that should be given to the preparation phase.  Really looking forward to learn and give the test to get certified, do share your feedback regarding the topic. Thanks and Regards

Hi, we are trying to refresh local variable value on var change but it is not working. PFB Code a!localVariables( local!refreshOnVarChange: false, local!allMessages: a!refreshVariable( value: rule!DS_QRY_getMessageThread( returnDatasubset: false, filters: a!queryFilter( field: "clientInboxId", operator: "in", value: {15,16} ) ), refreshOnVarChange: local!refreshOnVarChange /*refreshAlways: true, even in this case data is also not get refresh*/ ), local!textBox, a!sectionLayout( contents: { a!textField( value: local!textBox, saveInto: { local!textBox, a!save(local!refreshOnVarChange, not(local!refreshOnVarChange)) } ), a!textField( value: length(wherecontains(true,index(local!allMessages, "isRead", ""))), readOnly: true ) } ))

Is there a way to filter a grid on the rows that you selected or have not selected. Use case being if your grid is really large and data are on multiple pages. When you go through pages selecting items, maybe you want to filter by selected items to see all the items you've selected? Is there a way to make a selected filter? Not sure if this can be a user filter.

Hi everyone, I'm quite stuck at this part so I'm needing some helps [emoticon:6d505171faa4497c85c5ca27290c555d] I built an interface to show a report which data is from a view, the view looks like this table below:  Case Id Step  User doing this step Updated Date Time 1 Created Molly 11/11/2021 5:11 2 Processing John 11/9/2021 7:22 2 Pending John 11/3/2022 8:33 2 Completed Molly 11/2/2022 9:11 3 Created Nick 10/5/2022 13:20 4 Processing Nick 9/9/2022 9:09 4 Pending Molly 12/8/2021 6:12 4 Completed Molly 12/6/2021 6:12 4 Created Molly 22/10/2022  1:20 The interface does not show updatedDateTime + Step (business requirement), and was filtered by loginUser(), which is why I got this result of duplicating rows with same case ID and other columns all have the same values in the report for the same case. Is there anyway I can get the unique row using Appian if there are duplicating row in the interface?  Case Id Created date Related