General

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,

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? 

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 ?

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*/)

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.

Hello all, Is there a function or process within Appian to store and specific value for every user? (Similar to session variables in.Net,) the use case is: We have a dropdown with general values in our main page, so depend on the value selected all the subsequent pages needs to take care of that value. We want to store that value selected for every user in his own session. I did some research to use constant, but for this we need to create constant in sail code (in appian it's no possible, only update), it's not a good approach. Another thing that we discuss was to pass the value as a rule input in every object (interfaces, query rules, Process Models, etc) not sure if its a good approach since the user can go directly to other pages (saved as bookmark) even if no value is selected, but it's a must for our app. Another approach that we are thinking it's storing the value in a "customfield 1" but the function doesn't work "a!updateUserProfile()".

Hi.  On write to datastore for overwriting an EXISTING record I am getting the following error.  ids for this class must be manually assigned before calling save(): I see plenty of posts saying enable autogeneration, but don't feel this is appropriate given no autogeneration should be occurring on this entry and it already has a primary key filled in. If such a thing did work after enabling autogeneration, it seems to me that would mean something is going wrong and a completely new Entity is being saved. Am I wrong in this understanding?

Hi, here from line 515 if condition is executing but it's showing only highlighted one not the remaining conditions. it has to show the remaining list of data but not showing what might be the reason for that 

My Appian Community Edition site seems to have disappeared. Instead of the usual link to my instance, there's a "get my site" button. Did something happen to the servers?

Is it possible to capture the page level action?    Eg : When submit button is clicked - We get - "Action Completed" Message or Eg: When submit button is clicked - "Field 1 is a required field" How do we capture the messages? 

Both the a!startProcessLink and a!startProcess functions state that the "processModel" parameter accepts "a constant referencing the process model or a process model UUID" However, when we try to pass a constant of type Text with a process model UUID to the processModel parameter, we get a generic "The process does not exist, has been deleted, or you do not have permission to start it." When we pass a constant of type Process Model (using the same process model) to the procesModel parameter, we are able to start the process as expected. Do these two functions still accept UUID in the processModel parameter? If so, what are we doing wrong?

Hi, I'm looking for some developers who can spare a few minutes of their time to fill out this survey. Please know this survey will not be used for any monetary gains whatsoever. It's a little research that I'm doing for a project of mine.  The link; https://tally.so/r/nPRR1Q Thank you in advance.

I have a requirement like this    I will have a base version of XSD file available in the system and when ever i have a update to this file required , I need to mention the Change and send it for approval, ones the required approval is secured, the approved lines of code should be embeded in the base file "location defined" and consider the new version is published.    Help me if this requirement is feasible to achieve in appian , If yes what is the complexity or is their any quick way?

I would like to validate if a certain field is converted to mandatory or not based on the data entered in some other field of the form , Is there a method available in selenium API for doing this test validation.

As i am new to appian i have requirement ..  .All values of multiple dropdown should be pre - selected default.

Good day, I downloaded the Database Load Generator on the App Market and tried to import it on the environment, but I've been having data store error? anyone have suggestion/insights on how to solve this problem? I've also already added the plugins that are needed for this.

a!dropdownField( label: "POL", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!polDetails.pol, choiceValues: local!polDetails.id, value: local!pol, saveInto: { local!psl, a!save(local!selectedSubPol, null) }, searchDisplay: "AUTO", validations: {} ), a!multipleDropdownField( label: "Sub - POL", labelPosition: "ABOVE", placeholder: "--- Select Values ---", choiceLabels: local!subPol.subPol, choiceValues: local!subPol.id, value: if(a!isNotNullOrEmpty(local!pol),local!subPol.id,local!selectedsubPol), saveInto: { local!selectedsubPol, a!save(local!selectedsubPol, null) }) error is coming when i am un-selecting the default selected values . can somebody help me on this

Hi Team, I have a requirement to extract/read bar code from the user uploaded pdf file as part of the IDP process. Can you please suggest the possible solution to achieve this?

I have the above expression rule, and when I call it in my interface I am getting the value of [ID:7]. Is there a way to only return the integer value of 7? I'm sure this is probably an easy fix, I'm just very new to this

Hi Team, We are using "googleHistogramChartField"  by "Appcino Technologies" the requirement is  Is it possible to color the boxes (of reach composition) based on the overall risk (green, yellow, red) I was unable to find any setting for the same  https://developers.google.com/chart/interactive/docs/gallery/histogram can anyone suggest that how we can implement histogram in Appian without 3rd party plugin Regards Bihitak

Hello all. I am following the Appian online course and making a side project to practice. In the query data section for querying VehiclesAddedThisMonth it shows us how to query and filter a vehicle that was added this month. The problem I am having is that the field I am using is datetime and not date. Error: Expression evaluation error at function a!queryRecordType: Cannot apply operator [EQUALS] to field [createdOn] when comparing to value [TypedValue[it=1,v=10]]. Code: a!queryRecordType( recordType: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product', filters: a!queryFilter( field: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product.fields.{34fab307-ea54-4ea9-a01b-40a0706f32c7}createdOn', operator: "=", value: month(now()) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data Seems like the issue is that the operator cannot compare the month function to my datetime field however it is ok if the month compare to

Hi All, For my requirement , I have to create a stored procedure in database which executes a sql query. And I have to execute that store procedure in appian process model and have to save that output in  process variable to proceed further. While creating the stored procedure in Database ,I am facing some difficulties. If I just run the sql query in DB by passing value for input(task_id = 261),then it gives me output of 16 rows with 22 columns , I want that to be saved as output in my process variable as a result. For this query I written below code to create store proc, create or replace procedure test(i_task_id in NUMBER)ASBEGINselect column1,column2,column3,.... from xyz where task_id = i_task_id;END; But this shows me the error like PLS-00428: an INTO clause is expected in this SELECT statement. Can anyone kindly help me to solve this.Thanks in Advance.