Skip to Content (Press Enter)
2011-06-15 10-52-56
Frits Frederiks
3Views
3Comments
RichWidgets List_SortColumn issue
Question
Dear users,

Could someone tell me how to use the orderby parameter (which works great when using the standard query) if i try to use an advanced query?

My query:

SELECT {EVENT}.[EventId],{EVENT}.[EventName],{EVENT}.[EventType],{EVENT}.[EventCode],{EVENT}.[DateFrom],{EVENT}.[DateEnd],
{EVENT}.[ExhibitionCost],{EVENT}.[TravelCost],{EVENT}.[HotelCost],{EVENT}.[LogisticCost],{EVENT}.[MarketingCost],{M_EVENT_TYPE}.[Name],
{M_City}.[Name],{M_COUNTRY}.[Country],{EVENT}.[Status]
From {EVENT},{M_EVENT_TYPE},{M_City},{M_COUNTRY}
where {EVENT}.[EventType]={M_EVENT_TYPE}.[Id] and
{EVENT}.[City]={M_City}.[Id] and
{EVENT}.[Country]={M_COUNTRY}.[Id] and

(( @StartDate between {EVENT}.[DateFrom] and {EVENT}.[DateEnd]) or (@EndDate  between {EVENT}.[DateFrom] and {EVENT}.[DateEnd]))  and  @CountryCode = {M_COUNTRY}.[Country]

 order by @Orderby





Orderby i added as a parameter ( value what i assign t the parameter is  
List_SortColumn_GetOrderBy(EventTable.Id, "{EVENT}.[EventName]")
in the advanced query but with no luck; this is what i get when i try to open the page:
Error in advanced query GetEvents in Preparation in event_pla_list in MainFlow in ET (SELECT {EVENT}.[EventId],{EVENT}.[EventName],{EVENT}.[EventType],{EVENT}.[EventCode],{EVENT}.[DateFrom],{EVENT}.[DateEnd], {EVENT}.[ExhibitionCost],{EVENT}.[TravelCost],{EVENT}.[HotelCost],{EVENT}.[LogisticCost],{EVENT}.[MarketingCost],{M_EVENT_TYPE}.[Name], {M_City}.[Name],{M_COUNTRY}.[Country],{EVENT}.[Status] From {EVENT},{M_EVENT_TYPE},{M_City},{M_COUNTRY} where {EVENT}.[EventType]={M_EVENT_TYPE}.[Id] and {EVENT}.[City]={M_City}.[Id] and {EVENT}.[Country]={M_COUNTRY}.[Id] and  (( @StartDate between {EVENT}.[DateFrom] and {EVENT}.[DateEnd]) or (@EndDate  between {EVENT}.[DateFrom] and {EVENT}.[DateEnd]))  and  @CountryCode = {M_COUNTRY}.[Country]   order by @Orderby): The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.
(This detailed error is not shown in the public area)





Thank you in advance
0
0
23 Feb 2011
Copy Link
2019-08-20 01-57-17
RafaOutSystems
 
MVP
Hi Frits,

Please check your @Orderby parameter... "expand inline" property must be configured with YES...



Regards,
Rafael Pereira
1
0
23 Feb 2011
Copy Link
2011-06-15 10-52-56
Frits Frederiks
solved
0
0
23 Feb 2011
Copy Link
2019-08-20 01-57-17
RafaOutSystems
 
MVP
Happy to help you!

Regards,
Rafael Pereira
0
0
23 Feb 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.