Discussion Categories

Hi Developers,  I have one query, is it possible to add query string with appian portal url and later we can use that query string data for further use?? thanks

how can i add the UID table which is present in the another data base tables  like employee personal details database base record doesn't have the UID table which i want in the my employee personal details but it was present in the employee UID details database how can i get that ?

Hello All, I'm facing this issue while opening the application which contains CDT's, groups and DS. The System Has Encountered an Error HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = a5eb9:bc758] : Appian object error. Details: Failed to execute query in thread for: EngineBackedQueryExecutor [queryKey=DESIGN, typeIds=[23, 80, 200], transformTypeIds=[23, 80, 200], refClasses=[class com.appiancorp.type.refs.ProcessModelRefImpl, class com.appiancorp.type.refs.DatatypeRefImpl, class com.appiancorp.type.refs.ProcessModelFolderRefImpl], reducedExecutor=[ReducedExecutor extended-process-design-service:Process Model,Data Type,Folder (Process Model)]] Please let me know how to resolve this issue. Thank You, Sneha.

I took my appian level 2 exam a few months ago. And it is valid only for 2 years as far as i know. I heard that validity can be extended by following some courses. If anyone know about it please help me with the relevant link of those courses. 

Hi All,  I want to know how our pdf template should be if I'm using   "PDF Doc from Template" smartservice

Hi everyone, How to get name and link of environment (Test/Dev/Pro) that using Thank you.

Hi all, I am trying to take a date value from a DB(which I am writing in the Expression value below) and once I am inputting it in rule input it is changing my date value(Refer Value field):   Can anyone guide me what I am doing wrong, I need 03/10/22 as an output. Thank you.

Working with a student who accidentally deleted an images folder. He can put the images back but they all have new ids, so the table which stores the id numbers is now woefully out of date. Is there any way to assign an id to an image, so that the images we recreate will have the same numbers as the table?

Hi,I have a custom output node in a process model which is calling an expression rule which takes one rule input of type Map list.    The expression rule generically updates some fields within the map.    We are able to pass a list of any custom data types into this expression rule and Appian happily cast from CDT list  to Map list.   The output node  target process variable is defined as a list type of CDT (same process variable value passed to the expression rule is being updated).   Appian process model will not implicitly cast the expression rule return value back into list of CDT and in fact magically wipes out the process variable completely.   If I add an explicit cast function call in the custom output expression it works fine.   With the expression world is good and getting correct results. cast( 'type!{urn:com:florencehc:types:SC}SC_Request?list', rule!SC_setAuditFields(request: pv!request, act

here in the save contracts in header table am saving multiple contract_id to the table at a time. but SP will execute only one contract_id at a time to load the data to another table... so i want to execute SP for all the contract_id... it can be possible using for each id SP has to execute ? if so let me know how can i achieve this  here we can use script tasks if required.  so i can query all the contract_ids.. but how to execute this SP for each of those items 

If I'm using a deprecated smart services, how can I check it in my app if I'm using it? For example: Export SQL to Excel and [Deprecated] Export SQL to Excel What would be the difference? Would you throw me any warnings or errors?

what mistake i have done here when ever i try to select it is not selecting once i select it is deselecting again even i have checked with this.. this also same issue

Hello Community, Do you know how can I get the value from a record user filter? Basically I have several user filters for my record and when displaying them in a interface, I want to have some logic based on the user selection. From the image above, my question is how to get the selected value for Team filter ? Thank you 

Has anyone tried to embed a video player that would play WAV files?  We have a need to do this.

Please let me know how do I pass apostrophe in Inputs parameter  for executestoredprocedure function ocal!sp: fn!executestoredprocedure( dataSourceName: "jdbc/DRO", procedureName: "procCSS_Search", inputs: { { name: "ssn", value: ri!ssn }, { name: "lastname", value: ri!lastName }, { name: "firstname", value: ri!firstName }, { name: "caseid", value: ri!caseId }, { name: "primaryCauseTF", value: ri!primaryCauseTF }, { name: "causenum", value: ri!causeNum }, { name: "oagnumber", value: ri!oagNumber }, { name: "personid", value: ri!personId }, { name: "phone", value: ri!phone }, { name: "casestatus", value: ri!caseStatusCode }, }, timeout: 300 ),

Hi, I am trying to create an Integration object in Appian. How can I make these parameters dynamic based on the environment. I would like to pass different parameters based on the environments like DEV, UAT and PROD. All these environments will have different urls. How can I achieve this.

Hi @all, Is there an easy way to separate out users and groups from a Main Group in an expression rule.  Below are the users and groups coming from a group itself. I want to separate out users from this list and wants to store it. Looking forward for your support, Thank you in advance!

Hi All, here i using Milestone for my App in Summary(view) interface, so based on status value the Milestone Bar should work.  in table, "status" containing statuses: "Assigne", "Approved", "Return" and "Reject", which represent the different statuses of a request. I have the requirement of a milestone where first step should always be "Addproduct", then next possible steps shown are "Approved", by Manager and "Approved" by supplier it will complete. but when shopmanager "Reject" show like. >   similarly, Supplier too, 

Hi all,  I'm creating an interface that records and calculates the working hours for employees, the idea is if the working hours are less than 8 it should display: " Working hours are incomplete " , and if it was less than 0 it should display: " insert your working hours correctly please "  I made this expression, but when the value is less than 8 even it was less than 0 it always display : " Working hours are incomplete "  here's the expression:  { a!richTextItem( if( ri!WorkingHours = "8", "Working hours are complete", if( 8 > ri!WorkingHours > 0, "Working hours are not complete", if( ri!WorkingHours < 0, "insert working hours correctly please" ) ) ) )

Hi, I am trying to export Appian code from existing server and Import to the new server. In the Import process I have encountered with an option "Import Customization File (PROPERTIES)".  Where can I get this file. Do I need to Import separately or will it included in the Exported code. Can someone advise. Thanks.

Hii All, Can anybody help me how  to Implement pagination in Editable Grid?

Hi All, We are facing the errow : A null parameter has been passed as parameter 1 at function a!fileUploadField. Is anyone aware what can be the possible scenario for this error? Kindly advise. Thanks and Regards,Diksha

Hi everyone,  I think the Appian build-in Manage Filters feature is quite handy for saving and setting default features, however I've got some questions that need to be clarified (attach below the photo to not confuse you) 1. Is there anyway that I can check the DB that save these filters? 2. I'm going to add a new user filter into the list of existing user filters, will this action affect the saved filters record, I mean will it delete all saved filters in the DB and empty the My Filters tab (red highlighted ones)? And Is there anyway for me to I test this case when I have no saved filters exist? Thanks for your helps!

Hi team I'm needing some help with getting an interface together to populate a simple table for collecting survey data. I have a list of software titles divided into categories. Each category will be surveyed individually, until we have gone through the entire list of titles - this is to avoid providing our users with a massive task! Likewise I do not want to send through a task for each individual title in a category. Here is the concept model for what I want to do: The survey result CDT looks like this: I have been thrashing around for the past few days with Editable Grids and Read Only Grids, and am experiencing the following issues: With an editable grid I can put a dropdown into the column but I do not know how to generate an individual row for each title. With a read-only grid I can get the individual row for each title but I do not know how o set up the dropdown or equivalent for my users to be able to choose their response I have tried various approaches and

Anyone send me links for performance of record type and how many types? and how to do it?