how to sql query drop down list from bizform with document type

Khanh Kevin asked on February 8, 2018 09:10

I want to show form drop down list from bizform select Course_ID,concat(NamCourse,' - ',schedule,' - ',Location) From CMS_Course ORDER BY Course_ID Example:

I hope everyone can guide me how to do it Thank you so much

Recent Answers

Dragoljub Ilic answered on February 8, 2018 09:49

Hi Khanh,

If I understand you well, you should use drop-down list form control on your form and chose 'SQL Query' as datasource. SQL Query should be something like this:

SELECT UserID, CONCAT(FirstName,' - ',LastName,' - ',Email) AS Test 
FROM CMS_User

Also, it is important that in fields bellow (for 'Item transformation' and 'Value column') use proper values, like this {% UserID %} or {% Test %}. In your case, I will assume that all column names and tables are correct, so you should just add correct values.

Best regards, Dragoljub

0 votesVote for this answer Mark as a Correct answer