SortDataByKey

[link76]

Hello,

I would like to filter my DG Form a column text (template row: field "Ospedale") but does not work:

Code: Select all

on MouseUp
dispatch "SortDataByKey" to group "DataGrid_Att_h_fasce" with "Ospedale", "text", "Ascending", "false"
dispatch "RefreshList" to group "DataGrid_Att_h_fasce" 
end MouseUp

thank you

[Klaus]

I would like to filter my DG Form a column text (template row: field "Ospedale")

Sorry, don't understand!?
Do you have a column named "Ospedale" in your datagrid?

[link76]

I would like to filter my DG Form a column text (template row: field "Ospedale")

Sorry, don't understand!?
Do you have a column named "Ospedale" in your datagrid?

I have a DG style Form, in row template is a label (column) "Ospedale", I would like to sort the values (Ascending or Descending),

thx

[Klaus]

Hmm, syntax is correct, sorry no idea so far...

I would however leave out the last line, because the last parameter of SortDataByKey
defines if RefreshList is also applied to the datagrid after sorting

Code: Select all

on MouseUp
    dispatch "SortDataByKey" to group "DataGrid_Att_h_fasce" with "Ospedale", "text", "Ascending", "TRUE"
end MouseUp

Best

Klaus

[quailcreek]

Old thread but same issue. Has anybody gotten this to work on a DG form? I have a DG form that's populated using dgText so I can filter it later.

"More" is the name of the fld in the DG row template. Nothing seems to work.

Code: Select all

dispatch “SortDataByKey” to grp "PracticeList_DG" with "More", "international", "descending", "false"

on FillInData pDataArray
   set the text of fld "Name" of me to  pDataArray["Name"]
   set the text of fld "More" of me to  pDataArray["PreformanceLevel"] 
end FillInData

[sritcp]

On LC 6.7.6, the following code

Code: Select all

dispatch "SortDataByKey" to group "DgForm1" with "Field1", "text", "descending", "false"

works perfectly for me.

Something to do with LC7?

Regards,
Sri

[quailcreek]

I figured it out. I have thumb nail images in the DG. This, for some reason, stops the sort from happening. I submitted a bug report. Thanks for the reply. For now I'll remove the images.

[quailcreek]

OOpps. I found the problem. I copied the SortDataByKey from someplace. To lazy to type. and I ended up with curly quotes. Mybad.

[bn]

Hi Tom,

I've looked at
Bug 15802
that you reported. I have also seen your comment that it is not a bug.

The status is "confirmed"

You as the author can change the status to "Not a bug"

That way it reduces unnecessary open tickets in Quality Control Center. It would be a nice gesture and save QCC some time.

Kind regards
Bernd

Edit: when you open a bug report and refer to it it would be nice to also put the bug number. Thank you.

[bn]

Hi Tom,

thanks for setting Bug 15802 to "Not a Bug"

Kind regards
Bernd

[quailcreek]

No worries.

[quailcreek]

I got the sort, sorted out. But I have another question. When I sort on a key (ascending) where some of the entries are empty, the empty ones are at the top. Is there a way to sort ascending and have the empty values at the bottom?