Web Part Fields Dependent SQL Queries

Delford Chaffin asked on February 24, 2016 21:17

If I have a property on my web part which has a drop-down list with the following SQL Query data source:

SELECT SKUID, SKUName 
FROM View_COM_SKU

I have the "Has depending fields" option checked on this property. How can I use that value in another property?

My other property has "Depends on another field" checked and the following query:

SELECT soc.CategoryID, oc.CategoryDisplayName
FROM COM_SKUOptionCategory soc
JOIN COM_OptionCategory oc ON oc.CategoryID = soc.CategoryID
WHERE soc.SKUID = '{% TicketSKU %}'

I have tried various macro syntaxes to get this to work and am thus far unable to.

Recent Answers

Joshua Adams answered on February 24, 2016 21:21 (last edited on December 10, 2019 02:30)

Have you tried {% TicketSKU.Value |(identity)GlobalAdministrator%}?

Just a guess, you can use that in forms as macros for conditions, but if not, then you could always handle it through customizing the form and using whatever logic you have with C# and asp.net code.

0 votesVote for this answer Mark as a Correct answer