Skip to main content

Notifications

Business Central forum
Answered

Filtering Custom fields from standard fields

editSubscribe (1) ShareShare
ReportReport
Posted on by 9
Hello everyone,
 
I want to filter out custom fields from the standard fields in the /Field/ table is there any way considering there is no specific prefix or suffix added to all the custom fields.
or else any other alternative which can be helpful for listing out the custom fields either in UI side or from the al script code.
 
Thanks for the help.
  • RR-08051107-0 Profile Picture
    RR-08051107-0 9 on at
    Filtering Custom fields from standard fields
    Thanks Saurav,
    I just did that only, it worked fine with these ranges: -
    • (50000 .. 99999 | 1000000 .. 69999999 | 70000000 .. 74999999)
    • (PTE | RSP | APPSOURCE)
  • Verified answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 10,155 User Group Leader on at
    Filtering Custom fields from standard fields
    Hi,
     
    You can create a page based on table field.
     
    Filter the records in that page with No. - 50000..99999. All fields in list are custom fields in base Microsoft and other ISV tables. 
     
    Hopefully this helps. If you have additional questions, please let me know. 
     
    Regards,
    Saurav Dhyani
  • Martin Dráb Profile Picture
    Martin Dráb 223,308 Super User on at
    Filtering Custom fields from standard fields
    Moved from D365 general forum.
  • RR-08051107-0 Profile Picture
    RR-08051107-0 9 on at
    Filtering Custom fields from standard fields
    Hi Layan,
     
    The product i am using is - Dynamics 365 Business Central
  • Layan Jwei Profile Picture
    Layan Jwei 3,079 Super User on at
    Filtering Custom fields from standard fields
    Hi RR,
     
    Are you talking about D365FO? As there are many D365 products
     
    Thanks,
    Layan Jweihan

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans