• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 10 subscribers
  • Views 2598 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

How can i perform null handing for Photos while fetching from Database

Harris

Hi,

I want to perform the null handling for the photos which are not available for a particular user.

Here I'm fetching an user details from a database, I intentionally made that photo field to null for a particular user then I'm getting the following error

ERROR:

Interface Definition: Expression evaluation error at function a!imageField [line 37]: The image at index 1 in an image gallery component [label=“Photo”] has an invalid value for “document”. “document” must not be null.

Code:

a!imageField(

label: "Photo",

labelPosition: "ADJACENT",
images: a!documentImage(
document: local!getemp.photo,
)

my requirement is, If the photo field is null for a particular user it should display empty and if the user is having a photo then it should display picture (This is not an user photo, this is a dummy photo which i uploaded from another interface to table)

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Hi Harish,

    I think I've got a treat for you. You can get the Appian default image document id by using the code sample below.

    a!richTextDisplayField(
  value: tostring(
    a!userImage(
      user: "userWithoutImage"
    ).document
  )
)

    Replace the 'userWithoutImage' with any user on your environment that doesn't have a photo. 
    It will give you the default image document id for the current environment. Now can store this id in a constant and use it with an if statement. 
    Where if the id from the database is null, you can pass the constant.

    But this won't work after the application is deployed on a new environment. So another thing you can do is to download this default document image using documentDownloadLink() function and upload it as a new document on Appian and map that document in a constant. That's a more stable way of doing it.

    Thanks,
    Harshit

Reply
  • 0
    Certified Lead Developer

    Hi Harish,

    I think I've got a treat for you. You can get the Appian default image document id by using the code sample below.

    a!richTextDisplayField(
  value: tostring(
    a!userImage(
      user: "userWithoutImage"
    ).document
  )
)

    Replace the 'userWithoutImage' with any user on your environment that doesn't have a photo. 
    It will give you the default image document id for the current environment. Now can store this id in a constant and use it with an if statement. 
    Where if the id from the database is null, you can pass the constant.

    But this won't work after the application is deployed on a new environment. So another thing you can do is to download this default document image using documentDownloadLink() function and upload it as a new document on Appian and map that document in a constant. That's a more stable way of doing it.

    Thanks,
    Harshit

Children
No Data

© 2024 Appian. All rights reserved.