I feel like I'm VERY close to having this figured out, but can't get this last peice of the puzzle figured out.  In using DMX 5.2.2 on a DNN 4.8.4 install.

I'm using Template View trying to add colums for Custom Attributes that we have defined.  I've looked in the database and found that the ID for my desired attribute is "att124".  I can correctly get the actual data to display in the Item Template when I add the following line:

Man, I just now saw what a jumbled mess my post became. I can make my question much simpler.  In the Template View UI, when I am creating my sortable column headings for CUSTOM attributes, what is the correct syntax to use?  For instance, it seems to know what "sort=lastmodified" means.  However, it does NOT know what "sort=att124" means (where att124 is the key of my custom attribute). 

Any thoughts?

Hi Jason,

Your reasoning is correct. I'll have to investigate to see what's wrong. But you're correct in using att123 as key for sorting.

Peter

Did this get sorted out? I'm having the same issue.

Sorry it might be helpful if I give my versions
dnn 5.6.2
dmx 6.0.2

Hi Kevin,

What issue are you now having? The issue Jason had was resolved in DMX 5.2.7.

Peter

I'm modifying the View Template to display custom attributes, which it does beautifully by using att5 but when I add it to the sort I get the following error:


Error: Object reference not set to an instance of an object.

In: at Bring2mind.DNN.Modules.DMX.Entities.Entries.EntriesController.GetCollectionContents(Int32 PortalId, Int32 CollectionId, Int32 UserId, Boolean UserIsAdmin, String Locale, Boolean IncludePermissions, Boolean IncludeAttributes, Boolean IncludeDeleted, Boolean IncludeHidden, String Sort, Int32& TotalCount, Int32 StartRecord, Int32 EndRecord) at Bring2mind.DNN.Modules.DMX.TemplateView.ᜀ(String A_0, Dictionary`2 A_1, List`1& A_2, List`1& A_3) at Bring2mind.DNN.Modules.DMX.Services.Templating.ViewTemplate.ᜀ(String A_0, Dictionary`2 A_1, List`1& A_2, List`1& A_3) at Bring2mind.DNN.Modules.DMX.Services.Templating.Template.ᜀ(String A_0, Dictionary`2 A_1, List`1& A_2, List`1& A_3) at Bring2mind.DNN.Modules.DMX.Services.Templating.Template.ᜀ(Match A_0) at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator) at Bring2mind.DNN.Modules.DMX.Services.Templating.Template.ReplaceContents()




Code:
Discipline
Resulting url: http://www.privateinfo.co...=1&sort=att5&so=desc


This one does not give an error, but it also does not sort:
Discipline
Resulting url: http://www.privateinfo.co...ryid=1&sort=&so=desc

Sorry the codes are:
a href="[dmxmodule:url]entryid=[entry:entryid]&sort=att5&so=[query:!so|desc;][query:so=asc|desc;][query:so=desc|asc;]" Class="CommandButton">Discipline
and

a href="[dmxmodule:url]entryid=[entry:entryid]&sort=[entryattribute:att5]&so=[query:!so|desc;][query:so=asc|desc;][query:so=desc|asc;]" Class="CommandButton">Discipline

Indeed there is a bug there. Here is a quick workaround. Run this under Host > SQL:

UPDATE {databaseOwner}{objectQualifier}DMX_Attributes
SET [Key]='att'+CAST(AttributeId AS NVARCHAR),
ShowInUI=1
WHERE [Key] IS NULL
GO