I am trying to create a landing page using the salesforce mobile offline capabilities. According to the documentation the landing page is in JSON format, which I am following. I have multiple list views on the landing page but the filters (inside 'where' as per documentation) I am putting on the landing page are not working. Some of the list views are date sensitive like show Today's Visits and show Visits in the next 7 days. I also created custom formula fields to return true if Date criteria is a match, but they are also not working. So I want help with the following:
1. What is the correct format to check against date in the "where" filter, like Datefield = TODAY() or Datefield= next_n_days:7?
2. Do formula fields work in the JSON? If so what is the correct format? (I created a formula field on the object, and I am mentioning it in the fields property as f_field__c: "Boolean" and 'where' property -> f_field__c:true)
3. Another error I am facing currently, when I remove all the filters, I see the list view records, but when I click "View More" to see the entire list it is unable to show it.
FYI my briefcase has the records that match the criteria.
Thank you for your time!
Hi @SUNNY PATWA, regarding the date filters I cannot use datefield = TODAY() or Datefield <= NEXT_N_DAYS:7 as this is not the correct format in JSON
I can't type "Datefield":"TODAY" or Datefield:"NEXT_N_DAYS:7" as its taking that as string value.
I even tried creating a formula field which returns true when the date conditions meet and I am setting them correctly as f_field__c: true in where clause. But still the records do not show up.
Is there a way to check if records stored in briefcase builder have all the fields?
Regarding the View more issue, I have not set any limits in JSON for pagination.
Thanks,
Ishan
