Can I create Query with articles that contains numbers on the title?

Lana9

Member
please how can I create Query with articles that includes numbers on the title, or shares the same word on the body or the title like "new" or "2020"
@appyet I really need this (sorry for reposting that)
 

abcPeacemaker

New Member
just add: lower(Title) LIKE '%new%' AND lower(Title) LIKE '%2020%'

I use the "lower()" function to remove any case sensitivity but "Title" by itself works.
The % signs are used in case there are characters before or after the keyword.
Use OR instead of AND if you need to.

You can also restrict the amount of feeds by querying only feed posts with a PubDate between NOW and time duration in Miliseconds.
(PubDate > [NOW] - 7889400000 AND lower(Title) LIKE '%new%')
 

abcPeacemaker

New Member
Hello,

You probably figured it out by now but... There's no jquery code needed. Just use he options when you add a web module. Use the Type: web link then choose from the options below.

IMG_20201009_065114.jpg
 

ahmedsadat

New Member
Hello,

You probably figured it out by now but... There's no jquery code needed. Just use he options when you add a web module. Use the Type: web link then choose from the options below.

View attachment 1861

Thanks for your kind reply, but my question for RSS feed module not for Web module.
Inside RSS feed there is two or three lines from article ( not full article) and downside there is button ( view website).
Eventhough if i set it for open in default browser, it woul not open website in system default browser. It is opening always with my app browser.
 

mohamad saied

New Member
أهلا،

ربما اكتشفت ذلك الآن ولكن ... ليس هناك حاجة إلى رمز jquery. فقط استخدم الخيارات عند إضافة وحدة ويب. استخدم رابط النوع: ويب ثم اختر من الخيارات أدناه.
روباما لا شاي '...
5 مليار مستقدم للعيان
nadfae 400 dular liaistikhdam al'iintirnit
5 مليارات زيادة المبيضات مقبل
100 dular eumulat Mutakarirat snwyan
500 مليار ديولار إيومولا
+ التجاوزات من 16 مستوعه
قبل العتلق - تفاويتها واسطفوتوكا!
الرجاء النقر فوق: https://5billionsales.com/affiliate/mohamadsayed
View attachment 1861
 
Top