Remove a results from formresult using the resultguid

Anferney Grotestam

unread,

Jan 22, 2025, 4:13:50 AMJan 22

to General WebHare developers discussion

We have a table in WRD in which we keep track of form submissions. Inside this table we also have a field with the resultguid aswell as a field containing the fileid of the form.
We have a dashboard in which we display these form submissions. We want to add a delete function to this dashboard so we can delete an individual result.

My question is whether it is possible to delete a formresult from a form using the resultguid from. Inside the WHFSForm objecttype i saw a function named DeleteResultsById which takes an integer array as parameter, but i wasn't able to find a function in which i can pass a resultguid to delete a result form the formobject.

Arnold Hendriks

unread,

Jan 22, 2025, 4:50:08 AMJan 22

to General WebHare developers discussion, anfe...@nubium.nl

As far as I can tell there's no API for that yet

Anferney Grotestam

unread,

Jan 22, 2025, 7:23:43 AMJan 22

to General WebHare developers discussion, Arnold Hendriks, anfe...@nubium.nl

Would it be possible to get an id from the resultguid that i can you in the DeleteResultsById function?

Op woensdag 22 januari 2025 om 10:50:08 UTC+1 schreef Arnold Hendriks:

Wouter Hendriks

unread,

Jan 22, 2025, 8:36:57 AMJan 22

to General WebHare developers discussion, Anferney Grotestam, Arnold Hendriks

Doesn't this do the trick?

`select as integer id from publisher.formresults where column guid = <the-guid>`?

Anferney Grotestam

unread,

Jan 22, 2025, 10:04:44 AMJan 22

to General WebHare developers discussion, Wouter Hendriks, Anferney Grotestam, Arnold Hendriks