Community

Hi, everyone Where can I find all the SQL codes used in Appian database which appeared in Associate Developer Practice Test. I'll appreciate it if some one can offer me a list of SQL or a URL. [emoticon:c4563cd7d5574777a71c318021cbbcc8]

I have a table have 50 columns, but i only need change one column of information of certain rows, i don't want to saveinto every column one by one, but one save that only columns, what shall i do for coding but not process model? Thanks

disabled:if(isnull(local!searchDeleteUserRole),true(),if(isnull(trim(rule!KONE_Development_userrolebackupexist_Rule(local!searchDeleteUserRole))),false(),true())), my rule is: a!queryEntity( entity: cons!KONE_Development_userrolebackup_Constant, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 5000 ), selection: a!querySelection( columns: { a!queryColumn( field: "name" ) } ), filter:a!queryFilter( field:"name", operator:"=", value:ri!name, ) ), ).data What I test from rule is always return empty, which I doubt is null value, however, if(isnull(rule!(local!value)),true(),false()), it should return true() since no value respond in the rule, but seems it always return false, so i doubt the rule always return with some not null value though it is empty. Which way I can make the empty value transfer to be null? Thanks

typename( typeof( 4.2 )) This some time return "Number (Decimal)", or return"数字（小数）"，how i can make it return English only?

Hello Everyone, I would like to display data from database view into interface without using grid. Can anyone please help me how to achieve this, the displayed must be editable as well. Thank You.

a!richTextIcon( icon:"arrow-down", link:a!dynamicLink( saveInto:{ a!save(target:ri!userrole.ROLE,value:fv!item.Role), a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userrole.NAME,value:fv!item.KONE_user_name), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(fv!item.KONE_user_name) ), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email, value:fv!item.Email), a

as title

May I know how to set process variable to be boolean in process model, plus it always return to be null value and failed to write to database by using process model.

Hi, Getting this error when adding a form to a page "An interface with rule inputs cannot be saved as a site page". Your help is greatly appreciated.

Hi,I'm new in tha Appian world.and I'm using the free site to learn.I would to extract all robotic processes through a web api and then list them in a custom table.I try to use a curl to test the following method https://docs.appian.com/suite/help/21.3/rpa-7.10/api/architecture.html but I don't know how it work I tried this curlcurl -X POST nqiz.appian.community/.../list -H "Content-Type: application/json" -H "Authorization: Bearer ${API_KEY}"The response is null, if add -v I noticed HTTP/1.1 400 but ther'isnt any message. Is there someone that can help me? Thank you very much

As title, which mean, once some condition satisfy, the button already submited without have to click it.

Hi Everyone, Can anyone please tell me how can I populate other fields in interface based on value selected in one of the dropdown field? Thank You

as title

Hi All, Can anyone please help me, how could I send an email to people consisting of all the warning messages the occured in process model and and if there is no warning message then a success message to be passed.

I update new table in my appian data store, but it doesn't shows up if i want to create constant by type of data store entity of specific type.

I accidently delete all my constant and datastore in my another application by click delete(which is so annoying why you don't mention it), now i wish to recreate the database and create constant by it, however, nomatter how did i do it can't find it in the data store entity. What wrong with it?

Hi, As part of my task, I want to loop over a process variable of type list of CDT and pass it as an input to a sub-process in a sequential manner for further execution (inside the sub- process). I am new to Appian and still exploring. Hence, bit of detailed reply/ link to any reference document will be helpful. Thanks.

title as above, code as: a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email,value:fv!item.Email), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Active,value:fv!item.Active), a!save(target:ri!userinputsheet.Language,value:fv!item.La

I am trying to pass a dictionary in expression rule as a rule input parameter, please help me locate its data type.

Hi Everyone, I am trying to update the fields in database from interface, but a new record is inserted into DB every time. can anyone please help me out?

I have a "donationamount" field in the interface. I want to put a condition that one person can make only 3-5 donations per year only , and also calculate and display how many donations are left for that person. Any suggestion on how to execute the above scenario?

Hi Everyone, Can anyone please explain me how can I get values from database in a dropdown field in a grid layout. Thank You

Good morning everybody, I have created an summary view interface, which has two RI (solicitud and expenses). So when i call the interface in the record type: , When I clicked in the list view, I obtained this error An Error Has Occurred An error occurred while retrieving the data for "AT Expense Report". Details: Expression evaluation error: Keyword and non-keyword arguments must not be mixed. Used in: recordbodywrapper. (APNX-1-4205-003) When I changed the setting (second screenshot) in the list view, I obtained this error  Error Evaluating UI Expression Expression evaluation error [evaluation ID = 7e51d:51052] in rule 'copypruebaexpenseinfo' : Could not cast from AT Expense Report to AT Expense Information. Details: AT Expense Report cannot be cast to AT Expense Information (APNX-1-4198-000) Could you help me, please and explaining me what is happening? Best regards,

seems I almost there, the problem I found is that the value i supposed to be saved for a!query is not the standard form. What should be the correct one? a!save(target:ri!userrole.USER_ID, value:cast(type!Integer, a!queryEntity( entity:cons!KONE_Development_userrole_Constant, fetchTotalCount:true, query:a!query( selection: a!querySelection( columns: { a!queryColumn( field: "USER_ID" ) } ), filter:a!queryFilter( field:"NAME",operator:"=", value:ri!userinputsheet.kone_user_name, applyWhen:not(isnull(ri!userinputsheet.KONE_user_name)) ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 50 ) ) ).data.USER_ID) ),

Hi Everyone, Can anyone please tell me how can I retrieve the pdf files as a link in the interface, based on the name coming from database table? The document is stored in the folder in appian. Thank You