Filter on checkbox is not available in d365 x++

 Filter on checkbox is not available in d365 x++ on which code is written.

Grid column header filtering/sorting

Some columns in a grid may not be filterable. In these cases, the column header will not be clickable. From a technical perspective, only columns corresponding to fields in a SQL table can be filtered on or sorted. Columns whose values are computed via code are not filterable or sortable using grid column headers, the Filter pane, QuickFilter, or Advanced filter or sort.



Comments

Post a Comment

Popular posts from this blog

Convert table rows to JSON in X++ D365

To convert table rows to JSON in X++ , you can use the JSON serialization capabilities provided by X++'s built-in classes. Here's an example demonstrating how to achieve this:   Assuming you have a table named MyTable with fields Field1, Field2, and Field3, and you want to convert its rows to a JSON array:   static void ConvertTableRowsToJson(Args _args) {      MyTable myTable;      str jsonString;      int i;        // Create an empty array to store JSON objects      Array jsonArray = [];       // Retrieve data from the table      while select * from myTable      {          // Create a JSON object for each row          JsonObject jsonObject = new JsonObject();          jsonObject.addField("Field1", myTable.Field1);          jsonObject.addField("Field2", ...
Read more

Create custom workflow in D365 X++

Image
 For the creation of Custom Workflow in Dynamics 365 F&O, Kindly follow the following steps; 1. Create a custom Enum WorkflowStatus or you can use an existing one.   2. Create a new table EmployeeLeave as defined below and add the above Enum as a field and name it LeaveStatus . 3. Create a new form EmployeeLeaveForm by using the above table as a data source.   4. Create a new Display Menu Item EmployeeLeaveForm for the above form and add to any  Module by creating an extension of the Module Menu from the application Explorer. 5. Create a new Query EmployeeLeaveQuery  and add  EmployeeLeave as a data source.                 6. Create a new Workflow Category EmployeeLeaveCategory .   7. Create a new workflow type EmployeeLeaveWorkflowType .   • Category: Select the workflow category from the previous step • Query: Select the query created for the document table • Document menu item: Sel...
Read more

How to write Download Job or Push Job in D365 for new Custom Table?

 If you want to write the download/push job in D365. Please follow the following steps; Step # 1: You have to create the new Custom Table in the dbo schema of the database by using AOT.  Or you can create it simply in the database for testing. For Example.  You create a Table of books. dbo.DRBOOK Code: IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('[dbo].[DRBOOK]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[DRBOOK]( TITLETAG nvarchar(MAX) NOT NULL, [DATAAREAID] nvarchar(4) NOT NULL, [PARTITION] bigint NOT NULL, [RECID] bigint NOT NULL     CONSTRAINT [I_dbo_DRBOOK] PRIMARY KEY CLUSTERED ( [TITLETAG] ASC, [DATAAREAID] ASC, [PARTITION] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END; GO GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[dbo].[DRBOOK] TO [DataSyncUsersRole] GO GRANT SELECT ON [dbo].[DRBOOK] TO [User...
Read more