Page Control Search

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Line Amount (LCY)' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to LINE AMOUNT (LCY)

Seq NoPage NumberPage NameControl Name
192Job Ledger EntriesLine Amount (LCY) Search
293Job Ledger Entries PreviewLine Amount (LCY) Search
3201Job JournalLine Amount (LCY) Search
41007Job Planning LinesLine Amount (LCY) Search