Discussion Categories

ValidationGroup is not working as expected, when applied against a file component. It is validating entire form and not restricted to fileUpload component only.  Requirement: When user clicks on "Upload File" button it should only validate file specific validations. PS: I did try setting Validate: false for button component. But it did not work.  Thanks for help in advance a!fileUploadField( labelPosition: "COLLAPSED", target: tofolder(ri!appianFolderId), instructions: "Please click on ''Upload File'' button to upload the file in system", validationGroup: "UPLOAD_VALIDATE", validations: { if( and( a!isNotNullOrEmpty(fv!files.extension), contains(cons!VALID_FILE_EXTENSIONS, upper(fv!files.extension)) ), "", "File extension is not supported" ), if( fv!files.size > cons!FILE_SIZE, "Attachment file size is more than 10 MB", "", ), }, value: ri!uploadedDocument, saveInto: { ri!uploadedDocument }, maxSelections: 1, ), a!buttonArrayLayout( buttons: { a!buttonWidget( l

How to pass parameters dynamically to HTML to pdf smart service?

What is the best way to study for the Appian development process models section ot the exam.  I have score very low in this section of the exam,  Thank you for your help.

Hi All, I am trying to fetch data from Oracle DB using a query rule with batch size as -1, but the system is throwing the following error : Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DataTypeName], query: [queryentity expression], order by: [[Sort[primaryKey asc]]], filters:[((Ts= TypedValue[it=9,v=3000-01-01 00:00:00.0]) AND (Valid= TypedValue[it=3,v=Y]))]) It had data of 147 rows and if I use batch size of 100 with start index 1 it's sometimes working but when I use startindex as 101 it's always failing with the above error.I am facing the same issue with some more tables from the same Oracle schema.Here I am attachinga!queryEntity( entity: cons!DSE_TABLE_NAME, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1, ) ), fetchTotalCount: true ) the sample Code I have used.

I want to create a password protected zip and while executing this plugin, it creates the zip but it is not password protected zip file. Also, while I trying to extract the files from zip, getting error for all the files in zip. I am facing the same issue with another plugin (Zip Utility -> Create Zip File) from same provider.Please check the screenshots below: 

I want to update a specific row in my recordtype with data in one of the columns as follows:  Here I am using my id (the primary key of the table) to specify which row I wish to update, in this case i want to update case number 80 and update the casestatus column with "accepted", however upon doing so I get the following error:  I am guessing that my syntax is incorrect, but I can't seem to figure out what I am doing wrong exactly.

Hi i am new to appian , I have been working on a activity where I have to generate document through ms doc from template smart service. This document generation was happening in a subprocess from there I am greeting the generated document id to parent process I am not sure whether this flow going right or not .Now I need to update this id to record for particular user like based on their profile id I need add this document which they will be able download through interface which will be another big task for a beginner . Can anyone guide me?

The error shows, functions a!grouping parameter 1 [ line 7]: the target is missing. Couls omeone help me with this. I have used the code exactly in the picture for W000QYD_GetVehiclesAddedThisyear

.

Hi If anyone knows why  strange value  show like that way, please let me know. Why did I get a strange value when I put datetime test data in the expression rule?What should I do with the correct test data?

I have a record type list - saved in local!displayitems it has 9 items and i am displaying it in the grid when I select the rows in grid it gets saved in the local!selectedrow variable  now, i am doing some manipulation and updating few fields in the selected rows and then wanted to save them to the local!display items upon button click , here is teh code, can you tell me what is wrong , since displayitems is nested , i flattened it a!forEach( items:a!flatten(ri!displayItems), expression:{ a!save(fv!item[recordtype.fields.preparedBy'], a!update( fv!item[recordtype.fields.preparedBy'], { index( fv!item[recordtype.fields.procedureReferenceId'], ri!selectedrows[recordtype.fieldsprocedureReferenceId'] ) },{ri!selectedrows[recordtype.fields.preapredby]} ) ) error:

When trying to import data from CSV to Oracle DB, getting  Error executing SQL java.sql.SQLSyntaxErrorException: ORA-00904: "column_name": invalid identifier . CSV File has headers and they are same as column names in DB table. Has anyone encountered this issue? Also noticed that the column names in sql statement are framed within " quotes like below Caused by: Error : 904, Position : 49, Sql = select "column_name1", "column_name2", "clumn_name3", "column_name4" from "table_name" where 1=0 , OriginalSql = select "column_name1", "column_name2", "clumn_name3", "column_name4" from "table_name" where 1=0 , Error Msg = ORA-00904: "column_name4": invalid identifier Note: Facing this issue only when file has headers in it.

I am using Export Data Store Entity to Excel smart service node. Could anyone please let me know if there is any way that queried value can be inserted into custom cells where the text is "Pull from variable".

Hi Team, What is the easiest way to get no of columns in all record in the application and also what is the easiest way to get no of nodes in a process model? Regards, Ghanashyam

We need your suggestions/inputs to implement the following use case: - Send confirmation link in email to Appian user - Without login, when the user clicks on the link in the email, we need to update the status in the Appian database (without opening any Appian pages) Please let us know the approach to implement this. Also, let me know in case you need any other details.

hi,  I have a custom check box written for my grid as i have nested loop , i a unable to implement the appian default selection check boxes.  here is the code,  a!richTextIcon( icon: "square-o", link: a!dynamicLink( saveInto: { a!save({local!selectedIndex},fv!index), a!save(local!selectedProcedure, append(local!selectedProcedure,fv!item)) } ), linkStyle: "STANDALONE", showWhen: tointeger(local!selectedIndex) <> fv!index, color: "SECONDARY", size: "MEDIUM" ), a!richTextIcon( icon: "check-square-o-alt", link: a!dynamicLink( saveInto: { a!save(local!selectedIndex,null), a!save(local!selectedProcedure, difference(local!selectedProcedure,fv!item)),} linkStyle: "STANDALONE", showWhen: tointeger(local!selectedIndex) = fv!index, color:"SECONDARY", size: "MEDIUM" ), This code actually , appends the index in the local!selectionprocedure  but when i unselect it , it actually removes the last

hi,  I have a child interface , that has a rule input just to update the data base. I am basically trying to select the rows from an editable grid and save them in this rule input which is not dependent on parent interface. it is handled internally in child interface.  Child interface rule inputs - ri!id and ri!selectedrows I am trying to configure this interface in the Landing Page ( Parent Interface ) , now from parent interface I wanted to pass only the id. how do I achieve it . I get an error, if I pass only id from parent .

Hello I've used the open task reports to get all the tasks assigned to a user, but the problem is if the user is assigned to multiple application they can see all the tasks in that report.Is there a way to show only tasks specific to application or specific to all the process models from that application and if you can provide some example would be much appreciated.Thanks in advance.

I came accross a behaviour where an appian object(integration) accessed by two different users having parameters data type in two different format Eg: user1 gets the data type format as "mm/dd/yyyy" and user2 gets the data type as "dd/mm/yyyy". Though their internationalisation settings are same and both users are accessing same object . What else could be the scenario for such behaviour? Above are images from two different users using the same objects.

Process: In Process Model, there is a ui task in which a main record is getting stored, now after this node there is an xorThe problem which I'm getting is in write to Records node after the xor, I have to write related record data of main record, I have configured in the input node and I'm getting the error 'The input “Records” must refer to record types with data sync enabled that use a database as the source. Received (*The record Type Name which is related to the the record given in Input)'the process will repeat based on xor, for 3 times it worked fine, got error in 4th timeThe source is db and is sync enabled.

Hi, We have on-premise environment. We`ve switched from Apache Tomcat to IIS as web server. Since then, when trying to open a site: .../suite/sites/hr-application/group/organization/page/employee-directory/record/...id.../view/summary we`re getting an error: DOCTYPE "... is not valid JSON appian Any idea, why this started / how to solve it? Kind regards, Nejc

When starting a process model from the web api, the process variable is []. Below I have attached the result for your reference.

We have a connected system in which daily a process will start to extract 3 table data from database table and place in a sharepoint folder location.But on a particular day,it didn't extract the data and throw an error like this"class javax.net.ssl.SSLException connection reset".What is the issue and how to resolve?

can we create 2 scheduler's in one PM ?