Peter:

What row filter column name could I use to filter by the shorttext.text field?  I want to exclude files from the What's New module if they contain certain characters in the shorttext.text field.

 

Thanks,

Jim

Hi Jim,

ShortTexts are used for titles/names. So for the document list the field is 'Title'.

Peter

Thanks Peter. I tried that but still keep getting an error msg (Error loading What's New).

To confirm, I am trying to filter the What's New module's row filter with:

Deleted=0 AND IsApproved=1 AND (EntryType NOT LIKE '%Collection%') and Title like '%B%'

to show all new files that contain the letter B.

Thanks again,

Jim

Hi Jim,

Sorry, I replicated your findings and indeed this is not going to be possible. Title is returned in the SQL but the way the module was designed it injects the row filter into the where clause and it won't work as Title comes from a subquery. This means the complete subquery must be used:

Deleted=0 AND IsApproved=1 AND (Not EntryType LIKE '%Collection%') AND ISNULL((SELECT [Text] FROM {databaseOwner}{objectQualifier}DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='en-US'), (SELECT [Text] FROM {databaseOwner}{objectQualifier}DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='')) LIKE '%B%'

I tested this and it seems to work.

Peter