Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 5.x > Portal Engine > BizForm Field with Multiple Choice Control - Using Proper SQL Query

View modes:

Member

PeterPC - 9/27/2011 9:22:00 PM

BizForm Field with Multiple Choice Control - Using Proper SQL Query

Hello,

In a BizForm, I have a SQL query in place to generate the multiple choice options:
SELECT ItemName, ItemName from myclass_Items
(This works fine)

but I am looking to do something like
SELECT ItemName, ItemName from myclass_Items
WHERE the document's alias path starts with "/mypath/anotherpath"

Is that possible in the portal to do without custom code?
thanks

Member

kentico_michal - 9/30/2011 5:47:38 AM

RE:BizForm Field with Multiple Choice Control - Using Proper SQL Query

Hello,

Could you please decribe in more detail what sql query you want to write and what would you like to achieve?

Anyway, you can use any Where condition, apart from that it is also possible to use context macros, for example {%nodealiaspath%}: Macro expressions

Best regards,
Michal Legen

Top