Advanced Query and List_SortColumn

Rienk Eisma

Question

Hi all,

I'm having some problems with combining list_sort with an advanced query list.

I did find some other posts and answers about this, but the existing information does not offer the information I need.

First of all; my advanced query with "order by @orderby" and "expand inline" set to "yes" works fine when entering a test input.

My problem is that I can't seem to figure out how to pass an orderby parameter to the "refresh query". The refresh query uses the default orderby value.

When I debug the input parameter of Refresh AdvQuery2 is always the default input parameter.

It is my understanding that by clicking the column_name (which is transformed in a link because the list_sortcolumn widget is dragged into the same cell), somehow the ColumnName and the Column Order should be passed to the refresh action. The column_name to determine which column is to be sorted, and the order to determine asc or desc.

Unfortunately, I can't figure out how this is accomplished. When I click the Column_Name the refresh action is called. I just can't figure out how to pass the column_name as an orderby parameter to the refresh action.

Any pointers?

Thanks in advance,

Cheers, Rienk Eisma

17 Dec 2012

Hugo Pinheiro

Staff

Hello Rienk Eisma,

Are you using the List_SortColumn_GetOrderBy(TableRecord_Id,DefaultOrderBy) function to set the order by on the refresh query?

Regards,
Hugo Pinheiro

18 Dec 2012

Rienk Eisma

Hi Hugo,

I fixed it thanks to your pointer.

At first I got the '<StructereName>' found in 'Expand Inline' parameter is an unknown Entity

The way I solved it is as follows:

In the list_SortColumn widget property the "column" value cannot be {STRUCTURENAME}.[COLUMNNAME]. It must be set as plain "ColumName".

Second, I changed the orderby parameter for the refresh advancedquery from: List_SortColumn_GetOrderBy(TableRecords1.Id, "{StructureName}.[AttributeName]")

to: List_SortColumn_GetOrderBy(TableRecords1.Id, "ENCONTACT.[NAME]")

18 Dec 2012

Rienk Eisma

I pushed submit too soon :)

It seems the sort_by must be called by the name you use in the select statement, not the structure name.

Hope this is helpful for someone.

Cheers, Rienk Eisma

18 Dec 2012

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines