• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 11 subscribers
  • Views 5193 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

How do I strip all html <tags>

Brandon

We currently have a process where users enter comments in rich text format into a portal form. We save this in Appian PVs and also write the comments to an SQL table.

We are slowly moving to Tempo and have built a tempo form that displays all the comments in a grid (values retrieved from the SQL table using a query rule). But the problem is that we see all of the HTML tags displayed. Is there a way to display the comments in rich text format? or as last resort some way to remove all the HTML tags?

thanks

thanks

OriginalPostID-215413

OriginalPostID-215413

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi

    I hope you can help a little more here.

    I am trying to use the fn!striphtml function but cannot get it to work with my query entity expression that I have for my records (shown below)

    Is it even possible to do it as part of this expression, or will I need to manipulate/retrieve the data some other way?

    with(
    local!datasubset: a!queryEntity(
    cons!INS_ENTITY_POLICYNOTESLOG,
    a!query(
    selection: a!querySelection(columns: {
    a!queryColumn(field: "Notes"),
    a!queryColumn(field: "NotesUser"),
    a!queryColumn(field: "NoteType"),
    a!queryColumn(field: "DateTimeStamp"),
    }),
    filter: a!queryFilter(field: "ApplicationNumber", operator: "=", value: ri!ApplicationNumber),
    pagingInfo: local!pagingInfo
    )
    ),
    a!gridField(
    totalCount: local!datasubset.totalCount,
    columns: {
    a!gridTextColumn(
    label: "Note",
    field: "Notes",
    data: index(local!datasubset.data, "Notes", null)
    ),
    a!gridTextColumn(
    label: "Note Type",
    field: "NoteType",
    data: index(local!datasubset.data, "NoteType", null)
    ),
    a!gridTextColumn(
    label: "User",
    field: "NotesUser",
    data: index(local!datasubset.data, "NotesUser", null)
    ),
    a!gridTextColumn(
    label: "Date",
    field: "DateTimeStamp",
    data: index(local!datasubset.data, "DateTimeStamp", null)
    )
    },
    value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    )


    thanks in advance :)
Reply
  • 0
    Hi

    I hope you can help a little more here.

    I am trying to use the fn!striphtml function but cannot get it to work with my query entity expression that I have for my records (shown below)

    Is it even possible to do it as part of this expression, or will I need to manipulate/retrieve the data some other way?

    with(
    local!datasubset: a!queryEntity(
    cons!INS_ENTITY_POLICYNOTESLOG,
    a!query(
    selection: a!querySelection(columns: {
    a!queryColumn(field: "Notes"),
    a!queryColumn(field: "NotesUser"),
    a!queryColumn(field: "NoteType"),
    a!queryColumn(field: "DateTimeStamp"),
    }),
    filter: a!queryFilter(field: "ApplicationNumber", operator: "=", value: ri!ApplicationNumber),
    pagingInfo: local!pagingInfo
    )
    ),
    a!gridField(
    totalCount: local!datasubset.totalCount,
    columns: {
    a!gridTextColumn(
    label: "Note",
    field: "Notes",
    data: index(local!datasubset.data, "Notes", null)
    ),
    a!gridTextColumn(
    label: "Note Type",
    field: "NoteType",
    data: index(local!datasubset.data, "NoteType", null)
    ),
    a!gridTextColumn(
    label: "User",
    field: "NotesUser",
    data: index(local!datasubset.data, "NotesUser", null)
    ),
    a!gridTextColumn(
    label: "Date",
    field: "DateTimeStamp",
    data: index(local!datasubset.data, "DateTimeStamp", null)
    )
    },
    value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    )


    thanks in advance :)
Children
No Data

© 2024 Appian. All rights reserved.