Discussion Categories

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 ?

I am getting the error: Details:  Invalid Cast: Cannot cast from type 'Document' to type 'Content Constant' (Data Inputs) When trying to replace the constant contents, which is a constant that is a list of Documents. How do I fix? It doesn't work for replace version yes nor no. 

Hi, I'm trying to replicate the image column in the Acme exercise. But this expression: if( a!isNullOrEmpty( fv!row['recordType!{99497132-80a2-4706-85d8-9d65360812d4}VehÃ%ADculo de W2690.fields.{664fc039-9187-4150-90ce-6d589788d0c2}image'] ), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row['recordType!{99497132-80a2-4706-85d8-9d65360812d4}VehÃ%ADculo de W2690.fields.{664fc039-9187-4150-90ce-6d589788d0c2}image'] ) Is showing me this error: "Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 87]: User Does Not Have Rights to Perform this Operation" What am I doing wrong?

Is there any built in functions or smart service to retrieve the list of table names, number of tables, number of columns in all table and the list of all columns in a table from Appian Cloud Database?

can some one explain why jpa annotations are mainly used in appian and tell me some scenerios where it is most useful

Hello. My question is, can I change the default body for the 404 NOT FOUND error? Appian default response looks like this: If I want to return a custom JSON instead of the text "404 - Not Found", can I do that? Is possible to change the default body errors for the 404 or others http errors? Thanks in advance!

I am trying to use the java selenium code into Fitnesse (fixture file intergration from Selenium), but observing that when we are running the Fitness test which we imported getting "could not find fixture : import" response. Below are the steps we are performing: Step 1:  Created user credentialls parameters and url functions in Fitness.  Step 2: Verification - Just launching the webpage and passing the user credentialls, after that we are just verifying the tittle. Step 3: All the validation we created in Selenium using two classes (first class created as fixture class and added all objects and parameters, same first class extended into second class where we just prformed login operations and verified page title) Step4: Added all required Jar's into Selenium . Step4: Added all required Jar's in Fitness test along with import method. Step5: Running the Fitnesse test. Step 6: After running the test getting "could not find fixture : import" res