RE: Survey App

Appian AppMarket — Wed, 12 Jul 2023 22:00:46 GMT

v20.0.2 Release Notes

Added support for Records
Deprecated the use of CDTs
Deprecated the use of database views
Improved UX in creating new surveys
Improved process model memory utilization
Improved documentation

RE: Survey App

Appian AppMarket — Wed, 28 Jun 2023 22:00:11 GMT

v2.0.0 Release Notes

Added support for Records
Deprecated the use of CDTs
Deprecated the use of database views
Improved UX in creating new surveys
Improved process model memory utilization

RE: Survey App

Stephen Kane — Wed, 07 Sep 2022 07:12:28 GMT

I need to know whether a survey produced in this app can be used by non Appian users please?

RE: Survey App

fredericon — Thu, 21 Jul 2022 07:37:22 GMT

Hello,

I'm facing some issues importing this application to Appian 22.1 (getting some errors). Is this still available for latest versions ?

RE: Survey App

aneeshv713 — Fri, 21 Dec 2018 19:55:29 GMT

I fixed the issue with the SQL Query and wrote it in this format to create the view.

CREATE OR REPLACE FORCE VIEW APPIANETASC_BLAB_WRITE.SRVY_SURVEYRESPONSESVIEW

(

ID,

SURVEYID,

SURVEYEEUSERNAME,

RESPONSEDATETIME,

ISUPDATED,

ISIGNORED,

STATUS,

QUESTIONID,

QUESTIONTYPE,

QUESTIONLABEL,

ANSWERVALUE,

QUESTIONOPTIONID

)

SELECT CONVERT (

'id',

response."surveyId"

|| ':'

|| question."questionId"

|| ':'

|| ( CASE

WHEN answer."answerid" IS NULL THEN -1

ELSE answer."answerid"

END

|| ':'

|| CASE

WHEN VALUE."answervalueid" IS NULL THEN -2

ELSE VALUE."answervalueid"

END),

'UTF8'),

response."surveyId",

response."surveyeeusername",

response."responsedatetime",

response."isupdated",

response."isignored",

response."status",

question."questionId",

question."type" "questionType",

question."label" "questionLabel",

VALUE."value" "answerValue",

questionoption."questionoptionid"

FROM "SRVY_SurveyResponse" response

LEFT JOIN "SRVY_SurveyAnswer" answer

ON response."responseid" = answer."surveyResponseId"

LEFT JOIN "SRVY_SurveyAnswerValue" VALUE

ON answer."answerid" = VALUE."surveyAnswerId"

JOIN "SRVY_SurveyQuestion" question

ON answer."questionId" = question."questionId"

LEFT JOIN

"SRVY_SurveyQuestionOption" questionoption

ON VALUE."value" = questionoption."value"

AND answer."questionId" = questionoption."surveyQuestionId";

But , now I get an error when I click on Responses View in the Record --> 2018-12-21 19:47:52,470 [ajp-nio-8009-exec-9] ERROR com.appiancorp.rest.record.data.RecordRestService - Unable to retrieve record summary for record w/ type RecordType [id=921, uuid=66256e67-ee8a-412d-b851-9634390896c6, name=Survey, sourceTypeStr={http://www.appian.com/ae/types/2009}DataStoreEntity, sourceUuidStr=d8579ffe-2fa5-421c-940d-ba2eaa0feaa2@_a-0000dad0-86bd-8000-7e03-010000010000_3187] and id 1

com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error in rule 'srvy_getsurveyresultsforsurveyid' (called by rules 'srvy_uigridshowsurveydata' > 'srvy_uirecordresultsview') at function a!queryEntity_18r3: An error occurred while retrieving the data. (APNX-1-4198-000)

Caused by: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'srvy_getsurveyresultsforsurveyid' (called by rules 'srvy_uigridshowsurveydata' > 'srvy_uirecordresultsview') at function a!queryEntity_18r3: An error occurred while retrieving the data. (APNX-1-4198-000)

Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred while retrieving the data. (APNX-1-4261-002)

Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unexpected error executing query (type: [SurveyResponsesViewDT21324], query: [queryentity expression], order by: [[Sort[surveyeeUsername asc]]], filters:[(surveyId = TypedValue[it=1,v=1])]) (APNX-1-4164-028)

Caused by: org.hibernate.QueryTimeoutException: could not execute query

Caused by: java.sql.SQLException: ORA-01482: unsupported character set

When I look at the error , it seems to be coming from the CONVERT statement in Oracle.

SELECT CONVERT (

'id',

response."surveyId"

|| ':'

|| question."questionId"

|| ':'

|| ( CASE

WHEN answer."answerid" IS NULL THEN -1

ELSE answer."answerid"

END

|| ':'

|| CASE

WHEN VALUE."answervalueid" IS NULL THEN -2

ELSE VALUE."answervalueid"

END),

'UTF8'),

Anyone knows how to fix this error?

RE: Survey App

April Schuppel — Mon, 17 Dec 2018 20:46:28 GMT

Hi [mention:0fbb7d3ec2d0432f886f0363f406d689:e9ed411860ed4f2ba0265705b8793d05], I suggest you post your question in Discussions community.appian.com/.../ - it will get more visibility there!

RE: Survey App

aneeshv713 — Mon, 17 Dec 2018 20:21:53 GMT

Can someone send me the MySQL scripts converted to Oracle on this? I keep getting errors when I convert them myself.