I am working on a script that imports data from a SQL database developed by someone else. The date filter panes work just fine, except for the data provenient from tables that I imported from excel spreadsheets. I would like the date filter panes to work for all the data imported, wherever it comes from.
As I can see in the data model viewer, there is a linktable which has a field named Date that links to a table named Calendar, which contains fields as day, month, year, quarter, etc. The data I want to apply the filter to are those contained in tha tables CUSTOENTREGAS and CUSTOPROMOTORES (imported from excel spreadsheet). These two tables have date fields and are already linked to another table through CustomerID fields. It seems that I have to link them to the linktable (or other table) through their date fields.
Any help would be very appreciated!
This is the script for the link table:
AutoNumberHash128(cdFilial,cdRepres,cdCliente,CODP,dtLan,cdCir) as %LinkTableGeral
,cdFilial as [IDFilial]
,cdCliente as [IDCadastroGeral]
,cdRepres as [IDRepresentante]
,CODP as [IDProduto]
,dtLan as Data
,cdCir as [IDCirurgia]
,AutoNumberHash128(cdFilial,cdCliente,cdPed) as %IDPedido;