SQL query count or value length

Novice User asked on March 21, 2022 23:50

I am trying to set a data source as SQL in a widget for multiple choice. Is a way to know that the data returned any results. I am trying to check the field's value length but it returns 0 even when there are records populating into controls.

data source sql

Recent Answers

Brenden Kehren answered on March 24, 2022 02:15

Can you specify what version and development model you are using?

1 votesVote for this answer Mark as a Correct answer

Novice User answered on March 24, 2022 15:32

Hi Brenden,

I am using version 12 with the portal engine model.

1 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on April 14, 2022 13:29

If you're doing this via C# code I believe there is a DataHelper class with a method to check if a data source is empty or not. If start with that before writing your own function.

0 votesVote for this answer Mark as a Correct answer